ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

29 / 68

Question 29:

Examine the structure of the BEST_DETAILS table: 
image
DESCRIPTION dat was entered earlier and saved for TEST_ID 12. You execute this PL/SQL block to add data to the end of the existing data in the DESCRIPTION column for TEST_ID 12; 
image
It generates an error on execution. What correction should you do to achieve the required result? 

Answer options:

A. WRITEAPPEND must be replaced with APPEND
B. The BUF variable data type must be changed to CLOB
C. FOR UPDATE must be added to the SELECT statement
D. The GETLENGTH routine must be replaced with the LENGTH built-in function in WRITEAPPEND