Question 1

Consider the following relational algebraic expression as well as the Employee and Department relations shown in the exhibit: Which of the following relations would result from the given relational algebraic expression?

Options :

A :

B :

C :

D :

Answer: D

Question 2

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 3

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 4

Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

Options :

A : Degree of a relation

B : Cardinality of a relation

C : Primary key of a relation

D : Determinant of a relation

Answer: B

Question 5

Which area of database security involves maintaining access to enterprise data?

Options :

A : Theft

B : Privacy

C : Availability

D : Confidentiality

Answer: C

Smartly Prepare Exam with Free Online 1D0-541 Practice Test

Buying Options: