Oracle Exam 1Z0-497 Topic 1 Question 111 Discussion

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?