PRO - PL SQL Programming - Theory

What happens when the data type of the actual parameter is not the same as the data type of the formal parameter?

1 Mark(s)

An error is thrown
The parameter is skipped and not passed.
Compiler performs an implicit conversion and if possible no error is thrown.
The PL/SQL code abruptly terminates.

Which of the following subprograms can use parameters?

1 Mark(s)

Procedures and Functions
Procedures only
Functions only
Packages only

Which of the following is incorrect about a RETURN statement?

1 Mark(s)

A function can have more than one RETURN statement.
All the RETURN statements is executed each time the function is called.
The RETURN statement can accept any expression for evaluation and return
When a RETURN statement is processed, the function terminates immediately and returns control to the calling PL/SQL block

What happens if a subprogram which has OUT and IN OUT formal parameter exits with an unhandled exception?

1 Mark(s)

The actual parameters for OUT and IN OUT formal parameters passed by reference retain the values that they had before the subprogram invocation.
The values of actual parameters for OUT and IN OUT formal parameters passed by value are changed from what they had before the subprogram invocation.
The actual parameters for OUT and IN OUT formal parameters passed by value retain the values that they had before the subprogram invocation.
The values of actual parameters for OUT and IN OUT formal parameters passed by reference are changed from what they had before the subprogram invocation.

What does PL/SQL do with an unhandled exception?

1 Mark(s)

Returns it to database
Returns it to invoker always
Returns it to host environment always
Returns it to invoker or host environment

What does an unhandled exception do?

1 Mark(s)

Crashes the database server.
Prints a warning and continues
Control goes to the invoker without any effect
Halts the execution of the host program.

What happens when we specify parameters using named notations in wrong order?

1 Mark(s)

There is no wrong order while using named notations
This can cause problems that are hard to detect.
These problems are detected using PL/SQL compiler
Run time errors are thrown when such a problem occurs

Which of the following is incorrect about functions?

1 Mark(s)

A function is a module that returns a value.
A function is a standalone executable statement.
A function can be said to have a datatype.
A function can be used in place of an expression in a PL/SQL statement.

When should forward declaration be used in procedures?

1 Mark(s)

Always for nested procedures
If nested subprograms in the same PL/SQL block invoke each other
For packaged subprograms always
For two standalone subprograms invoking each other

Which of the following is not a subprogram?

1 Mark(s)

Procedure
Function
Package
Anonymous PL/SQL block

Which of the following is incorrect about actual parameters in a procedure?

1 Mark(s)

The actual parameters are the values or expressions placed in the parameter list of the actual call to the function or procedure.
When invoking the procedure or function, the actual parameters are specified whose values are to be assigned to the formal parameters.
Corresponding actual and formal parameters must have compatible data types.
Same names should be given for formal and actual subprogram parameter always

Which of the following subprogram is stored in the database?

1 Mark(s)

Standalone subprogram
Nested subprogram in an anonymous block
Package subprogram
Standalone and nested subprogram

When does the compiler implicitly convert the data type of the actual parameter to the data type of the formal parameter?

1 Mark(s)

When passed by reference
Always, when passed by any method
It never converts implicitly and has to be explicitly done by user
When passed by value

Where are functions normally used?

1 Mark(s)

To perform computation
To do some business logic
To transfer data
To take IN OUT parameters

Which of the following differentiates a declaration part of a subprogram from an anonymous block?

1 Mark(s)

The declaration part of a subprogram never begins with DECLARE keyword
Declaration part of a subprogram is not mandatory whereas that of an anonymous block is mandatory
Declaration part of a subprogram can be written after the execution part whereas this is not possible in an anonymous block.
The declaration part of an anonymous block always begins with the DECLARE keyword whereas declaration part of a subprogram begins with DEFINE.

Where can a subprogram be created?

1 Mark(s)

Inside a PL/SQL block or a package only.
Inside a PL/SQL block, inside a package, or at schema level.
Inside a package only
Inside a PL/SQL block only

What does a return statement in a function do?

1 Mark(s)

It returns control to the calling program and returns the results of the function
It returns control to the calling program only if there are no results to show.
It only returns the results of the function if any.
It terminates the function without returning any results and returns control to the calling program.

What should be done to change the definition of an existing function?

1 Mark(s)

DROP the function and create it again with CREATE function syntax
Use ALTER function to re-create the function
A function once created cannot be changed later
Use CREATE or REPLACE to overwrite the existing function

What is an unhandled exception?

1 Mark(s)

An exception raised in the program is not handled by an exception section in either the current or enclosing PL/SQL blocks.
An exception raised in the program is not handled by any section in the current PL/SQL block.
An exception raised in the program is not handled by an exception section in any of the enclosing PL/SQL blocks.
An exception raised in the program is not handled by an execution section in either the current or enclosing PL/SQL blocks

Which part of a subprogram heading is optional?

1 Mark(s)

Name of the subprogram
Declaration part of a subprogram
Parameters
Exception handling part

PRO - PL SQL Programming - Theory - 9 : Question 1 of 20