Question 1

With regard to databases, what is normalization?

Options :

A : The process of reducing the cardinality of a relation

B : The process of organizing and refining relations

C : The process of duplicating data to reduce the number of tables

D : The process of limiting data stored in a table to a specific range of values

Answer: B

Question 2

Which of the following best describes a composite key?

Options :

A : A composite key is a primary key that consists of the first two attributes of a relation

B : A composite key is a primary or foreign key defined by its parent keys.

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

D : A composite key is a primary or foreign key that consists of two or more attributes of a relation

Answer: D

Question 3

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?

Options :

A : UPDATE Sales_Rep_No IN Orders SET(Sales_Rep_No = 110 WHERE Sales_Rep_No = 108);

B : UPDATE Orders SET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;

C : UPDATE Orders SET Sales_Rep_No = 110;

D : UPDATE Orders WHERE Sales_Rep_No = 108 SET Sales_Rep_No = 110;

Answer: B

Question 4

Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

Options :

A : Create intermediate entities

B : Create a logical data model.

C : Resolve many-to-many relationships

D : Identify and resolve complex relationships.

Answer: B

Question 5

What improvement can be made to file-based databases to overcome their limitations?

Options :

A : Implement a tabular structure.

B : Gather files in a distributed repository

C : Use a hierarchical database file system.

D : Tightly couple database structure to database application programs.

Answer: A

Free 1D0-541 Mock Exam – Practice Online Confidently

Buying Options: