PL/SQL   «Prev  Next»

 

Querying Modifying LOBs - Quiz


1. What is the difference between an internal and an external LOB?
Please select the best answer.
  A. An internal LOB is maintained with the object table data, whereas an external LOB is maintained within a separate tablespace.
  B. An internal LOB is maintained within the operating system of the database, whereas an external LOB is maintained within the network outside the server, which hosts the database.
  C. An internal LOB is maintained inside the database, whereas an external LOB is maintained outside the database.
  D. An external LOB is maintained within the database, whereas an internal LOB is maintained inside the server, but outside the database.

2. What is the difference between CLOB and NCLOB?
Please select the best answer.
  A. CLOB is character-based LOB, whereas NCLOB is natural-character-based LOB.
  B. NCLOB is based on the national character set, whereas CLOB is based on the character set defined in the creation of the database.
  C. CLOB has binary data, whereas NCLOB has character-based data.
  D. NCLOB is based on raw data, whereas CLOB is based on character data.

3. What are the two ways of loading data into LOB columns?
Please select the best answer.
  A. INSERT statements and Oracle Export and Import..
  B. SQL*Loader and DBMS_LOB.
  C. Oracle Backup utility and Oracle Export and Import.
  D. LOB data cannot be loaded into an Oracle database.

4. What is the utility of DBMS_LOB?
Please select the best answer.
  A. DBMS_LOB is used only for loading data into the LOB columns.
  B. Data can be erased and updated by using DBMS_LOB.
  C. DBMS_LOB is a package used for displaying the LOB data.
  D. DBMS_LOB is a package that has several utilities on internal and external LOBs, including reading, writing, appending, and erasing LOB data among other utilities.

Correct answers:

Your Score: 0