Oracle Database 12c R2: Program with PL/SQL Ed 2 Quiz Questions and Answers

There are three types of loops: basic, FOR, and WHILE.

Answer :
  • True

Which parameter acts like a constant inside the subprogram?

Answer :
  • IN

Collection is an ordered group of elements, all of the same type.

Answer :
  • TRUE

Arrays in other languages become varrays in PL/SQL.

Answer :
  • TRUE

Identifry the correct statement for Cursor For loop using subqueries.

Answer :
  • begin for rec_emp in (select employee_id,first_name,salary from employees where department_id=60) loop dbms_output.put_line(rec_emp.employee_id||' '||rec_emp.first_name||' '||rec_emp.salary); end loop; end;

What is the syntax of an implicit cursor attribute ISOPEN?

Answer :
  • %ISOPEN

Which of the false statements about opening and closing an explicit cursor ?

Answer :
  • A cursor once closed cannot be re-opened.

You can trap any error by including a corresponding handler within the exception-handling section of the PL/SQL.

Answer :
  • TRUE

In Oracle Database 12c R2 Explicit cursor functions enable a programmer to manually control explicit cursors in the PL/SQL block.

Answer :
  • True

Which of the following is not true about the PL/SQL language?

Answer :
  • It does not offer error checking.