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/rlhua/article/details/16844811
Explanation/Reference:
Section: Managing Database Performance & Tuning
更多推荐
OCP-1Z0-053-200题-165题-141
发布评论