CIW 1D0-541 Exam Practice Test Instant Access

Question 1

Your enterprise is developing a database system that will contain highly sensitive data.

Security of the data will take priority over database processing speed. Which database protection

technique should be employed?

ABackups

BUser views

CEncryption

DIntegrity controls

Answer : C

Question 2

Which mechanism provides database users with controlled access to the database through the

use of virtual tables?

AView

BData dictionary

CDatabase control language

DDatabase management system

Answer : A

Question 3

Consider the following relational algebraic expression:

Which of the following SQL statements is equivalent to this relational algebraic expression?

ASELECT Sales_Rep_No(108)
FROM Orders;

BINSERT INTO Orders
VALUES(Sales_Rep_No = 108)
WHERE Sales_Rep_No = NULL;

CSELECT *
FROM Orders
WHERE Sales_Rep_No = 108;

DSELECT *
FROM Orders
WHERE Sales_Rep_No = 108;

Answer : C

Question 4

Consider the Information Engineering diagram in the exhibit showing the relations

BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

A11

B1n

Cn:m

Dm:n

Answer : B

Question 5

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?

AOption A

BOption B

COption C

DOption D

Answer : A

Question 6

The exhibit shows a table called Activity Relation that relates a unique student identification

number with a sports activity and a fee for participating in that activity. A student can participate

in only one activity. The key for the relation is Student_ID. What consequence would occur if the

tuple for Student_ID 1001 were removed?

AAn update anomaly would occur.

BAn insertion anomaly would occur.

CA deletion anomaly would occur.

DBoth an insertion anomaly and a deletion anomaly would occur.

Answer : C

Question 7

Consider the table for an employee database shown in the exhibit. What is the cardinality of

the table?

B20

D25

Answer : C

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