Explore topic-wise MCQs in Technical MCQs.

This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.

1.

Exceptions are raised by the database server automatically whenever there is any internal database error.

A. Yes
B. No
C. Can be yes or no
D. Can not say
E.
Answer» B. No
Discussion
2.

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

A. DECLARE
B. WHEN
C. CLOSE
D. END
Answer» D. END
Discussion
3.

What is the syntax of User-defined exceptions?

A. DECLARE my-exception EXCEPTION;
B. DECLARE EXCEPTION;
C. DECLARE my-exception;
D. EXCEPTION;
Answer» B. DECLARE EXCEPTION;
Discussion
4.

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

A. Users can explicitly raise an exception by using a RAISE statement
B. RAISE_APPLICATION_ERROR can be used to raise a user-defined exception explicitly
C. both a and b
D. None of the above
Answer» D. None of the above
Discussion
5.

What is the Oracle Error Code for ACCESS_INTO_NULL?

A. 6592
B. 6531
C. 1722
D. 6530
Answer» E.
Discussion
6.

A _____ exception must be declared and then raised explicitly.

A. system-defined
B. user-defined
C. both a and b
D. None of the above
Answer» C. both a and b
Discussion
7.

Which attribute is used to raise exception?

A. Open
B. Select
C. Raise
D. Try
Answer» D. Try
Discussion
8.

An exception is an error condition during a program execution.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
Answer» B. FALSE
Discussion
9.

How many types of exceptions?

A. 1
B. 2
C. 3
D. 4
Answer» C. 3
Discussion
10.

PL/SQL supports programmers to catch such conditions using ________ block in the program

A. Try
B. Throw
C. Catch
D. Exception
Answer» E.
Discussion