Which two statements are true regarding the DELETE and …

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 .

Explanation:
Transactions, consisting of INSERT, UPDATE, and DELETE (or even MERGE) commands can be
made permanent (with a COMMIT) or reversed (with a ROLLBACK). A TRUNCATE command, like
any other DDL command, is immediately permanent: it can never be reversed.
The Transaction Control Statements
A transaction begins implicitly with the first DML statement. There is no command to explicitly start
a transaction. The transaction continues through all subsequent DML statements issued by the
session. These statements can be against any number of tables:
a transaction is not restricted to one table. It terminates (barring any of the events listed in the

previous section) when the session issues a COMMIT or ROLLBACK command.
The SAVEPOINT command can be used to set markers that will stage the action of a ROLLBACK,
but the same transaction remains in progress irrespective of the use of SAVEPOINT
Explicit Transaction Control Statements
You can control the logic of transactions by using the COMMIT, SAVEPOINT, and ROLLBACK
statements.
Note: You cannot COMMIT to a SAVEPOINT. SAVEPOINT is not ANSI-standard SQL.
untitled