Create Temporary Tables - Quiz
The answers you selected are indicated below, along with text that explains the correct answers.
1.
Which of these scenarios requires no control file when using SQL*Loader?
Please select the best answer.
A.
You have created your own application, which interfaces with the SQL*Loader API for loading specialty data for your clients.
B.
Your incoming data includes numbers, text, and dates, which you must load into an object table.
C.
The data you are loading includes individual 2GB files containing audio CDs.
D.
Your data contains names, addresses, and sets of phone numbers to be loaded into a varray data type.
A is correct.
A is correct because your application takes the place of the control file and calls the SQL*Loader engine directly. B, C, and D are incorrect because these are scenarios where you must create a control file to tell SQL*Loader how to load the data.
2.
What is the maximum size of a file that can be loaded into a column of the LOB data type?
Please select the best answer.
A.
No limit
B.
2000 characters
C.
2GB
D.
4GB
The correct answer is D.
The correct answer is D because 4GB is the physical limit for any LOB column.
3.
Which of the following descriptions is NOT a trait of a temporary table?
Please select the best answer.
A.
A temporary table can have an index.
B.
A temporary table can contain data inserted by two different users.
C.
A user's data is removed from a temporary table when the user's transaction or session ends.
D.
A temporary table is dropped after the user completes his session.
D is correct.
D is correct because the table is not dropped after the user completes his session--the user's data found in the temporary table is dropped. A, B, and C are all accurate descriptions of temporary table traits.