Examine this declaration section: Which two executable sections will display the message Summary is null?
A.
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;
B.
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;
C.
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;
D.
BEGIN 1_emp := emp_typ (); IF NOT 1_emp. EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE (Summary is null); END IF END;
E.
BEGIN 1_emp. EXTEND; IF NOT 1_emp. EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE (Summary is null); END IF
This section is not available anymore. Please use the main Exam Page.1z0-148 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Rakeshpro
2 years, 8 months agochrishillinger
2 years, 9 months agoCosminCof
4 years, 6 months agoAdela_bg
4 years, 11 months agoszefco
5 years agoCosminCof
4 years, 7 months agoorakell
5 years, 6 months ago