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