CIW 1D0-541 Exam Practice Test Instant Access

Question 1

Consider the following relations shown in the exhibit. Which of the following SQL statements

would return the Customers2 relation from the Customers relation?

ASELECT *
FROM Customers
WHERE Satisfaction_Rate <= 80
OR Satisfaction_Rate >= 90;

BSELECT *
FROM Customers
WHERE Satisfaction_Rate IN (80 AND 90);

CSELECT *
FROM Customers
WHERE Satisfaction_Rate >= 80
AND Satisfaction_Rate <= 89;

DSELECT *
FROM Customers
WHERE Satisfaction_Rate
BETWEEN (80, 90);

Answer : C

Question 2

What is the highest normal form of the relation(s) shown in the exhibit?

ASecond normal form

BFirst normal form

CBoyce-Codd normal form

DThird normal form

Answer : A

Question 3

Your database administrator has disallowed a group of users from making alterations to the

Employees table in your corporate database. The users, known as Group_2, previously had full

privileges with the Employees table. Which of the following SQL statements properly removes

any alteration privileges from Group_2?

AREVOKE
INSERT, UPDATE, DELETE
ON Employees
FROM Group_2;

BREVOKE
UPDATE
FOR Employees
FROM Group_2;

CREVOKE
INSERT, UPDATE, DELETE
ON Employees
TO Group_2;

DREVOKE
UPDATE, DELETE
FOR Employees
FROM Group_2;

Answer : A

Question 4

What is a domain?

AA normalized set of data applicable to a particular relation

BA combination of attributes for a relation

CA definition of permissible values for one or more attributes

DA set of permissible values for one or more relations

Answer : C

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

Your enterprise has created a database and database application. The testing phase for the

project has started. Which of the following best describes white-box testing of the projects

software?

AThe database designer tests the software because he or she is able to make necessary changes to
the underlying code for the software.

BA user who has no knowledge of the softwares underlying code tests the software.

CSomeone other than the database designer tests the software. This person has no access to the
underlying code and attempts to use the
software only in ways not considered by the software designers.

DA person tests the software and submits suggestions to the software's underlying code. This
person is someone other than the database
designer, but has access to the softwares underlying code.

Answer : D

Question 7

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

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