1Z0-144 Web TestEngine demo

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 statements for opening the cursor that fetches the result set consisting of employees with JOB_ID as `ST_CLERK' and SALARY greater than 3000. (Choose three.)

Select all that apply.

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