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?
Show Answer
Hide Answer
