Which statement is true regarding transactions? (Choose all that apply.)
A.
A transaction can consist only of a set of DML and DDL statements.
B.
A part or an entire transaction can be undone by using ROLLBACK command.
C.
A transaction consists of a set of DML or DCL statements.
D.
A part or an entire transaction can be made permanent with a COMMIT.
E.
A transaction can consist of only a set of queries or DML or DDL statements.
Answer: B,C
https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038
Answer: B,D
Resposta ‘B’ e ‘D’
A. False – doesn’t have to be a set
“A database transaction consists of one or more statements. Specifically, a transaction consists of one of the following:
One or more data manipulation language (DML) statements that together constitute an atomic change to the database
One data definition language (DDL) statement”
B. True
C. False
D. False, commit makes entire transaction permanent
E. False, Would be correct if “queries” is not there
Answer: B