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

Page: 1 / 14
Total 128 questions
Question 1

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

following lists four advantages of using a DBMS?



Answer : C


Question 2

Consider the relation shown in the exhibit. Which of the following SQL statements would

properly add information for a new employee?



Answer : D


Question 3

Which type of relational integrity is violated if a primary key in a database has a null value?



Answer : A


Question 4

What is a data dictionary?



Answer : D


Question 5

Which statement accurately describes a characteristic of attributes?



Answer : C


Question 6

What is the most important service provided by a database management system?



Answer : A


Question 7

Which concurrency control method should be used only when conflicts between transactions

rarely occur?



Answer : C


Page:    1 / 14   
Total 128 questions