PL/SQL Package/exception Quiz

What is the purpose of a package in PL/SQL?

• To store a single function

• To store a collection of related functions, procedures, and variables

• To handle transactions

• To manage system privileges

Which part of a package must always be present in PL/SQL?

• Package body

• Package specification

• Private procedures

• Exception handling

Which of the following is not mandatory in a PL/SQL package?

• Package body

• Package specification

• Both are mandatory

• Neither are mandatory

What is the main purpose of a package specification?

• To hide the code logic

• To declare public functions and procedures

• To declare local variables

• To handle runtime errors

What happens if a function is defined in a package body but not in the specification?

• It can still be accessed publicly.

• It cannot be accessed outside the package body.

• It will cause a compilation error.

• It can be accessed only in the current session.

How can you create a package body in PL/SQL?

• CREATE PACKAGE BODY package_name

• CREATE OR REPLACE BODY package_name

• CREATE BODY package_name

• CREATE PACKAGE package_name

In a package, how are public elements declared?

• In the package body

• In the package specification

• In a trigger

• Using the PUBLIC keyword

Which of the following cannot be part of a PL/SQL package?

• Triggers

• Functions

• Procedures

• Cursors

How do you reference a procedure inside a package in PL/SQL?

• package_name.procedure_name

• procedure_name.package_name

• call procedure_name from package_name

• execute package_name.procedure_name

What is the default visibility of procedures defined only in the package body?

• Public

• Private

• Depends on the declaration

• Global