Solved

During the Database Redesign Process,you Discover That When an ORDER

Question 65

Multiple Choice

During the database redesign process,you discover that when an ORDER is deleted,its corresponding entries in the LINE_ITEM table are not deleted (but you would like them to be) .In order to fix,this,you use what SQL syntax?


A) ON UPDATE CASCADE
B) ON DELETE CASCADE
C) CASCADE CONSTRAINTS
D) DEFAULT

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q60: In a correlated subquery,the same table is

Q61: A correlated subquery looks very different from

Q62: A doubly nested set of NOT EXISTS

Q63: A doubly nested set of EXISTS SELECT

Q64: What is the process for adding a

Q66: To drop a nonkey column from a

Q67: When making any change to the database

Q68: SQL queries that use EXISTS and NOT

Q69: When changing the minimum cardinality on the

Q70: Typically,there are at least four different copies