DATA C170 Practice Test 2 with Answer Key

C170 Practice Test 2
Refer to this diagram for questions 1 though 3




1.

You are creating a database which will have the 2 tables shown above.

You need to ensure that if a category is removed from the Category table, all related product rows would
have their CategoryID set to a null value.

What should you use?

a. ON DELETE CASCADE
b. ON DELETE SET TO NULL
c. ON DELETE RESTRICT
d. ON UPDATE CASCADE

, 2.

Which rule would you use in your CREATE TABLE statement for your Category table if you would like to
have all products related to a specific category deleted if they are linked to a category that is deleted?

a. ON DELETE CASCADE
b. ON DELETE SET TO NULL
c. ON DELETE RESTRICT
d. ON UPDATE CASCADE

3.

Which rule would you use in your CREATE TABLE statement for your Category table if you needed to
prevent deletion of a category if there were associated products in the Product table?

a. ON DELETE CASCADE
b. ON DELETE SET TO NULL
c. ON DELETE RESTRICT
d. ON UPDATE CASCADE



4.




You are creating a relational database to store information about instructors and the courses that each
instructor teaches. Each course is taught by a single instructor.

You have created an Instructor table and a Course table as shown above. You need to create a
relationship between the Instructor table and the Course table. You need to keep duplicate data to a
minimum. What should you do?

a. Create a new column in the Instructor table.
b. Create new columns in the Instructors table for each course taught.
c. Create a new table that includes two columns.
d. Create a new column in the Course table.