Multiple Choice
Which of the following code fragments would not raise an error?
A) DECLARE
V_amt1 number(5,2) ;
V_amt2 number(3,0) ;
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND(v_amt1)
DBMS_OUTPUT.PUT_LINE(v_ amt2) ;
END;
B) DECLARE
V_amt1 number(5,2) ;
V_amt2 number(3,0) ;
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND(v_amt1,1) ;
DBMS_OUTPUT.PUT_LINE(v_ amt2) ;
END;
C) DECLARE
V_amt1 number(5,2) ;
V_amt2 number(3,0) ;
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND v_amt1, 2;
DBMS_OUTPUT.PUT_LINE(v_ amt2) ;
END;
D) DECLARE
V_amt1 number(5,2) ;
V_amt2 number(3,0) ;
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND[v_amt1,0];
DBMS_OUTPUT.PUT_LINE(v_ amt2) ;
END;
Correct Answer:

Verified
Correct Answer:
Verified
Q41: _ cannot be used in SQL statements.
Q42: The term "passed by reference" means that
Q43: The default behaviors of value passing can
Q44: The term <u>passed by reference</u> implies that
Q45: Functions used in SQL statements must meet
Q46: The _ command is used to view
Q47: Which of the following correctly creates a
Q48: You cannot include _ information when declaring
Q49: You can include multiple RETURN statements in
Q51: In a(n) <u>function</u>, the RETURN statement includes