Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 30 of 50

Marks: +1, -0

Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)

DELETE can be used to remove rows from only one table in one statement.
DELETE can be used to remove rows from multiple tables in one statement.
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.
DELETE can be used to remove data from specific columns as well as complete rows.
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.

Go to Question:

Prev Question

Next Question