Which two operations wait when executed in HR’s second …

The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK,
or any data definition language (DDL) command after that:

HR then opens a second session.
Which two operations wait when executed in HR’s second session?

The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK,
or any data definition language (DDL) command after that:

HR then opens a second session.
Which two operations wait when executed in HR’s second session?

A.
LOCK TABLE employees IN EXCLUSIVE MODE;

B.
INSERT INTO employees(empno,ename) VALUES (1289, ‘Dick’);

C.
SELECT job FROM employees WHERE job=’CLERK’ FOR UPDATE OF empno;

D.
SELECT empno,ename FROM employees WHERE job=’CLERK’;

E.
INSERT INTO employees(empno,ename,job) VALUES (2001,’Harry’,’CLERK);



Leave a Reply 0

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