Oracle
1Z0-050 · Question #52
1Z0-050 Question #52: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #52. The question stem and answer options stay visible for context.
Question
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?
Exhibit
Options
- AA deadlock is created.
- BThe second user's command executes successfully.
- CThe second user's session immediately produces the resource busy error.
- DThe second user's session waits for a time period before producing the resource busy error.
Unlock 1Z0-050 to see the answer
You've previewed enough free 1Z0-050 questions. Unlock 1Z0-050 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.