1Z0-146 Question #94: Real Exam Question with Answer & Explanation

Examine the structure of the PRINT_MEDIA table: Name Null? Type --------------- -------- --------- ADVT_ID NUMBER ADVT_SOURCE CLOB Examine the following PL/SQL block: DECLARE lobloc CLOB; buffer VARCHAR2(100); amount NUMBER; offset NUMBER :=1; BEGIN buffer :='This is the second line of a new document'; amount := LENGTH(buffer); SELECT advt_source INTO lobloc FROM print_media WHERE advt_id=2 FOR UPDATE; DBMS_LOB.WRITE(lobloc,amount,offset,buffer); COMMIT; END; / What must be the value in the ADVT_SOURCE column for the above code to execute successfully?