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

numbers?



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