Oracle
1Z0-497 · Question #46
1Z0-497 Question #46: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-497 to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.
Question
View the current parameter settings shown in the output below. NAMETYPEVALUE db_file_multiblock_read_count integer ddl_lock_timeout integer Distributed_lock_timeout integer dml_locks integer lock_sga boolean FALSE enab1e_dd1_1ogging boolean FALSE resumable_timeout integer A user logs in to the hrschema and issues the following commands: SQL> CREATE TABLE emp (empno NUMBER(3), enamo 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 salNUMBER(10, 2); What happens in this scenario?
Options
- AThe second user's session immediately produces a "resource busy" error.
- BThe second user's command executes successfully.
- CThe second user's session waits for a time before producing a "resource busy" error.
- DA deadlock is created.
Unlock 1Z0-497 to see the answer
You've previewed enough free 1Z0-497 questions. Unlock 1Z0-497 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.