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;
Correct Answer:

Verified
Correct Answer:
Verified
Q41: The<u> UPDATE</u> statement is sometimes called a
Q42: Discuss the meaning of the term collection.
Q43: A variable declared with a record type
Q44: A(n) _ data type is quite similar
Q45: DECLARE TYPE type_basket IS RECORD(<br>Basket bb_basket.idBasket%TYPE,<br>Created bb_basket.dtcreated%TYPE,<br>Total
Q46: A(n) _ is a variable that can
Q47: A(n) _ is a variable that can
Q49: A scalar variable can hold multiple values
Q50: One major advantage of using collections as
Q51: The _ markers are used in PL/SQL