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

Consider the following SQL statement and the Orders relation shown in the exhibit:

How many records should be returned?

ATwo records

BThree records

CFour records

DFive records

Answer : C

Question 7

Which subset of Structured Query Language (SQL) is used to limit access to a database or its

data?

AData Definition Language

BData Control Language

CData Entity Language

DData Manipulation Language

Answer : B

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