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

Which of the following describes two desirable characteristics of a primary key?

AA primary key should be a value that may be null and may change over time.

BA primary key should be a value that is not null and will never change.

CA primary key should consist of meaningful data and a value that can be changed if needed.

DA primary key should not consist of meaningful data and a value that can be changed if needed.

Answer : B

Consider the Registration relation shown in the exhibit. Which of the following SQL statements

would return all tuples that have course codes beginning with the letter M?

ASELECT *
FROM Registration
WHERE Course_Code = M#;

BSELECT *
FROM Registration
WHERE Course_Code LIKE M_;

CSELECT *
FROM Registration
WHERE Course_Code LIKE M%;

DSELECT *
FROM Registration
WHERE Course_Code = M%;

Answer : C

Which characteristic is an advantage of a database management system?

AData files are owned and maintained by the users.

BDatabase administration is simplified.

CA standard method can be used to access the database.

DData is decentralized.

Answer : C

What is a candidate key?

AThe primary key for an entity

BThe key that identifies every instance of an entity

CMultiple primary keys that are joined together to form a composite key

DA key that may be used to form the primary key

Answer : D

Free Practice Questions for CIW 1D0-541 Exam