PRO - PL SQL Programming - Theory

Which of the following statements enable to branch logic from the normal flow of statements?

1 Mark(s)

Loop statements
Sequential control statements
Conditional control statements
Iterative statements

In which of the following places can a cursor expression be used?

1 Mark(s)

With an implicit cursor
In view definitions
In any form of SELECT statement
In a SELECT statement that is not a subquery.

Which of the following is not a difference between procedure and function?

1 Mark(s)

Functions can be called from SQL whereas procedures cannot be called.
A function can be used in place of an expression in a PL/SQL statement whereas a procedure can’t be used so
The return statement is mandatory for a function which is not for a procedure
Functions are used for executing business logic and computation whereas a procedure is not.

What are the different types of sequential control statements?

1 Mark(s)

GOTO & CONTINUE
GOT & NULL
NULL & CONTINUE
GOTO & SKIP

How does a GOTO statement transfer control?

1 Mark(s)

Sequentially to the next statement always
Conditional or Unconditional
Conditionally always
Unconditionally always

Which of the following correctly defines a cursor?

1 Mark(s)

A cursor is a pointer to a temporary work area created in the system memory that stores information about processing a specific SELECT or DML statement.
A cursor is a pointer to a permanent work area created in the system memory that stores information about processing a specific SELECT or DML statement.
A cursor is a pointer to a temporary work area created in the system memory that stores information about processing a specific DDL statement.
A cursor is a pointer to a permanent work area created in the system memory that stores information about processing a specific DDL statement.

What is the scope of the label used in the GOTO statement?

1 Mark(s)

The label should be defined in the same block or enclosing block as the GOTO statement
The label should be defined in the outer block as the GOTO statement
The label should be defined in the enclosing block or invoking block as the GOTO statement
The label should be defined in the same scope as the GOTO statement

What is a standalone subprogram?

1 Mark(s)

A subprogram created at the schema level
A subprogram created at the database level
A subprogram created at the user level
A subprogram created at the session level

What is a standalone function?

1 Mark(s)

It is the function created in memory
It is the function inside another PL/SQL lock
It is the function that is stored in the database
It is the function that cannot have any parameters

Which of the following statements is rarely used in PL/SQL?

1 Mark(s)

WHILE statement
LOOP
GOTO
Null Statement

What happens when PL/SQL compiler hits a NULL statement?

1 Mark(s)

Control passes to the next statement
Control reaches the end of the code
Control goes to the next statement outside the loop
Control goes to the invoking code or user

How many RETURN statements can a function have?

1 Mark(s)

Zero or more
Zero or one
Always one only
One or more

What happens when the condition of the CONTINUE WHEN statement is not true in a FOR Loop?

1 Mark(s)

CONTINUE WHEN statement does nothing
CONTINUE WHEN statement throws an error
The loop is terminated
The current iteration is skipped

What does %FOUND attribute indicate?

1 Mark(s)

It indicates that the cursor was found
It indicates that the number of rows that got affected.
It indicates whether any rows were affected.
It indicates whether any rows were not affected.

What is the initial value of index for a reverse for loop?

1 Mark(s)

UPPER bound
Lower bound
1
Upper bound-Lower bound/2

Which of the following is not true about Sequential Control statements?

1 Mark(s)

Sequential control statements are crucial to PL/SQL programming.
Occasionally, GOTO statement simplifies logic enough to warrant its use
NULL statement can improve readability by making the meaning and action of conditional statements clear.
Sequential control statements are used to handle out of the ordinary requirements for sequential processing.

Which of the following functions gives the error code of the most recently occurred exception?

1 Mark(s)

SQLERRCODE
SQLERROR
ERRCODE
SQLCODE

Which of the following part of a PL/SQL subprogram is mandatory?

1 Mark(s)

Executable and exception handling part only
Declaration, Executable and Exception handling part
Declaration and Executable part
Executable part only

Which of the following is incorrect about GOTO statement?

1 Mark(s)

A GOTO statement can transfer control into an IF statement, CASE statement, LOOP statement, or subblock
A GOTO statement cannot transfer control from one IF statement clause to another.
A GOTO statement cannot transfer control from one CASE statement WHEN clause to another.
A GOTO statement cannot transfer control out of a subprogram.

What happens in a REVERSE FOR Loop?

1 Mark(s)

The output is printed in reverse order
Upper bound is always less than lower bound value
Index is decremented for every iteration
Start and end bound values of the FOR Loop is non-numeric

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