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;


Answer: D

Business

You might also like to view...

In seizing land in ______________, the government's goal was to change the ethnic balance of land ownership.

Fill in the blank(s) with the appropriate word(s).

Business

________ are the last in the population to adopt a new product

A) Laggards B) Late majority adopters C) Innovators D) Impulse buyers E) Dawdlers

Business

Because Facebook, YouTube, and other social media are popular around the world, firms both large and small have embraced social media marketing

Indicate whether the statement is true or false a. True b. False

Business

Which of the following would probably be a variable cost at a college?

A) salary of the head janitor B) cost of registration forms C) salary of the college president D) none of the answers are correct

Business