CIW 1D0-541 Exam Practice Test Instant Access

Question 1

Using the Customer and Sales_Rep relations shown in the exhibit, you must datermine a relational

algebraic expression that will result in the following relation:

Which of the following relational algebraic expressions would result in this relation?

AOption A

BOption B

COption C

DOption D

Answer : A

Question 2

Which of the following occurs in a relation when records are added or removed?

AThe number of domains changes.

BThe attributes in the table change.

CThe cardinality of the relation is fixed but the degree varies.

DThe degree of the relation is fixed but the cardinality varies.

Answer : D

Question 3

The exhibit shows a table called Student Relation that tracks all information related to a

students courses, professors and sites. What would be the consequence of removing all records for

a student with the ID 1311?

AOnly an update anomaly would occur.

BAn insertion anomaly would occur.

CA deletion anomaly would occur.

DAn update anomaly and a deletion anomaly would occur.

Answer : C

Question 4

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 5

Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples

for Student_ID 1003 must be performed. It is necessary to change one of the activities from

swimming to tennis. The Student_ID and Activity attributes make up the primary key for the

Recreation relation. All related information must be altered, as well. Which SQL statement or

statements would best accomplish this?

AUPDATE Recreation
SET Activity, Activity_Fee ('Tennis', 100)
WHERE Student_ID = 1003;

BUPDATE TABLE Recreation
SET ACTIVITY = 'Tennis', Activity_Fee = 100
WHERE Student_ID = 1003
AND Activity = Swimming;

CUPDATE Recreation
SET Activity = 'Tennis', Activity_Fee = 100
WHERE Student_ID = 1003
AND Activity = 'Swimming';

DDELETE Activity
FROM Recreation
WHERE Student_ID = 1003;
INSERT INTO Recreation
VALUES (1003, 'Tennis', 100);

Answer : C

Question 6

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 7

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

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