1Z0-062 · Question #135
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: SQL> INSERT INTO cust VALUES(101, 'JACK'); 1 row created…
The correct answer is D. The command hangs until all transactions on the objects in the tablespace commit or rollback. The command hangs until a commit or rollback is entered.
Question
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:
SQL> INSERT INTO cust VALUES(101, 'JACK'); 1 row created. SQL> INSERT INTO cust VALUES(102, 'SMITH'); 1 row created. As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY; Which statement is true regarding the effect of this command on the transaction in Scott's session?
Options
- AThe command fails as a transaction is still pending.
- BThe transaction in Scott's session is rolled back and the tablespace becomes readonly.
- CThe command waits and the user SCOTT can execute data manipulation language (DML)
- DThe command hangs until all transactions on the objects in the tablespace commit or rollback,
How the community answered
(20 responses)- B10% (2)
- C5% (1)
- D85% (17)
Explanation
The command hangs until a commit or rollback is entered.
Topics
Community Discussion
No community discussion yet for this question.