Oracle PL/SQL Procedures MCQs with answers Page - 2

Here, you will find a collection of MCQ questions on Oracle PL/SQL Procedures. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Arogya • 3.19K Points
Extraordinary

Q. Which clause handles errors in a procedure?

  • (A) ERROR
  • (B) HANDLE
  • (C) EXCEPTION
  • (D) CATCH

A

Arogya • 3.19K Points
Extraordinary

Q. Which command removes a procedure?

  • (A) DELETE PROCEDURE
  • (B) REMOVE PROCEDURE
  • (C) DROP PROCEDURE
  • (D) CLEAR PROCEDURE

A

Arogya • 3.19K Points
Extraordinary

Q. Can a procedure call another procedure?

  • (A) No
  • (B) Yes
  • (C) Only in triggers
  • (D) Only in packages

A

Arogya • 3.19K Points
Extraordinary

Q. Which variable stores single row query result?

  • (A) Cursor
  • (B) Record
  • (C) Scalar variable
  • (D) Array

A

Arogya • 3.19K Points
Extraordinary

Q. What happens if SELECT INTO returns multiple rows?

  • (A) Procedure stops
  • (B) TOO_MANY_ROWS exception
  • (C) No error
  • (D) Database shutdown

A

Arogya • 3.19K Points
Extraordinary

Q. Which keyword is used to declare variables?

  • (A) VAR
  • (B) DECLARE
  • (C) DEFINE
  • (D) LET

A

Arogya • 3.19K Points
Extraordinary

Q. Which cursor type is automatically created by Oracle?

  • (A) Explicit cursor
  • (B) Implicit cursor
  • (C) Static cursor
  • (D) Dynamic cursor

A

Arogya • 3.19K Points
Extraordinary

Q. Which command displays output in PL/SQL?

  • (A) PRINT
  • (B) DISPLAY
  • (C) DBMS_OUTPUT.PUT_LINE
  • (D) SHOW

A

Arogya • 3.19K Points
Extraordinary

Q. Which parameter is read-only?

  • (A) OUT
  • (B) IN
  • (C) IN OUT
  • (D) RETURN

A

Arogya • 3.19K Points
Extraordinary

Q. What is the advantage of stored procedures?

  • (A) Increased network traffic
  • (B) Code reuse and better performance
  • (C) More disk usage
  • (D) Slower execution

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.