Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
A.
DELETE can be used to remove only rows from only one table at a time.
B.
DELETE can be used to remove only rows from multiple tables at a time.
C.
DELETE can be used only on a table that is a parent of a referential integrity constraint.
D.
DELETE can be used to remove data from specific columns as well as complete rows.
E.
DELETE and TRUNCATE can be used on a table that is a parent of a referential integrity constraint having ON DELETE rule .
Option D is not correct?
Whis is the ON DELETE rule?
http://www.dba-oracle.com/bk_on_delete_restrict_on_delete_no_action_tips.htm
There is a rule in
1.On Delete cascade
2.On delete set null
Which you have to apply while creating child table column according to your requirement.
So whenever you are deleting any row from parent table it will not throw any dependency error for child table.
Nope, this one: DELETE can be used to remove data from specific columns as well as complete rows
Regarding option E.
Even if the ON DELETE rule (ON DELETE CASCADE or ON DELETE SET NULL) is set for a referential integrity constraint, you can NOT yet truncate the parent table. An error raise:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys