Oracle PL/SQL Procedures MCQs with answers Page - 6

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. A company wants bonus = 10% of salary updated for all employees. Best solution?

  • (A) Loop + Cursor
  • (B) Single UPDATE statement
  • (C) Trigger
  • (D) View

A

Arogya • 3.19K Points
Extraordinary

Q. Which is faster in PL/SQL processing?

  • (A) Row-by-row processing
  • (B) Set-based SQL
  • (C) Triggers
  • (D) Functions

A

Arogya • 3.19K Points
Extraordinary

Q. Which statement saves all changes permanently?

  • (A) SAVEPOINT
  • (B) ROLLBACK
  • (C) COMMIT
  • (D) END

A

Arogya • 3.19K Points
Extraordinary

Q. ROLLBACK TO SAVEPOINT does what?

  • (A) Rollback entire transaction
  • (B) Rollback partial transaction
  • (C) Commit data
  • (D) Delete data

A

Arogya • 3.19K Points
Extraordinary

Q. Which parameter mode allows both input and output?

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

A

Arogya • 3.19K Points
Extraordinary

Q. Function must always return?

  • (A) Cursor
  • (B) Value
  • (C) Table
  • (D) Exception

A

Arogya • 3.19K Points
Extraordinary

Q. Which is best for reusable business logic?

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

A

Arogya • 3.19K Points
Extraordinary

Q. Which exception occurs when dividing by zero?

  • (A) VALUE_ERROR
  • (B) ZERO_DIVIDE
  • (C) NO_DATA_FOUND
  • (D) TOO_MANY_ROWS

A

Arogya • 3.19K Points
Extraordinary

Q. Which exception occurs when SELECT INTO returns multiple rows?

  • (A) NO_DATA_FOUND
  • (B) VALUE_ERROR
  • (C) TOO_MANY_ROWS
  • (D) ZERO_DIVIDE

A

Arogya • 3.19K Points
Extraordinary

Q. Where are procedures and functions stored?

  • (A) Memory
  • (B) Database Schema
  • (C) Client System
  • (D) Application Server

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.