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;

Question

Quizplus · Accepted Answer

Choice D correctly creates a record data type with four variables: Basket, Created, Qty, and Sub. Choice A only has three variables and is missing Qty. Choice B has four variables but includes a syntax error with a missing closing parenthesis after Sub. Choice C also only has three variables and has an incorrect syntax by starting with Bb_basket instead of bb_basket.

Which of the Following Code Fragments Correctly Creates a Record