CIW 1D0-541 CIW v5 Database Design Specialist Exam Practice Test

Page: 1 / 14
Total 128 questions
Question 1

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in

the exhibit:

Which of the following relational algebraic expressions would result in the given table?

Answer : A

Question 2

Which of the following describes two desirable characteristics of a primary key?

Answer : B

Question 3

Which of the following occurs in a relation when records are added or removed?

Answer : D

Question 4

The exhibit shows a table called Student Relation that tracks all information related to a

students courses, professors and sites. What would be the consequence of removing all records for

a student with the ID 1311?

Answer : C

Question 5

Consider the following four database design activities:

1 - Design user views.

2 - Select a DBMS.

3 - Apply normalization.

4 - Determine entities.

Which choice shows the correct ordering of these activities, from first to last, by assigned


Answer : D

Question 6

Your enterprise must decide whether to use a database management system. Which of the

following best describes the overall functionality of a DBMS?

Answer : D

Question 7

In which situation would the DBMS use a serial schedule to execute the transactions?

Answer : C

Page:    1 / 14   
Total 128 questions