CIW 1D0-541 Exam Practice Test Instant Access

Question 1

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

following lists four advantages of using a DBMS?

AManagement of data redundancy, increased data integrity, increased data dependence, and
increased application complexity

BConsistency of data, adherence to standards, managed concurrency, and increased software
complexity

CIncreased data access, increased data backup and recovery, data sharing, and consistency of data

DIncreased data security, increased data integrity, increased data independence, and
decentralization of data

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?

AINSERT INTO Employee
VALUES(0005, Tim, Bogart, 03-15-77);

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

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

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

Answer : D

Question 3

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

AEntity integrity

BDomain integrity

CDomain constraints

DReferential integrity

Answer : A

Question 4

What is a data dictionary?

AA system catalog containing user data

BAn area of the database that is directly accessible by the user

CData that is stored in tables and is only accessible by the DBMS

DMetadata that is stored in tables and is only accessible by the DBMS

Answer : D

Question 5

Which statement accurately describes a characteristic of attributes?

AThe ordering of attributes in a table is significant.

BAn attribute contains values from multiple domains.

CAn attribute name can be used only once per table.

DAn attribute name can be used only once in a relational database system with multiple tables.

Answer : C

Question 6

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

AProvides support for a data manipulation language

BAllows users to store data in a distributed data repository

CProvides support for data formatting language commands

DTranslates procedural commands into non-procedural commands

Answer : A

Question 7

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

rarely occur?

ALocking

BTime stamps

COptimistic

DSerialization

Answer : C

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