Oracle 11G OCP 1Z0-052 58
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?
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)
解析:
--在一個會話中建立和修改表 scott@TESTDB11>create table emp1 as select * from emp; Table created. scott@TESTDB11>update emp1 set sal = sal * 2 where empno = 7788; 1 row updated. --D. 在另一個會話中修改表的定義,這個錯誤是立即返回的,本答案稍有瑕疵. scott@TESTDB11>alter table emp1 modify (ename varchar2(30)); alter table emp1 modify (ename varchar2(30)) * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1180139/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11G OCP 1Z0-052 14Oracle
- Oracle 11G OCP 1Z0-052 88Oracle
- Oracle 11G OCP 1Z0-052 89Oracle
- Oracle 11G OCP 1Z0-052 90Oracle
- Oracle 11G OCP 1Z0-052 92Oracle
- Oracle 11G OCP 1Z0-052 93Oracle
- Oracle 11G OCP 1Z0-052 94Oracle
- Oracle 11G OCP 1Z0-052 95Oracle
- Oracle 11G OCP 1Z0-052 96Oracle
- Oracle 11G OCP 1Z0-052 97Oracle
- Oracle 11G OCP 1Z0-052 98Oracle
- Oracle 11G OCP 1Z0-052 99Oracle
- Oracle 11G OCP 1Z0-052 71Oracle
- Oracle 11G OCP 1Z0-052 73Oracle
- Oracle 11G OCP 1Z0-052 74Oracle
- Oracle 11G OCP 1Z0-052 75Oracle
- Oracle 11G OCP 1Z0-052 76Oracle
- Oracle 11G OCP 1Z0-052 77Oracle
- Oracle 11G OCP 1Z0-052 78Oracle
- Oracle 11G OCP 1Z0-052 79Oracle
- Oracle 11G OCP 1Z0-052 80Oracle
- Oracle 11G OCP 1Z0-052 81Oracle
- Oracle 11G OCP 1Z0-052 82Oracle
- Oracle 11G OCP 1Z0-052 83Oracle
- Oracle 11G OCP 1Z0-052 84Oracle
- Oracle 11G OCP 1Z0-052 85Oracle
- Oracle 11G OCP 1Z0-052 87Oracle
- Oracle 11G OCP 1Z0-052 53Oracle
- Oracle 11G OCP 1Z0-052 54Oracle
- Oracle 11G OCP 1Z0-052 57Oracle
- Oracle 11G OCP 1Z0-052 59Oracle
- Oracle 11G OCP 1Z0-052 60Oracle
- Oracle 11G OCP 1Z0-052 61Oracle
- Oracle 11G OCP 1Z0-052 62Oracle
- Oracle 11G OCP 1Z0-052 63Oracle
- Oracle 11G OCP 1Z0-052 64Oracle
- Oracle 11G OCP 1Z0-052 65Oracle
- Oracle 11G OCP 1Z0-052 66Oracle