Oracle 11G OCP 1Z0-052 58

LuiseDalian發表於2014-06-11
Oracle
（58）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?

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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章