Question No. 1

Consider the relation shown in the exhibit. Which of the following SQL statements would

properly remove all tuples for New York customers?

ADELETE *
FROM Customers
WHERE Sales_Office = New York;

BDELETE
FROM Customers
WHERE Sales_Office = New York;

CDELETE *
FROM Customer
WHERE Sales_Office <> New York;

DDELETE
FROM Customers
WHERE Sales_Office NOT LIKE New York;

Show Answer

Correct Answer: B

Question No. 2

Which three pieces of information did E. F. Codd describe as necessary to retrieve a data value

from a relational database?

AAttribute, domain, and tuple

BEntity, relation name, and domain

CTable name, primary key, and entity

DAttribute, relation name, and primary key

Show Answer

Correct Answer: D

Question No. 3

Which of the following best describes a composite key?

AA composite key is a primary key and foreign key that consists of the first two attributes of a
relation.

BA composite key is a primary or foreign key defined by its parent key attributes.

CA composite key is a foreign key that consists of the same attributes as the primary key from a
related table.

DA composite key is a primary or foreign key that consists of two or more attributes of a relation.

Show Answer

Correct Answer: D

Question No. 4

Using the Customer and Sales_Rep relations shown in the exhibit, you must datermine a relational

algebraic expression that will result in the following relation:

Which of the following relational algebraic expressions would result in this relation?

AOption A

BOption B

COption C

DOption D

Show Answer

Correct Answer: A

Question No. 5

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the

following SQL statements would create an intersection of the two relations with the widest variety

of Structured Query Language dialects?

ASELECT *
FROM Dept1_Parts
AND
(SELECT *
FROM Dept2_Parts);

BSELECT *
FROM Dept1_Parts
INTERSECTION
(SELECT *
FROM Dept2_Parts);

CSELECT *
FROM Dept1_Parts
WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

DSELECT *
FROM Dept1_Parts
WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

Show Answer

Correct Answer: D

Free CIW 1D0-541 Exam Actual Questions