Oracle
1Z0-052 · Question #168
1Z0-052 Question #168: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #168. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table: SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005'; Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table: SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3)); What would happen in this scenario?
Exhibit
Options
- AThe ALTER TABLE command modifies the column successfully
- BThe DDL operation gets higher priority and transaction for user A is rolled back
- CThe ALETER TABLE command waits indefinitely until user A ends the transaction
- DThe ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy
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.