LOB Storage[Oracle] - Quiz Explanation
The correct answers are indicated below, along with text that explains the correct answers.
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 through your Oracle database. Which kind of data type would require the least administrative work on your part to get started?
Please select the best answer.
A.
BLOB
B.
CLOB
C.
NCLOB
D.
BFILE
Answer D is correct. Because the images are already used in word processing documents, moving to a LOB data type would require that the word processing documents be imported into the database. Therefore, a BFILE is the best to use.
2.
You want to store the Japanese translations of text used in online help files in a LOB data type. The online help is divided into smallish 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
Answer D is correct.
You want to use the NCLOB data type, because you will be storing a double-byte language. Because there will be no more than 2,000 characters, in-line storage will probably be your best choice.
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
Answer B is correct.
Because the book is in English, you should choose a CLOB database. And because the chapters of the book are likely to be longer than 4,000 characters, you would store the data out of line.
