CIW 1D0-541 Practice Exam Questions with Verified Answers

Question 1

For the Employee relation shown in the exhibit, which set of column values holds the

complete tuple for the employee named James Smith?

Answer Options

A0002, James, Smith

B0002, James, Smith, 10-25-76

CFirst_Name, James, Last_Name, Smith

DEmp_ID, 0002, First_Name, James, Last_Name, Smith

Correct Answer: B

Question 2

Which statement accurately describes a characteristic of attributes?

Answer Options

AThe ordering of attributes in a table is significant.

BAn attribute contains values from multiple domains.

CAn attribute name can be used only once per table.

DAn attribute name can be used only once in a relational database system with multiple tables.

Correct 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?

Answer Options

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

Correct Answer: D

Question 4

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

the ends of the connecting line indicate?

Answer Options

ADegree of a relation

BCardinality of a relation

CPrimary key of a relation

DDeterminant of a relation

Correct Answer: B

Question 5

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

constraint?

Answer Options

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.

Correct Answer: A

Free CIW 1D0-541 Exam Practice Questions & Explanations