Question

Which of the following PL/SQL blocks requires the variable to always contain a particular value within the block?

Accepted Answer

A)  DECLARE
Order NUMBER(2) := 0;
Departure DATE;
BEGIN
---- executable statements ---
END; 
B)  DECLARE
Order NUMBER(2,2) := .06;
Departure DATE;
BEGIN
---- executable statements ---
END; 
C)  DECLARE
Order CONSTANT NUMBER(2,2) := .02;
Departure DATE;
BEGIN
---- executable statements ---
END; 
D)  DECLARE
Order NUMBER(2) CONSTANT := .03;
Departure DATE;
BEGIN
---- executable statements ---
END; 
A)  DECLARE
Order NUMBER(2) := 0;
Departure DATE;
BEGIN
---- executable statements ---
END; 
B)  DECLARE
Order NUMBER(2,2) := .06;
Departure DATE;
BEGIN
---- executable statements ---
END; 
C)  DECLARE
Order CONSTANT NUMBER(2,2) := .02;
Departure DATE;
BEGIN
---- executable statements ---
END; 
D)  DECLARE
Order NUMBER(2) CONSTANT := .03;
Departure DATE;
BEGIN
---- executable statements ---
END;

Which of the following PL/SQL blocks requires the variable to always contain a particular value within the block?

Introduction To PL/SQL

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters

Exam 2: Basic PL/SQL Block Structures

Which of the following PL/SQL blocks requires the variable to always contain a particular value within the block?

Introduction To PL/SQL

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters