问题:
View the Exhibit and examine the parameters. User A executes the following command to update the TRANStable:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’; Before user A issues a COMMIT orROLLBACK 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()
A . The ALTER TABLE command modifies the column successfully.
B . The DDL operation gets higher priority and transaction for user A is rolled back.
C . The ALTER TABLE command waits indefinitely until user A ends the transaction.
D . The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy
View the Exhibit and examine the parameters. User A executes the following command to update the TRANStable:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’; Before user A issues a COMMIT orROLLBACK 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()
● 参考解析
本题暂无解析
相关内容
相关标签