Which of the Following Code Fragments Tells the System to Look

Multiple Choice

Which of the following code fragments tells the system to look up the data type of a database column and use it for the declared variable?

A) DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2) ;
BEGIN
--- executable code ---
END;
B) DECLARE
Order.quantity%TYPE;
Total_amt NUMBER(2) ;
BEGIN
--- executable code ---
END;
C) DECLARE
Order.quantity#TYPE;
Total_amt NUMBER(2) ;
BEGIN
--- executable code ---
END;
D) DECLARE
Order CONSTANT NUMBER(2) := 4;
Total_amt NUMBER(2) ;
BEGIN
--- executable code ---
END;