Which statement is true regarding the effect of this command on the transaction…?

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user
SCOTT opens a session and executes commands as follows: Which statement is true
regarding the effect of this command on the transaction in Scott’s session?

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user
SCOTT opens a session and executes commands as follows: Which statement is true
regarding the effect of this command on the transaction in Scott’s session?

A.
The transaction in Scott’s session is rolled back and the tablespace becomes readonly.

B.
The command waits and the user SCOTT can execute data manipulation language
(DML) statements only as part of the current transaction.

C.
The command fails as a transaction is still pending.

D.
The command hangs until all transactions on the objects in the tablespace commit or
rollback, and then the tablespace is placed in readonly mode.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *