試題詳解

QUESTION 81 Examine this code: CREATE OR REPLACE FUNCTION gen_email_name (p_first VARCHAR2, p_last VARCHAR2) RETURN VARCHAR2 IS v_email_name VARCHAR (19) ; BEGIN v_email_bame := SUBSTR(p_first, 1, 1) || SUBSRE(p_last, 1, 7) || RETURN v_email_name; END / Which two statements are true? can will 1. This function is invalid. 2. This function can be used against any table. 3. This function cannot be used in a SELECT statement. 4. This function can be used only if the two parameters passed in are not bull values. 5. This function will generate a string based on 2 character values passed into the function. 6. This function can be used only on tables where there is a p_first and p_last column.
(A)12
(B)34
(C)45
(D)56