试题详情
单项选择题 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

  • D

  • 关注下方微信公众号，在线模考后查看

热门试题