View the Exhibit for some of the current parameter settings.A user logs in to the HR schema and issues the following com
Posted: Wed Jun 07, 2023 6:11 am
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?
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.
- View The Exhibi 1 (37.82 KiB) Viewed 169 times
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.