oracle · 1z0-144 · Q603 · multiple_choice · topic_1

The STRING_TAB table has the following structure: //IMG// View the Exhibit and examine the code. //IMG// What is the…

The STRING_TAB table has the following structure: //IMG// View the Exhibit and examine the code. //IMG// 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 This is my test string. - Because EXCEPTION should have been defined in the anonymous block to get the error message.
D.It does not display any of the MEMS_PUTPUT messages and gives an error because a transaction control statement cannot be used in the exception section

Explanation

Yes, A is the correct answer. Explanation - It will enter the exception section as <out_string> variable allows only 25 characters. But the anonymous block will not terminate as exception is handled.

Reference: examtopics_top_comment

Practice with progress tracking

Start tracked practice Pricing