← Back to exam page

Free 1D0-541 – CIW v5 Database Design Specialist Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Consider the Project relation shown in the exhibit as well as the following SQL statement: Which of the following tables shows the Project relation after execution of this SQL statement?

C:\Documents and Settings\David\Desktop\1.jpg

Select an option, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D
Question 2

Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?

Select an option, then click Submit answer.

  • ○

    Union
  • ○

    Intersection
  • ○

    Natural join
  • ○

    Cartesian product
Question 3

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

Select an option, then click Submit answer.

  • ○

    If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.
  • ○

    If any child key references a parent key, the record containing the parent key cannot be deleted.
  • ○

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

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