Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as ‘ST_CLERK’ and salary greater than 3000.

Examine the following snippet of PL/SQL code:

View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.

Identify open statement for opening the cursor that fetches the result as consisting of employees
with JOB_ID as ‘ST_CLERK’ and salary greater than 3000.

Examine the following snippet of PL/SQL code:

View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.

Identify open statement for opening the cursor that fetches the result as consisting of employees
with JOB_ID as ‘ST_CLERK’ and salary greater than 3000.

A.
OPEN c1 (NULL, 3000);

B.
OPEN c1 (emp_job, 3000);

C.
OPEN c1 (3000, emp_salary);

D.
OPEN c1 (‘ST_CLERK’, 3000)

E.
OPEN c1 (EMP_job, emp_salary);



Leave a Reply 13

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


Damien

Damien

can it be that D is wrong cause it lacks the semicolon?

Fabio

Fabio

I think that is just a typing error. Furthermore it would be not the point.

dudeman

dudeman

B,D, and E.

palvch

palvch

B, E is correct.

“;” missing in D.

Elkhan

Elkhan

Dears palvch,
Mistyping happens.
B,D,E.