Oracle PL/SQL Procedures MCQs with answers Page - 1

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 a stored procedure in Oracle?

  • (A) A database table
  • (B) A precompiled PL/SQL block stored in the database
  • (C) A trigger
  • (D) A view

A

Arogya • 3.19K Points
Extraordinary

Q. Which keyword is used to create a procedure?

  • (A) MAKE PROCEDURE
  • (B) DECLARE PROCEDURE
  • (C) CREATE PROCEDURE
  • (D) NEW PROCEDURE

A

Arogya • 3.19K Points
Extraordinary

Q. How do you execute a stored procedure in Oracle?

  • (A) RUN procedure_name
  • (B) EXEC procedure_name
  • (C) START procedure_name
  • (D) CALL TABLE procedure_name

A

Arogya • 3.19K Points
Extraordinary

Q. Which parameter mode returns a value from a procedure?

  • (A) IN
  • (B) OUT
  • (C) DEFAULT
  • (D) INPUT

A

Arogya • 3.19K Points
Extraordinary

Q. Which parameter mode can both send and receive values?

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

A

Arogya • 3.19K Points
Extraordinary

Q. Where are stored procedures stored?

  • (A) Client machine
  • (B) Browser
  • (C) Database data dictionary
  • (D) Operating system files

A

Arogya • 3.19K Points
Extraordinary

Q. Which command recompiles an existing procedure?

  • (A) RECREATE PROCEDURE
  • (B) ALTER PROCEDURE ... COMPILE
  • (C) UPDATE PROCEDURE
  • (D) REFRESH PROCEDURE

A

Arogya • 3.19K Points
Extraordinary

Q. Which symbol ends a PL/SQL statement?

  • (A) :
  • (B) ;
  • (C) .
  • (D) ,

A

Arogya • 3.19K Points
Extraordinary

Q. Which block is mandatory in a procedure?

  • (A) DECLARE
  • (B) EXCEPTION
  • (C) BEGIN...END
  • (D) CURSOR

A

Arogya • 3.19K Points
Extraordinary

Q. Which object is similar to procedure but returns a value?

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

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.