Oracle PL/SQL Procedures MCQs with answers Page - 4

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 privilege is required to create a procedure?

  • (A) CREATE TABLE
  • (B) CREATE PROCEDURE
  • (C) EXECUTE PROCEDURE
  • (D) ALTER SESSION

A

Arogya • 3.19K Points
Extraordinary

Q. What is overloading in procedures?

  • (A) Creating multiple procedures with same name but different parameters
  • (B) Large procedure size
  • (C) Procedure failure
  • (D) Multiple databases

A

Arogya • 3.19K Points
Extraordinary

Q. Which parameter mode can be modified inside procedure?

  • (A) IN
  • (B) OUT
  • (C) IN OUT
  • (D) Both OUT and IN OUT

A

Arogya • 3.19K Points
Extraordinary

Q. Which type of cursor must be declared by programmer?

  • (A) Implicit cursor
  • (B) Explicit cursor
  • (C) Auto cursor
  • (D) Temporary cursor

A

Arogya • 3.19K Points
Extraordinary

Q. Which statement is used to fetch data from cursor?

  • (A) GET
  • (B) FETCH
  • (C) READ
  • (D) SELECT

A

Arogya • 3.19K Points
Extraordinary

Q. What is the use of COMMIT inside procedure?

  • (A) Delete table
  • (B) Save transaction permanently
  • (C) Close database
  • (D) Compile procedure

A

Arogya • 3.19K Points
Extraordinary

Q. ROLLBACK inside procedure will:

  • (A) Delete procedure
  • (B) Undo uncommitted changes
  • (C) Restart database
  • (D) Stop execution

A

Arogya • 3.19K Points
Extraordinary

Q. Which clause ensures code always runs whether exception occurs or not?

  • (A) WHEN OTHERS
  • (B) FINALLY
  • (C) END
  • (D) AFTER

A

Arogya • 3.19K Points
Extraordinary

Q. What happens when procedure compilation fails?

  • (A) Procedure deleted
  • (B) Procedure stored with errors
  • (C) Database shutdown
  • (D) Table locked

A

Arogya • 3.19K Points
Extraordinary

Q. Which view shows procedure errors?

  • (A) USER_TABLES
  • (B) USER_ERRORS
  • (C) USER_INDEXES
  • (D) USER_DATA

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.