SQL*Loader   «Prev  Next»

Create Temporary Tables - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which SQL*Loader feature can load a supported simple delimited file into an existing table without a user-supplied control file?
Please select the best answer.
  A. SQL*Loader express mode
  B. DIRECT=TRUE by itself, for every input format
  C. Loading any BLOB column, regardless of the input format
  D. Using a parameter file always eliminates the control file

2. Which statement about the size of an internal BLOB value in Oracle 26ai is correct?
Please select the best answer.
  A. Every BLOB value is limited to 2000 bytes.
  B. A BLOB value has no database or storage limit.
  C. Every BLOB value has a fixed maximum of 4 GB.
  D. A BLOB can exceed 4 GB; its database size limit depends on the relevant block size, and loading tools can impose additional constraints.

3. Which statement is FALSE for an Oracle global temporary table?
Please select the best answer.
  A. Indexes can be created on the table.
  B. Different sessions can use the same table definition while their rows remain private to each session.
  C. ON COMMIT determines whether its rows are transaction-specific or session-specific.
  D. Oracle automatically drops the table definition whenever a session using it ends.

4. A session needs rows in a global temporary table to survive COMMIT and remain available to that same session until it disconnects, unless explicitly removed earlier. Which clause should be used when creating the table?
Please select the best answer.
  A. ON COMMIT DELETE ROWS
  B. ON COMMIT PRESERVE ROWS
  C. ON COMMIT DROP DEFINITION
  D. ON COMMIT PRESERVE DEFINITION

5. An Oracle private temporary table is created with ON COMMIT DROP DEFINITION. What happens when its transaction commits?
Please select the best answer.
  A. Both its data and its table definition are dropped.
  B. Its data is removed, but its definition remains permanently shared.
  C. Its rows become visible to other sessions.
  D. It becomes a permanent table.