Multiple Choice
Which of the following PL/SQL blocks requires the variable to always contain a particular value within the block?
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;
Correct Answer:

Verified
Correct Answer:
Verified
Q71: A(n) _ variable can hold only a
Q72: The BEGIN section of a PL/SQL block
Q73: The CASE statement begins with the keyword
Q74: By indicating a numeric range, the _
Q75: The _ section of the PL/SQL block
Q76: The syntax of the following code fragment
Q77: The<u> EXCEPTION </u>section of a PL/SQL block
Q78: Which of the following evaluates conditions and
Q79: The _ section of a PL/SQL block
Q80: Which of the following code fragments would