Free 1D0-541 Exam Dumps

Question 16

Which type of entity must reference another entity for its data to be meaningful?

A. Weak
B. Strong
C. Foreign
D. Primary

Correct Answer:A

Question 17

What is a candidate key?

A. The primary key for an entity
B. The key that identifies every instance of an entity
C. Multiple primary keys that are joined together to form a composite key
D. A key that may be used to form the primary key

Correct Answer:D

Question 18

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

A. Attribute, domain, and tuple
B. Entity, relation name, and domain
C. Table name, primary key, and entity
D. Attribute, relation name, and primary key

Correct Answer:D

Question 19

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to highest?
1D0-541 dumps exhibit

A. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Amount;
B. SELECT (Order_Date, Amount) FROM OrdersWHERE Order_Date LIKE ORDER BY Amount;
C. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Order_No;
D. SELECT *FROM OrdersWHERE Order_Date LIKE ORDER BY Amount;

Correct Answer:D

Question 20

Which type of relational integrity is violated if a primary key in a database has a null value?

A. Entity integrity
B. Domain integrity
C. Domain constraints
D. Referential integrity

Correct Answer:A