exam questions

Exam 1z0-148 All Questions

View all questions & answers for the 1z0-148 exam

Exam 1z0-148 topic 1 question 34 discussion

Actual exam question from Oracle's 1z0-148
Question #: 34
Topic #: 1
[All 1z0-148 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Rakeshpro
2 years, 4 months ago
Selected Answer: BD
EXISTS(n) returns TRUE if the nth element in a collection exists. Otherwise, EXISTS(n) returns FALSE.
upvoted 1 times
...
chrishillinger
2 years, 5 months ago
Selected Answer: BD
BD is correct
upvoted 1 times
...
CosminCof
4 years, 2 months ago
BD correct
upvoted 4 times
...
Adela_bg
4 years, 7 months ago
BD - checked
upvoted 2 times
...
szefco
4 years, 8 months ago
B and E are correct answers. I verified it.
upvoted 1 times
CosminCof
4 years, 4 months ago
B and D, not E because we see in this snippet using EXTEND function wich adds an NULL element in the collection.
upvoted 1 times
...
...
orakell
5 years, 2 months ago
BD, not DE.
upvoted 3 times
...
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago