Similar Collections

    No collections found

questions

Title
Errors that are encountered during the execution of the program are referred to as ____ in PL/SQL

Errors that are encountered during the execution of the program are referred to as ____ in PL/SQL.

  1. FUNCTION
  2. CURSOR
  3. EXCEPTION
  4. PROCEDURE
discuss
How many types of exceptions are there?

How many types of exceptions are there?

  1. 2
  2. 3
  3. 4
  4. 5
discuss
Which of the following is/are an/the type(s) of exceptions?

Which of the following is/are an/the type(s) of exceptions?

  1. System-defined
  2. User-defined
  3. Both A. and B.
  4. None of the above
discuss
Which command is used in order to raise an exception explicitly?

Which command is used in order to raise an exception explicitly?

  1. RISE
  2. ROSE
  3. RAISE
  4. RINSE
discuss
Which of the following is TRUE about User-defined exceptions?

Which of the following is TRUE about User-defined exceptions?

  1. Users can explicitly raise an exception by using a RAISE statement
  2. RAISE_APPLICATION_ERROR can be used to raise a user-defined exception explicitly.
  3. Both A. and B.
  4. None of the above
discuss
What is the syntax of User-defined exceptions?

What is the syntax of User-defined exceptions?

  1. DECLARE my-exception EXCEPTION;
  2. DECLARE EXCEPTION;
  3. DECLARE my-exception;
  4. EXCEPTION;
discuss
Which of the following clause does not comes in the syntax while raising an exception?

Which of the following clause does not comes in the syntax while raising an exception?

  1. DECLARE
  2. WHEN
  3. CLOSE
  4. END
discuss
When SELECT INTO returns no rows, which pre-defined exception is raised?

When SELECT INTO returns no rows, which pre-defined exception is raised?

  1. ACCESS_INTO_NULL
  2. NO_DATA_FOUND
  3. NOT_LOGGED_ON
  4. VALUE_ERROR
discuss
When ACCESS_INTO_NULL exception does is raised?

When ACCESS_INTO_NULL exception does is raised?

  1. A unique index column with duplicate values is raised when this error occurs.
  2. An invalid username or password is used by a program to connect to a database.
  3. An automatic assignment of a value to a NULL object raises this exception.
  4. It is raised when more than one row is returned by a SELECT INTO statement.
discuss
Which exception is rose when there is no other clause in the "WHEN" clause of a CASE statement, and none of the choices in the "WHEN" clause have been selected?

Which exception is rose when there is no other clause in the "WHEN" clause of a CASE statement, and none of the choices in the "WHEN" clause have been selected?

  1. INVALID_CURSOR
  2. DUP_VAL_ON_INDEX
  3. VALUE_ERROR
  4. CASE_NOT_FOUND
discuss
When COLLECTION_IS_NULL exception is raised?

When COLLECTION_IS_NULL exception is raised?

  1. A unique index column with duplicate values is raised when this error occurs.
  2. The exception is thrown when an uninitialized nested table or varray is attempted to be populated with collection methods other than exist, or when an element of an uninitialized nested table or varray is attempted to be assigned values.
  3. If a select into statement fails to return any rows, it raises this error.
  4. This error message appears when a number is divided by zero.
discuss
When DUP_VAL_ON_INDEX exception does is raised?

When DUP_VAL_ON_INDEX exception does is raised?

  1. A unique index column with duplicate values is raised when this error occurs.
  2. The error is raised if an attempt is made to close an unopened cursor or perform a cursor operation without permission.
  3. When character strings are converted to numbers, it is raised if the string did not represent a valid number.
  4. An invalid username or password is used to log on to the database by a program.
discuss
An exception which occurs when attempting to access a database without connecting to it is –

An exception which occurs when attempting to access a database without connecting to it is –

  1. PROGRAM_ERROR
  2. NOT_LOGGED_IN
  3. NOT_LOGGED_ON
  4. NULL_LOGGED-ON
discuss
Which exception is raised when there is an internal problem in PL/SQL?

Which exception is raised when there is an internal problem in PL/SQL?

  1. VALUE_ERROR
  2. INTERNAL_ERROR
  3. PROBLEM_ERROR
  4. PROGRAM_ERROR
discuss
When ROWTYPE_MISMATCH exception is raised?

When ROWTYPE_MISMATCH exception is raised?

  1. When a member method is invoked on an object type, but its instance has not been initialized, this exception is raised.
  2. Error in PL/SQL occurs when memory is exhausted or corrupt.
  3. Cursors raise this exception when they seek values in variables of incompatible types.
  4. None of the above
discuss
When SELF_IS_NULL exception is raised?

When SELF_IS_NULL exception is raised?

  1. Errors are raised when dividing by zero is attempted.
  2. When a member method is invoked on an object type, but its instance has not been initialized, this exception is raised.
  3. Error in PL/SQL occurs when memory is exhausted or corrupt.
  4. It is raised when more than one row is returned by a SELECT INTO statement.
discuss
A PL/SQL exception, which occurs when a memory error occurs?

A PL/SQL exception, which occurs when a memory error occurs?

  1. ZERO-DIVIDE
  2. VALUE_ERROR
  3. MEMORY_ERROR
  4. STORAGE_ERROR
discuss
The exception thrown when more than one row is returned from a SELECT INTO statement?

The exception thrown when more than one row is returned from a SELECT INTO statement?

  1. MORE_THAN_ONE_ROW
  2. MORE_ROWS
  3. TOO_MANY_ROWS
  4. MANY_ROWS
discuss
When VALUE_ERROR exception is raised?

When VALUE_ERROR exception is raised?

  1. Errors relating to arithmetic, conversion, truncation, or size constraints raise this signal.
  2. This error message appears when a number is divided by zero.
  3. Both A. and B.
  4. None of the above
discuss
When ZERO_DIVIDE exception is raised?

When ZERO_DIVIDE exception is raised?

  1. This error message appears when a number is multiplied by zero.
  2. This error message appears when a number is divided by zero.
  3. This error message appears when a number is integrated by zero.
  4. This error message appears when a number is zero.
discuss
total MCQs: 20

MCQs

20

Views

54

Best Answers

299

Points

5