Which statement is true regarding the effect of this command on the transaction in Scott’s session()
- AThe command fails as a transaction is still pending.
- BThe transaction in Scott’s session is rolled back and the tablespace becomes read-only.
- CThe command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
- DThe command hangsuntil all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in read-only mode.