What happens in this scenario?

View the current parameter settings shown in the output below.
NAMETYPEVALUE
db_file_multiblock_read_count
integer
107

ddl_lock_timeout
integer
60
Distributed_lock_timeout
integer
60
dml_locks
integer
748
lock_sga
boolean
FALSE
enab1e_dd1_1ogging
boolean
FALSE
resumable_timeout
integer
0
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?

View the current parameter settings shown in the output below.
NAMETYPEVALUE
db_file_multiblock_read_count
integer
107

ddl_lock_timeout
integer
60
Distributed_lock_timeout
integer
60
dml_locks
integer
748
lock_sga
boolean
FALSE
enab1e_dd1_1ogging
boolean
FALSE
resumable_timeout
integer
0
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?

A.
The second user’s session immediately produces a “resource busy” error.

B.
The second user’s command executes successfully.

C.
The second user’s session waits for a time before producing a “resource busy” error.

D.
A deadlock is created.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Sunil Vora

Sunil Vora

Ans: C

NAME TYPE VALUE
ddl_lock_timeout integer 60

DDL_LOCK_TIMEOUT specifies a time limit for how long DDL statements will wait in a DML lock queue. The default value of zero indicates a status of NOWAIT. The maximum value of 1,000,000 seconds will result in the DDL statement waiting forever to acquire a DML lock.
If a lock is not acquired before the timeout period expires, then an error is returned.