Pl/Sql - Exception MCQ Questions And Answers

Exception MCQs : This section focuses on "Exception" in Pl/Sql. These Multiple Choice Questions (MCQs) should be practiced to improve the Pl/Sql skills required for various interviews (campus interview, walk-in interview, company interview), placements, entrance exams and other competitive examinations.

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

A. Try
B. Throw
C. Catch
D. Exception

View Answer


2. How many types of exceptions?

A. 1
B. 2
C. 3
D. 4

View Answer


3. An exception is an error condition during a program execution.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer


4. Which attribute is used to raise exception?

A. Open
B. Select
C. Raise
D. Try

View Answer


5. 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

View Answer


6. What is the Oracle Error Code for ACCESS_INTO_NULL?

A. 6592
B. 6531
C. 1722
D. 6530

View Answer


7. 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

View Answer


8. What is the syntax of User-defined exceptions?

A. DECLARE my-exception EXCEPTION;
B. DECLARE EXCEPTION;
C. DECLARE my-exception;
D. EXCEPTION;

View Answer


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

A. DECLARE
B. WHEN
C. CLOSE
D. END

View Answer


10. 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

View Answer





Discussion


* You must be logged in to add comment.