CIW 1D0-541 Exam Questions Instant Access

Question 1

The exhibit shows a relation for a companys projects. Which candidate key(s) would best

serve as the primary key for this relation?

AS_Date and E_Date

BProj_ID

CItem_Num and E_Date

DProj_ID and Item_Num

Answer : D

Question 2

Which pair of relational algebraic operations requires union compatibility?

AProjection and Cartesian product

BSelection and projection

CIntersection and difference

DCartesian product and intersection

Answer : C

Question 3

Which of the following best describes the information contained in the data dictionary (or

system catalog)?

AMetadata

BData model

CTable data

DMetafile

Answer : A

Question 4

Which term best describes one or more database operations that are executed as a single unit?

AUpdate

BTransaction

CProcedure

DSingleton

Answer : B

Question 5

What is a relational database domain?

AA group of attributes

BA set of permissible tuple values

CA collection of related data items

DA set of permissible attribute values

Answer : D

Question 6

Your company must choose which type of database to use for a new project. Which of the

following lists three characteristics of file-based database systems?

ARepetition of data, application program flexibility, and data centralization

BIncompatibility of files, tabular data structures, and data dependence

CSeparation of data, repetition of data, and data independence

DApplication program inflexibility, data dependence, and separation of data

Answer : D

Question 7

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

CIW v5 Database Design Specialist 1D0-541 Exam Questions