Practice Oracle Multiple Choice Questions with Answers Quiz-3

Q.1.

Internally defined exceptions that are not predefined, do not have names. What syntax associates a user defined exception with an internally defined error code?

PRAGMA EXCEPTION_INIT (internal_error_code );
PRAGMA EXCEPTION_INIT ( user_exception );
PRAGMA EXCEPTION_INIT ( user_exception , internal_error_code );
None of these

Q.2.

Which exception name is used, When you open a cursor that is already open?

CURSOR_OPEN
CURSOR_IS_OPEN
CURSOR_ALREADY_OPEN
None of these

Q.3.

When you perform an invalid operation on a cursor like closing a cursor, fetch data from a cursor that is not opened. Which exception is used?

INVALID_CURSOR
OPEN_CURSOR
ISOPEN_CURSOR
None of these

Q.4.

When a SELECT...INTO clause does not return any row from a table.

TOO_MANY_ROWS
NO_DATA_FOUND
DATA_FOUND
None of these

Q.5.

It is raised when a program attempts to log on to the database with an invalid username or password.

LOGIN_INVALID
LOGIN_FAILED
LOGIN_DENIED
None of the above

Q.6.

Why does Apollo worry about the woods near Camp Half-Blood?

The woods hate Apollo.
Apollo senses that something is "off" about the woods.
All of nature is angry with Apollo.
The woods are full of nosoi.

Q.7.

Why does Nero gain the upper hand over Apollo?

Meg betrays Apollo.
Meg uses Peaches to attack Apollo.
Apollo did not expect to have to save Austin and Kayla.
Rhea abandons Apollo to the Imperial bodyguards.

Q.8.

Why do Apollo, Meg, and Percy worry about the shiny blobs and nosoi that follow them?

These things represent true evil.
Meg has managed to summon them.
These things mean Nero is ahead of them.
They mean Olympus has fallen.

Q.9.

What seems to disturb Apollo most about being human?

Acne.
Curly hair.
A wallet.
Jeans.

Q.10.

Apart from stopping Nero, what is Apollo's greatest task?

Saving Meg.
Regaining godhood.
Conquering the Grove.
Saving Demeter.

Support mcqgeeks.com by disabling your adblocker.