CIW 1D0-541 Exam Practice Test Instant Access

Question 1

Which term best describes one or more database operations that are executed as a single unit?

AUpdate

BTransaction

CProcedure

DSingleton

Answer : B

Question 2

To create a view, what are the minimal privileges that a user must have for the relations used

to make the view?

AGRANT

BREVOKE

CSELECT

DCREATE VIEW

Answer : C

Question 3

What is a relational database domain?

AA group of attributes

BA set of permissible tuple values

CA collection of related data items

DA set of permissible attribute values

Answer : D

Question 4

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship

between the two entities is shown?

Am:m

Bm:n

C11

D1n

Answer : B

Question 5

The database manager wants to give Rubio and Doe the ability to modify the Project Relation

shown in the exhibit. A temporary employee named Temp needs to access the data in the database

to generate reports. Which group of SQL statements will perform this task?

AGRANT UPDATE ON Project TO Rubio, Doe;
GRANT SELECT ON Project TO Temp;

BGRANT ALL PRIVILEGES ON Project TO Rubio, Doe;
GRANT UPDATE ON Project TO Temp;

CGRANT SELECT ON Project
WHERE Manager = 'Rubio';
GRANT SELECT ON Project
WHERE Manager = 'Doe';

DGRANT UPDATE ON Project
WHERE Manager = 'Rubio';
GRANT UPDATE ON Project
WHERE Manager = 'Doe';
GRANT SELECT ON Project TO Temp;

Answer : A

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