Oracle
1Z0-052 · Question #126
1Z0-052 Question #126: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #126. The question stem and answer options stay visible for context.
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) statements
- DThe command hangs until all transactions on the objects in the tablespace commit or rollback, and then
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.