Oracle Database Packages MCQs with answers Page - 2

Here, you will find a collection of MCQ questions on Oracle Database Packages. 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 • 2.57K Points
Extraordinary

Q. Which object supports procedure overloading?

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

A

Arogya • 2.57K Points
Extraordinary

Q. If only package body is changed, what happens?

  • (A) Dependent objects invalidated
  • (B) No invalidation
  • (C) Database shutdown
  • (D) Table locked

A

Arogya • 2.57K Points
Extraordinary

Q. If package specification changes:

  • (A) Nothing happens
  • (B) Dependent objects become invalid
  • (C) Database restarts
  • (D) Tables deleted

A

Arogya • 2.57K Points
Extraordinary

Q. Which privilege is needed to execute package?

  • (A) EXECUTE
  • (B) SELECT
  • (C) ALTER
  • (D) INSERT

A

Arogya • 2.57K Points
Extraordinary

Q. Which view stores package source code?

  • (A) USER_SOURCE
  • (B) USER_TABLES
  • (C) USER_INDEXES
  • (D) USER_CONSTRAINTS

A

Arogya • 2.57K Points
Extraordinary

Q. Can a package contain triggers?

  • (A) Yes
  • (B) No
  • (C) Only functions
  • (D) Only cursors

A

Arogya • 2.57K Points
Extraordinary

Q. Which keyword initializes package once per session?

  • (A) BEGIN section in package body
  • (B) DECLARE
  • (C) INIT
  • (D) START

A

Arogya • 2.57K Points
Extraordinary

Q. Package without body is possible?

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

A

Arogya • 2.57K Points
Extraordinary

Q. How to remove a package?

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

A

Arogya • 2.57K Points
Extraordinary

Q. Packages mainly improve:

  • (A) Security and performance
  • (B) Disk usage
  • (C) Network speed
  • (D) Backup speed

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.