View the Exhibit for some of the current parameter settings.A user logs in to the HR schema and issues the following com

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

View the Exhibit for some of the current parameter settings.A user logs in to the HR schema and issues the following com

Post by answerhappygod »

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),enameVARCHAR2(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?
View The Exhibi 1
View The Exhibi 1 (37.82 KiB) Viewed 136 times
A. A deadlock is created.
B. The second user's command executes successfully.
C. The second user's session immediately produces the resource busy error.
D. The second user's session waits for a time period before producing the resource busy error.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply