ExamQuestions.com

Register
Login
Oracle Database 12c Installation and Administration Exam Questions

Oracle

Oracle Database 12c Installation and Administration

162 / 190

Question 162:

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: 
image
HR - Which two operations wait when executed in HRs second session? (Choose two.) 

Answer options:

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