Question 1

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

Options :

A : m:m

B : m:n

C : 1:1

D : 1:n

Answer: B

Question 2

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

Question 3

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 4

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 5

Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

Options :

A : INSERT INTO Employee VALUES(0005, Tim, Bogart, 03-15-77);

B : INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);

C : INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

D : INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

Answer: D

Free 1D0-541 Mock Exam – Practice Online Confidently

Buying Options: