PL/SQL Quiz_ADBMS

PL/SQL is a -

• Brick Structured Language

• Block Structured Language

• Banner Structured Language

• Build Structured Language

PL/SQL text is made up of lexical units, which are groups of characters and can be classified as -

• Delimiters

• Identifiers

• Literals

• All of the above

PL/SQL Variables are by default -

• Case Sensitive

• Upper Case Sensitive

• Lower Case Sensitive

• Not Case Sensitive

____ are values used in PL/SQL blocks that do not change during execution.

• Variables

• Constants

• Functions

• Cursor

____ are values which do not have an identifier and are numeric, character, string, or boolean.

• Constants

• Literals

• Cursor

• Variables

CASE statement uses which keyword to work like IF statement?

• INTO

• AS

• WHEN

• IN

A/An _______ loop in PL/SQL ensures that at least one statement is executed before the loop terminates.

• While

• For

• Cursor For

• Exit

Which of the following are the pass parameters in procedure?

• IN

• OUT

• INOUT

• All of the above

PL/SQL function must contain a -

• Follow Statement

• GOTO Statement

• Return Statement

• NULL Statement

___ are values which do not have an identifier and are numeric, character, string, or boolean.

• Constants

• Literals

• Cursor

• Variables