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

Explanation:

Show Hint

← Previous question

Next question →

Leave a Reply 12

vishesh bansal

b,d,e are correct but d is missing ‘;’
so it could be b and e.
http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/sqloperations.htm#i45976

samkelo siyabonga ngubo

B,D,E

pavlov.leo

The only correct answer is “D” because default values of variables emp_job and emp_salary may be overrided before cursor is needed to be opened.

Piero

OPS ……
IT’S B,D,E

DECLARE
EMP_JOB EMPLOYEES.JOB_ID%TYPE := ‘ST_CLERK’;
EMP_SALARY EMPLOYEES.SALARY%TYPE := 3000;
MY_RECORD EMPLOYEES%ROWTYPE;
CURSOR C1(JOB VARCHAR2, MAX_WAGE NUMBER) IS
SELECT * FROM EMPLOYEES WHERE JOB_ID = JOB AND SALARY > MAX_WAGE;
BEGIN
— OPEN C1(NULL,30);
—
— OPEN C1(EMP_JOB, 3000);
— ST_CLERK 3200
— OPEN C1(3000, EMP_SALARY);
—
— OPEN C1(‘ST_CLERK’, 3000);
— ST_CLERK 3200
— OPEN C1(EMP_JOB, EMP_SALARY);
— ST_CLERK 3200
FETCH C1 INTO MY_RECORD;
DBMS_OUTPUT.PUT_LINE(MY_RECORD.JOB_ID || ‘ ‘ || MY_RECORD.SALARY);
CLOSE C1;
END;