Oracle Database 11g: Advanced PL/SQL — Question 5

Which two statements are true about the initialization of internal LOBs? (Choose two.)

Answer options

• A. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal LOBs
• B. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only -non-null internal LOBs
• C. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and non-null internal LOBs
• D. The CLOB and BLOB columns can be initialized with a character or raw string, respectively, provided they are less than 4000 bytes in size

Correct answer: C

Explanation

Option C is correct because the EMPTY_CLOB() and EMPTY_BLOB() functions can indeed initialize both null and non-null internal LOBs. Options A and B are incorrect as they restrict the initialization to only null or only non-null LOBs, which is not true. Option D is also incorrect because it doesn't address the initialization with EMPTY_CLOB() and EMPTY_BLOB() functions.