CIW 1D0-541 Exam Practice Test Instant Access

Question 1

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

enter data from the Customers relation into the Atlanta_Customers relation?

AINSERT INTO Atlanta_Customers
VALUES(
SELECT *
FROM Customer s
WHERE Sales_Office = Atlanta);

BINSERT INTO Atlanta_Customers
SELECT *
FROM Customers
WHERE Sales_Office = Atlanta;

CINSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No
FROM Customers
WHERE Sales_Office = Atlanta;

DINSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No
FROM Customers
WHERE Sales_Office = Atlanta;

Answer : C

Question 2

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 3

Consider the following four database design activities:

1 - Design user views.

2 - Select a DBMS.

3 - Apply normalization.

4 - Determine entities.

Which choice shows the correct ordering of these activities, from first to last, by assigned

numbers?

A1, 2, 3, 4

B3, 4, 1, 2

C4, 1, 3, 2

D4, 2, 3, 1

Answer : D

Question 4

Which type of entity must reference another entity for its data to be meaningful?

AWeak

BStrong

CForeign

DPrimary

Answer : A

Question 5

Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at

the ends of the connecting line indicate?

ADegree of a relation

BCardinality of a relation

CPrimary key of a relation

DDeterminant of a relation

Answer : B

Question 6

Which concurrency control method should be used only when conflicts between transactions

rarely occur?

ALocking

BTime stamps

COptimistic

DSerialization

Answer : C

Question 7

Which relational algebraic operation is used to select specific columns (attributes) from a

relation?

AUnion

BDifference

CProjection

DIntersection

Answer : C

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