ocp-41

Exhibit:

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 HR schema 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 the resource busy error.
B. The second user’s command executes successfully.
C. The second user’s session waits for a time period before producing the resource busy error.

D. A deadlock is created.
Answer: C

---

为了一些当前参数设置查看图表。用户登录到HR方案，发出以下
命令：
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 HR schema and issues the following command:
就在这时，第二个用户同时登录到HR方案，并发出以下命令：
SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);
会发生什么？

C.第二个用户的会话在产生资源忙的错误之前等待一段时间。

---