CIW 1D0-541 Exam Questions Instant Access

Question 1

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

table?

A25

D20

Answer : B

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

Which three pieces of information did E. F. Codd describe as necessary to retrieve a data value

from a relational database?

AAttribute, domain, and tuple

BEntity, relation name, and domain

CTable name, primary key, and entity

DAttribute, relation name, and primary key

Answer : D

Question 4

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

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

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

would return all complete tuples for order dates in 2002, arranged by amount from lowest to

highest?

ASELECT *
FROM Orders
WHERE Order_Date LIKE _02
ORDER BY Amount;

BSELECT (Order_Date, Amount)
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;

CSELECT *
FROM Orders
WHERE Order_Date LIKE _02
ORDER BY Order_No;

DSELECT *
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;

Answer : D

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 v5 Database Design Specialist 1D0-541 Exam Questions