Which of the Following Code Fragments Would Not Raise an Error

question 6

Multiple Choice

Which of the following code fragments would not raise an error?

• A) CREATE OR REPLACE FUNCTION ship_calc(p_qty IN NUMBER)
• IS
• Lv_ship_num NUMBER(5,2);
• BEGIN
• IF p_qty > 10 THEN
• Lv_ship_num := 11.00;
• ELSE
• Lv_ship_num := 5.00;
• END IF;
• RETURN lv_ship_num;
• END;
• B) CREATE OR REPLACE ship_calc(p_qty)
• RETURN NUMBER
• IS
• Lv_ship_num NUMBER(5,2);
• BEGIN
• IF p_qty > 10 THEN
• Lv_ship_num := 11.00;
• ELSE
• Lv_ship_num := 5.00;
• ENDIF;
• RETURN lv_ship_num;
• END;
• C) CREATE OR REPLACE FUNCTION ship_calc(p_qty IN NUMBER)
• RETURN NUMBER
• IS
• Lv_ship_num NUMBER(5,2);
• BEGIN
• IF p_qty > 10 THEN
• Lv_ship_num := 11.00;
• ELSE
• Lv_ship_num := 5.00;
• END IF;
• RETURN lv_ship_num;
• END;
• D) CREATE OR REPLACE FUNCTION ship_calc(p_qty IN NUMBER)
• RETURN NUMBER
• BEGIN
• IF p_qty > 10 THEN
• Lv_ship_num := 11.00;
• ELSE
• Lv_ship_num := 5.00;
• END IF;
• RETURN lv_ship_num;
• END;

---

Definitions:

Psychographic Segmentation

A marketing strategy that divides the market based on consumer personality traits, lifestyles, interests, attitudes, or values to better target marketing messages.

Perceptual Map

A visual representation used in marketing to show customers' perceptions of a brand or product compared to competitors, based on criteria important to the customer.

Perceptual Map

A perceptual map is a visual tool used in marketing to depict the positions of different products or brands on a grid, based on important customer perceptions or preferences.

Position

The place a brand or product occupies in consumers' minds relative to competing offerings, based on attributes, benefits, values, and perceptions.