RelationalDBDesign RelationalDBDesign


SQL*Loader   «Prev  Next»

Create Temporary Tables - Quiz

Table Management Concepts

Each question is worth one point. Select the best answer or answers for each question.
 
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.

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

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.

4. Look at the SQL command below. Which line contains a syntax error?
Please select the best answer.
  A. 1
  B. 5
  C. 3
  D. 4

Correct answers:

Your Score: 0