Which two statements are true regarding the DELETE and TRUNCATE commands?
A. DELETE can be used to remove rows from only one table in one statement.
B. DELETE can be used to remove rows from multiple tables in one statement.
C. DELETE can be used to remove rows only for tables that are parents for a child table that has a referential integrity constraint referring to the parent.
D. DELETE can be used to remove data from specific columns as well as complete rows.
E. DELETE and TRUNCATE can be used for tables that are parents for a child table that has a referential integrity constraint having an ON DELETE rule.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
AE
AE
I think the correct answer are:
B. DELETE can be used to remove rows from multiple tables in one statement. –> Yes it can, in case of DELETE ON CASCADE
E. DELETE and TRUNCATE can be used for tables that are parents for a child table that has a referential integrity constraint having an ON DELETE rule. –> The same as before answer DELETE ON CASCADE
AE