TRANSACTION/SAVEPOINT

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.

When does a transaction complete? (Choose all that apply.)

A.when a DELETE statement is executed

B.when a ROLLBACK command is executed

C.when a PL/SQL anonymous block is executed

D.when a data definition language (DDL) statement is executed

E.when a TRUNCATE statement is executed after the pending transaction

Which statements are true regarding the FOR UPDATE clause in a SELECT

statement? (Choose all

that apply.)

A.It locks only the columns specified in the SELECT list.

B.It locks the rows that satisfy the condition in the SELECT statement.

C.It can be used only in SELECT statements that are based on a single table.

D.It can be used in SELECT statements that are based on a single or multiple tables.

E.After it is enforced by a SELECT statement, no other query can access the same rows

until a COMMIT

or ROLLBACK is issued.

View the Exhibit and examine the structure of the ORDERS and CUSTOMERS

tables.

Evaluate the following SQL command:

Which two statements are true regarding the outcome of the above query?

(Choose two.)

A.It locks all the rows that satisfy the condition in the statement.

B.It locks only the columns that satisfy the condition in both the tables.

C.The locks are released only when a COMMIT or ROLLBACK is issued.

D.The locks are released after a DML statement is executed on the locked rows.

Which two statements are true regarding savepoints? (Choose two.)

A.Savepoints are effective only for COMMIT.

B.Savepoints may be used to ROLLBACK.

C.Savepoints can be used for only DML statements.

D.Savepoints are effective for both COMMIT and ROLLBACK.

E.Savepoints can be used for both DML and DDL statements.

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.

Which three statements/commands would cause a transaction to end? (Choose

three.)

A.COMMIT

B.SELECT

C.CREATE

D.ROLLBACK

E.SAVEPOINT