black

1Z0-053

登录

单项选择题

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.

相关考题

多项选择题 Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)

多项选择题 Whatprivilegesmustbegrantedtoallowanaccounttocreatetherecoverycatalog?()

单项选择题 You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?()

All Rights Reserved 版权所有©PP题库网库(pptiku.com)

备案号:湘ICP备14005140号-5

经营许可证号:湘B2-20140064