QUESTION 81Examine this code:CREATE OR REPLACE FUNCTION gen_email_name(p_first VARCHAR2, p_last VARCHAR2)RETURN VARCHAR2ISv_email_name VARCHAR (19) ;BEGINv_email_bame := SUBSTR(p_first, 1, 1) ||SUBSRE(p_last, 1, 7) ||RETURN v_email_name;END/Which two statements are true?can will1.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