11g: Program with PL/SQL Quiz Questions and Answers

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

Answer :
  • True

A nested cursor is implicitly opened when the containing row is fetched from the parent cursor. The nested cursor is closed in which of the following case(s)?

Answer :
  • All mentioned above

Which of the following is the original purpose of SQL?

Answer :
  • All of the above

What is the syntax of an implicit cursor attribute ISOPEN?

Answer :
  • %ISOPEN

You are a PL/SQL developer and you want to Fetch records from a cursor using CURSOR variables declare.Identify the sytax is written properlly to do so.select employee_id,first_name,salary from employees where department_id=60; v_emp cur_emp%rowtype; begin open cur_emp; loop fetch cur_emp into v_emp; exit when cur_emp%notfound; dbms_output.put_line(v_emp.employee_id||' '||v_emp.first_name||' '||v_emp.salary); end loop; close cur_emp; end;

Answer :
  • TRUE

Which of the following combines the data manipulating power of SQL with the data processing power of Procedural languages?

Answer :
  • PL/SQL

In internal exception oracle raises the exception for you implicitly. You still need to declare the exception and handle it, but you don’t need to raise it.

Answer :
  • TRUE

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

Answer :
  • TRUE

You can add a row using SQL in a database with which of the following?

Answer :
  • INSERT

The SQL WHERE clause:

Answer :
  • Limits the row data are returned