CIW 1D0-541 Exam Questions Instant Access

Question 1

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

the table?

B20

D25

Answer : C

Question 2

Consider the Registration relation shown in the exhibit. Which of the following SQL

statements would return the Registration2 relation from the Registration relation?

ASELECT Course_Code
FROM Registration;

BSELECT *
FROM Registration
WHERE Registration_ID = 1003
AND Registration_ID = 1005;

CSELECT *
FROM Registration
WHERE Course_Code = 'A4343';

DSELECT Registration_ID, Student_ID, First_Name, Last_Name
FROM Registration
WHERE Course_Code = 'A4343';

Answer : C

Question 3

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 4

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

return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80

unless the Sales_Office is located in Atlanta?

ASELECT *
FROM Customers
WHERE Satisfaction_Rate > 80
OR Sales_Office = Atlanta;

BSELECT *
FROM Customers
WHERE Satisfaction_Rate <= 80
AND Sales_Office = Atlanta;

CSELECT *
FROM Customers
WHERE Satisfaction_Rate >= 80;

DSELECT *
FROM Customers
WHERE Satisfaction_Rate >= 80
AND NOT Sales_Office = Atlanta;

Answer : A

Question 5

Consider the Registration relation shown in the exhibit. Which of the following SQL

statements would return the Registration2 relation from the Registration relation?

ASELECT Course_Code
FROM Registration;

BSELECT *
FROM Registration
WHERE Registration_ID = 1003
AND Registration_ID = 1005;

CSELECT *
FROM Registration
WHERE Course_Code = 'A4343';

DSELECT Registration_ID, Student_ID, First_Name, Last_Name
FROM Registration
WHERE Course_Code = 'A4343';

Answer : C

Question 6

In a relational database, which term describes a single table consisting of rows and columns?

AEntity

BMatrix

CRelation

DData dictionary

Answer : C

Question 7

Which component in the three-tier database architecture handles the data-processing and

business logic?

AThin client

BFat client

CDatabase server

DApplication server

Answer : D

CIW v5 Database Design Specialist 1D0-541 Exam Questions