PL/SQL   «Prev  Next»

Querying Modifying LOBs - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which statement correctly distinguishes an internal LOB from a BFILE?
Please select the best answer.
  A. An internal LOB must be in an object table, and BFILE content is stored in a separate database tablespace.
  B. A BFILE contains a copy of its file bytes inside the database.
  C. Internal LOB content is managed in database storage; a BFILE locator references an external file accessible to the database server.
  D. DBMS_LOB can modify external BFILE bytes in the same way as an internal BLOB.

2. What distinguishes CLOB from NCLOB?
Please select the best answer.
  A. CLOB supports only single-byte text, while NCLOB supports all Unicode text.
  B. CLOB uses the database character set, while NCLOB uses the national character set.
  C. CLOB stores binary file bytes, while NCLOB stores character data.
  D. NCLOB stores an external-file reference, while CLOB stores internal text.

3. Which statement about populating internal LOB columns is correct?
Please select the best answer.
  A. Only SQL*Loader and DBMS_LOB can populate LOB columns.
  B. SQL assignments, supported application-driver interfaces, DBMS_LOB operations, and SQL*Loader provide different ways to populate LOB columns.
  C. EMPTY_BLOB() copies a source file into a BLOB column automatically.
  D. A BFILE reference always copies its external file into an internal BLOB.

4. Which statement accurately describes the DBMS_LOB package?
Please select the best answer.
  A. It is used only to load new LOB values.
  B. It provides the same write and erase operations for BFILE content as for internal BLOB content.
  C. It automatically renders binary photographs and PDF documents in SQL*Plus.
  D. It provides routines for inspecting, reading, and modifying supported internal LOBs, plus read-only access to BFILE content.

5. A non-NULL CLOB contains ten ASCII characters. With a valid locator and the required row lock, DBMS_LOB.ERASE successfully erases three characters starting at offset 4. What is the result?
Please select the best answer.
  A. Three characters are replaced by spaces, and the CLOB length remains ten.
  B. Three characters are removed, and the remaining characters shift left to give length seven.
  C. The entire CLOB becomes NULL.
  D. The containing table row is deleted.