Large Objects  «Prev  Next»

 

LOB Storage - Quiz

Each question is worth one point. Select the best answer for each question.
1. You want to give your Oracle database users access to a set of bitmapped image files that are already used in some word processing documents. Which data type would require the least administrative work to get started?
Please select the best answer.
  BLOB
  B. CLOB
  C. NCLOB
  D. BFILE

2. You want to store Japanese translations of text used in online help files in a LOB data type. The help is divided into small portions—no more than 2,000 Japanese characters each. Which data type should you choose?
Please select the best answer.
  A. BLOB in-line
  B. CLOB in-line
  C. CLOB out of line
  D. NCLOB in-line

3. You want to store the chapters of a book you are writing in English in an Oracle database. Which data type should you choose?
Please select the best answer.
  A. CLOB in-line
  B. CLOB out of line
  C. NCLOB in-line
  D. NCLOB out of line