Managing Tablespaces   «Prev  Next»
 

Temp Tablespaces Data Dictionary - Quiz Results


Each question is worth one point. Select the best answer or answers for each question.

1. What are two advantages of using read-only tablespaces?
Please select all the correct answers.
  A. Read-only tablespaces prevent users from accidentally changing read-only data.
  B. Read-only tablespaces do not require any disk I/O operations.
  C. Read-only tablespaces allow users to perform sort operations faster.
  D. Read-only tablespaces need to be backed up only once.

2. What type of tablespace should be used for the most efficient sorting?
Please select the best answer.
  A. Read-only
  B. Permanent
  C. Temporary
  D. Sort-only

3. You need a list of temporary tablespaces in your database. Which query will give you that list?
Please select the best answer.
  A. SELECT tablespace_name FROM dba_tablespaces WHERE contents='TEMPORARY';
  B. SELECT tablespace_name FROM dba_temporary_tablespaces;
  C. SELECT tablespace_name FROM dba_tablespaces WHERE type = 'TEMP';
  D. SELECT temporary_tablespace_name FROM dba_tablespaces;