exam questions

Exam 1z0-144 All Questions

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

Exam 1z0-144 topic 1 question 108 discussion

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

The STRING_TAB table has the following structure:

View the Exhibit and examine the code.

What is the outcome on execution?

  • A. It displays Output buffer not long enough. This is my test string.-.
  • B. It displays only Output buffer not long enough, and exits the anonymous block.
  • C. It displays only - Because EXCEPTION should have been defined in the anonymous block to get the error message. This is my test string.
  • D. It does not display any of the DBMS_OUTPUT messages and gives an error because a transaction control statement cannot be used in the exception section
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
chamisso
Highly Voted 5 years ago
the same question like NO.10. A is correct.
upvoted 10 times
...
trex_fcs
Most Recent 1 year, 10 months ago
Selected Answer: A
A, because exception catch without raise.
upvoted 1 times
...
BM2000
1 year, 11 months ago
Selected Answer: A
A, repeat question
upvoted 1 times
...
chaoyuim
4 years, 9 months ago
AAAAAA
upvoted 4 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