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

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

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

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

Answer :
  • True

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

The command to remove rows from a table 'CUSTOMER' is:

Answer :
  • DELETE FROM CUSTOMER WHERE ...

List the correct sequence of commands to process a set of records using explicit cursors.

Answer :
  • OPEN, FETCH, CLOSE

Examine the following snippet of code from the DECLARE section of PL/SQL. DECLARE - Cust_name VERCHAR2 (20) NOT NULL : = Tom Jones: Same_name cust_name%TYPE: Which statement is correct about the above snippets of code?

Answer :
  • The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME variable resulting in an error