CIW 1D0-541 Exam Questions Instant Access

Question 1

Which of the following definitions applies to all types of databases?

AData that is stored as tables

BSoftware that manipulates data

CData that is stored in a structured manner

DData records that are stored sequentially in a file

Answer : C

Question 2

Consider the following relational algebraic expression as well as the Dept1_Parts and

Dept2_Parts relations shown in the exhibit,

Which of the following relations would result from the given relational algebraic expression?

AOption A

BOption B

COption C

DOption D

Answer : C

Question 3

Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at

the ends of the connecting line indicate?

ADegree of a relation

BCardinality of a relation

CPrimary key of a relation

DDeterminant of a relation

Answer : B

Question 4

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

AThe number of domains changes.

BThe attributes in the table change.

CThe cardinality of the relation is fixed but the degree varies.

DThe degree of the relation is fixed but the cardinality varies.

Answer : D

Question 5

Which security technique limits access by unauthorized users to parts of an enterprise

database?

AViews

BConcurrency

CLocking

DIntegrity controls

Answer : A

Question 6

Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at

the ends of the connecting line indicate?

ADegree of a relation

BCardinality of a relation

CPrimary key of a relation

DDeterminant of a relation

Answer : B

Question 7

Consider the following SQL statement and the Orders relation shown in the exhibit:

How many records should be returned?

ATwo records

BThree records

CFour records

DFive records

Answer : C

CIW v5 Database Design Specialist 1D0-541 Exam Questions