CIW 1D0-541 Exam Practice Test Instant Access

Question 1

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in

the exhibit:

Which of the following relational algebraic expressions would result in the given table?

AOption A

BOption B

COption C

DOption D

Answer : A

Question 2

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 3

Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database

design phase is completed, which of the following is a valid DBDL description of the base

relations for the ER diagram?

ASTUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
CLASS(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL)
Primary Key Class_Num

BSTUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
CLASS(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL)
Primary Key Class_Num
Foreign Key Class_Num References STUDENT

CSTUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
STU_CLASS(
Student_Number: integer NOT NULL
Class_Num: integer NOT NULL)
Primary Key Student_Number
CLASS(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL)
Primary Key Class_Num

DSTUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
STU_CLASS(
Student_Number: integer NOT NULL
Class_Num: integer NOT NULL)
Primary Key Student_Number
CLASS(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL)
Primary Key Class_Num

Answer : D

Question 4

Which of the following definitions applies to all types of databases?

AData that is stored as tables

BSoftware that manipulates data

CData that is stored in a structured manner

DData records that are stored sequentially in a file

Answer : C

Question 5

Your enterprise must decide whether to use a database management system. Which of the

following best describes the overall functionality of a DBMS?

AA DBMS provides the ability to control data access using Data Manipulation Language.

BA DBMS provides the ability to maintain databases while providing increased security for the
database.

CA DBMS allows users to access the database while allowing only the database administrator to
define user views.

DA DBMS provides the ability to define, create and maintain databases while providing
controlled access to databases.

Answer : D

Question 6

Which of the following best describes the ON DELETE CASCADE referential integrity

constraint?

AIf a parent key is deleted, any child keys referenced by the parent key are automatically deleted.

BIf any child key references a parent key, the record containing the parent key cannot be deleted.

CIf a parent key is deleted, all child keys are automatically set to a specified value.

DIf a parent key is deleted, no test is made for referential integrity.

Answer : A

Question 7

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

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