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);
b,d,e
B, D, E
BDE
can it be that D is wrong cause it lacks the semicolon?
I think that is just a typing error. Furthermore it would be not the point.
B,D, and E.
BDE
B, E is correct.
“;” missing in D.
Dears palvch,
Mistyping happens.
B,D,E.
BDE
BE
BE
B,E