Oracle Database Advanced PL SQL 12c 1z0 148

Question : 16 of 54

Marks: +1, -0

Examine this declaration section:

Which two executable sections will display the message ‘Summary is null’? (Choose two.)

BEGIN 1_rec := NULL; 1_emp := emp_typ (1_rec); IF 1_emp (1).expr_summary IS EMPTY THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END
BEGIN 1_rec.emp_id :=1; 1_rec.expr_summary := NULL; 1_emp :=emp_typ (1_rec); IF 1_emp(1).expr_summary IS NULL THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END;
BEGIN 1_rec.emp_id :=1; 1_rec.expr_summary := EMPTY_CLOB (); 1_emp := emp_typ (1_rec); IF 1_emp(1).expr_summary IS NULL THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END;
BEGIN 1_emp := emp_typ (); IF NOT 1_emp. EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END
BEGIN 1_emp. EXTEND; IF NOT 1_emp. EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END;

Go to Question:

Prev Question

Next Question