Which of the Following PL/SQL Blocks Requires the Variable to Always

question 81

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;

---

Definitions:

Rhinoplasty

A surgical procedure to change the shape of the nose for cosmetic reasons or to improve breathing.

Laryngitis

Inflammation of the voice box (larynx) usually resulting in hoarseness or loss of voice.

Pharyngitis

Inflammation of the pharynx, causing sore throat and difficulty swallowing; it can be caused by viruses or bacteria.

Thoracotomy

A surgical procedure involving an incision into the chest wall to access organs in the thoracic cavity.