1.
“NO_DATA_FOUND” and “TOO_MANY_ROWS” are the two most common errors found when executing a SELECT statement.

2.
Varrays are a good choice when -

3.
A collection method is a built-in function or procedure that operates on collections and is called using dot notation.

4.
When building up a single SQL statement in a string, do not include any semicolon at the end.

5.
Dynamic SQL enables you to build SQL statements dynamically at runtime.

6.
Which of the following returns the current value in a specified sequence.

7.
Which operators combine the results of two queries into one result?

8.
A recursive subprogram is one that calls itself.

9.
Which of the following provides a way for your program to select multiple rows of data from the database and then process each row individually.

10.
Abbreviate SMTP?