Oracle PL/SQL Procedures MCQs with answers Page - 3

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. What is the difference between procedure and function in Oracle?

  • (A) Procedure returns value but function does not
  • (B) Function returns a value but procedure may not
  • (C) Both are same
  • (D) Procedure only works in SQL

A

Arogya • 3.19K Points
Extraordinary

Q. Which keyword is used to replace an existing procedure?

  • (A) UPDATE PROCEDURE
  • (B) CREATE OR REPLACE PROCEDURE
  • (C) MODIFY PROCEDURE
  • (D) ALTER OR REPLACE

A

Arogya • 3.19K Points
Extraordinary

Q. Which statement is used to call a procedure inside another PL/SQL block?

  • (A) RUN
  • (B) EXECUTE IMMEDIATE
  • (C) Procedure_name;
  • (D) SELECT procedure_name

A

Arogya • 3.19K Points
Extraordinary

Q. What is a parameterized procedure?

  • (A) Procedure without variables
  • (B) Procedure that accepts arguments
  • (C) Procedure without BEGIN block
  • (D) Procedure without END

A

Arogya • 3.19K Points
Extraordinary

Q. Which exception occurs when SELECT INTO finds no rows?

  • (A) NO_DATA_FOUND
  • (B) DATA_NOT_EXIST
  • (C) ZERO_ROWS
  • (D) ROW_NOT_FOUND

A

Arogya • 3.19K Points
Extraordinary

Q. Which clause allows handling specific Oracle errors?

  • (A) WHEN OTHERS
  • (B) WHEN exception_name
  • (C) HANDLE ERROR
  • (D) TRY CATCH

A

Arogya • 3.19K Points
Extraordinary

Q. What is the default mode of procedure parameters?

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

A

Arogya • 3.19K Points
Extraordinary

Q. Which object groups multiple procedures and functions together?

  • (A) Trigger
  • (B) Package
  • (C) Index
  • (D) View

A

Arogya • 3.19K Points
Extraordinary

Q. What is recursion in procedures?

  • (A) Procedure calling another procedure
  • (B) Procedure calling itself
  • (C) Procedure returning value
  • (D) Procedure running in loop

A

Arogya • 3.19K Points
Extraordinary

Q. Which command shows procedure source code?

  • (A) DESC PROCEDURE
  • (B) SHOW PROCEDURE
  • (C) SELECT TEXT FROM USER_SOURCE
  • (D) DISPLAY CODE

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.