Multiple Choice
Which of the following initializes the variable order?
A) DECLARE
Order NUMBER(2) ;
Departure DATE;
BEGIN
---- executable statements ---
END;
B) DECLARE
Order NUMBER(2) = 0;
Departure DATE;
BEGIN
---- executable statements ---
END;
C) DECLARE
Order NUMBER(2) =: 0;
Departure DATE;
BEGIN
---- executable statements ---
END;
D) DECLARE
Order NUMBER(2) := 0;
Departure DATE;
BEGIN
---- executable statements ---
END;
Correct Answer:

Verified
Correct Answer:
Verified
Q31: Even though the EXIT clause can be
Q32: With respect to processing efficiency, the less
Q33: The common data types used for <u>cursor</u>
Q34: Which of the following code fragments would
Q35: Which of the following allow us to
Q37: Which of the following lines of code
Q38: _ are used to change the values
Q39: The simple IF statement performs an action
Q40: The _ section of a PL/SQL block
Q41: IF rec_order.state = 'VA' THEN lv_tax_num :=