OCP-1Z0-053-200题-165题-141

QUESTION 165

View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the

following commands:

SQL> CREATE TABLE emp

(empno NUMBER(3),

ename VARCHAR2(20),

sal NUMBER(8,2));

SQL> INSERT INTO emp(empno,ename) VALUES(1,'JAMES');

At this moment, a second user also logs in to the HRschema and issues the following command:

SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);

What happens in the above scenario?

A. The second user's session immediately produces theresource busy error.

B. The second user's command executes successfully.

C. The second user's session waits for a time periodbefore producing the resource busy error.

D. A deadlock is created.

Answer: C

同141题：http://blog.csdn.net/rlhua/article/details/16844811

Explanation/Reference:

Section: Managing Database Performance & Tuning