Which of the Following Code Fragments Correctly Creates a Record

question 48

Multiple Choice

Which of the following code fragments correctly creates a record data type that will hold four variables?

• A) DECLARE
• TYPE type_basket IS RECORD (
• Basket bb_basket.idBasket %TYPE,
• Created bb_basket.dtcreated%TYPE,
• Sub bb_basket.subtotal %TYPE);
• Rec_basket type_basket;
• BEGIN
• --- executable code ---
• END;
• B) DECLARE
• TYPE type_basket IS RECORD (
• Basket bb_basket.idBasket%TYPE,
• Created bb_basket.dtcreated%TYPE,
• Qty bb_basket.quantity%TYPE,
• Sub bb_basket.subtotal%TYPE;
• Rec_basket type_basket;
• BEGIN
• --- executable code ---
• END;
• C) DECLARE
• TYPE type_basket IS RECORD (
• Bb_basket.dtcreated%TYPE
• Qty bb_basket.quantity%TYPE,
• Sub bb_basket.subtotal%TYPE);
• Rec_basket type_basket;
• BEGIN
• --- executable code ---
• END;
• D) DECLARE
• TYPE type_basket IS RECORD (
• Basket bb_basket.idBasket%TYPE,
• Created bb_basket.dtcreated%TYPE,
• Qty bb_basket.quantity%TYPE,
• Sub bb_basket.subtotal%TYPE );
• Rec_basket type_basket;
• BEGIN
• --- executable code ---
• END;

---

Definitions:

Maya Ceremonial Calendars

Ancient timekeeping systems used by the Maya civilization for religious and ceremonial purposes, including the Tzolk'in and the Haab'.

Obsidian

A naturally occurring volcanic glass formed as an extrusive igneous rock, known for its sharp edges and used historically for making tools.

Tax Purposes

For tax purposes implies considerations or actions taken to comply with tax laws and regulations, often aimed at optimizing one’s tax liabilities.

Maya Record Keeping

The system used by the ancient Maya civilization for recording astronomical observations, historical events, and calendrical information using glyphs.