Oracle
1Z0-144 · Question #98
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 correct answer is B. OPEN c1 (emp_job, 3000); D. OPEN c1 (`ST_CLERK', 3000) E. OPEN c1 (EMP_job, emp_salary). See the full explanation below for the reasoning.
Question
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.
Exhibits
Options
- AOPEN c1 (NULL, 3000);
- BOPEN c1 (emp_job, 3000);
- COPEN c1 (3000, emp_salary);
- DOPEN c1 (`ST_CLERK', 3000)
- EOPEN c1 (EMP_job, emp_salary);
How the community answered
(26 responses)- A19% (5)
- B73% (19)
- C8% (2)
Community Discussion
No community discussion yet for this question.