CIW 1D0-541 Exam Questions Instant Access

Question 1

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

Question 2

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 3

Which subset of Structured Query Language (SQL) is used to perform operations such as data

retrieval or deletion on the data contained in a database?

AData Control Language

BData Definition Language

CData Formatting Language

DData Manipulation Language

Answer : D

Question 4

Which type of relational integrity is violated if a primary key in a database has a null value?

AEntity integrity

BDomain integrity

CDomain constraints

DReferential integrity

Answer : A

Question 5

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

properly add information for a new employee?

AINSERT INTO Employee
VALUES(0005, Tim, Bogart, 03-15-77);

BINSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0004, Tim, Bogart, 03-15-77);

CINSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);

DINSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);

Answer : D

Question 6

What is the most important service provided by a database management system?

AProvides support for a data manipulation language

BAllows users to store data in a distributed data repository

CProvides support for data formatting language commands

DTranslates procedural commands into non-procedural commands

Answer : A

Question 7

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

ABoyce-Codd normal form

BFirst normal form

CSecond normal form

DThird normal form

Answer : C

CIW v5 Database Design Specialist 1D0-541 Exam Questions