Prev Question
Next Question

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:

5a4b978c6a054 - Which two operations wait when executed in HR’s second session?

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);

Prev Question
Next Question

Leave a Reply

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