Exam 1z0-148 topic 1 question 73 discussion

DE is correct

The Second Parameter (TRUE/FALSE) is for uppercase(TRUE) and lower case (FALSE).. however when the string is quoted between double quotes and is in lower case it is still displayed in lower case when the parameter is TRUE. Rectified Option D&E D. SET SERVEROUTPUT ON; BEGIN DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message' , FALSE)); END; E. SET SERVEROUTPUT ON; BEGIN DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('"this is a test message"', TRUE)); END;

set serveroutput on declare BEGIN --a : ok DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message', TRUE)); --b : error --DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a " "test" " message', TRUE)); --c: error --DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('"this is a "test" message"', TRUE)); --d ok: DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('"this is a test message" ', TRUE)); --e : ok DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message' , FALSE)); end; REsult: "THIS IS A TEST MESSAGE" "this is a test message" "this is a test message" then: the correct answer is D,E

This question has some typo.. the correct options as seen on another source is given below: D is actually: BEGIN DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('"this is a test message"',TRUE));END; and E is: BEGIN DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message',FALSE));END; Both gives output as "this is a test message".

BEGIN DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (‘this is a test message ’, FALSE)); END; BEGIN DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (‘ “this is a test message” ’, TRUE)); END;

here is a big typo i think ... in C and D is the same and is there space between ' and " ... dbms_assert fail. :(

Propably answers has typos. Two methods that I found to print this output are: BEGIN DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME('this is a test message', FALSE)); END; BEGIN DBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME('"this is a test message"', FALSE)); END;

D, not C. The Boolean indicates whether the output should be capitalized (true) or not (false), so it looks like something else may be wrong with this question.