Exception handling -oracle plsql

Which of the following is not true about the exception handling section of a PL/SQL block?

• This section starts with the EXCEPTION keyword.

• It is a mandatory section.

• It contains exception(s) that handle errors in the program.

• None of the above.

Which of the following is not among the types of PL/SQL records?

• Table-based

• View-based

• Cursor-based records

• User-defined records

The pre-defined exception TOO_MANY_ROWS is raised when

• PL/SQL ran out of memory or memory was corrupted.

• A cursor fetches value in a variable having incompatible data type.

• SELECT INTO statement returns more than one row.

• SELECT INTO statement returns one row.

Which of the following is not a subprogram?

• Procedure

• Function

• Package

• Anonymous PL/SQL block

Which of the following subprogram is stored in the database?

• Standalone subprogram

• Nested subprogram in an anonymous block

• Package subprogram

• Standalone and nested subprogram

Which of the following is not a type of exception?

• user defined exception

• pre defined exception

• non pre-defined exception

• server specific exception

What is the syntax for exception handlers within an exception section?

• WHEN (exception) THEN (action);

• IF (exception) THEN (action);

• WHEN (exception) statement;

• WHEN (exception) (Action);

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

What syntax identifies the end of a block's exception section?

• END;

• EXCEPTION;

• CLOSE;

• None of these

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