Search Header Logo

Stored Procedure, Function & Packages

Authored by harshali patil

Computers

University

15 Questions

Used 34+ times

Stored Procedure, Function & Packages
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A stored procedure, when specifying a string parameter should use which of these ?

Char

Varchar2

Text

Real

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A Stored Procedure is a

Sequence of SQL or PL/SQL statements to perform specific function

Stored in compiled form in the database

Can be called from all client environments

All the above

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is true, Creating a procedure have compile errors?

The line numbers reported match the line numbers you see in your text editor.

SQL*Plus will automatically show the errors to you.

To see the errors, enter SHOW ERRORS in SQL*Plus.

If there are no syntax errors, you will receive the message “NO ERRORS.”

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following are the advantages of PL/SQL Packages?

Modularity

Easier Application Design

Information Hiding

All the above

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the PL/SQL, the package specification contains …….. declarations.

Public

Private

Friend

Protected

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is true about PL/SQL package body?

The package body has methods declared in package specification and private.

It is created using the CREATE PACKAGE Statement.

Methods and types declared in package body are not hidden from code outside

All the above

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not true about PL/SQL package specifications?

The specification is the interface to the package.

It declares the types, variables, subprograms that can be referenced from outside

Contains all information about the content of the package and the

None of the above.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?