Creating Users   «Prev  Next»

Tablespaces and Quotas - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. When a user creates an object without specifying a tablespace, how does Oracle choose its permanent tablespace?
Please select the best answer.
  A. Oracle always places the object in the SYSTEM tablespace.
  B. Oracle uses the user's default tablespace. If none was assigned, it uses the database default permanent tablespace, or SYSTEM if the database has no default.
  C. Oracle uses the user's temporary tablespace when no tablespace appears in the object definition.
  D. Oracle selects whichever permanent tablespace currently has the most free space.

2. What is a tablespace quota?
Please select the best answer.
  A. A limit on how many SQL statements a user may execute in one session
  B. The amount of disk space that all users together may allocate in the database
  C. A limit on the temporary space used by one sort operation
  D. The maximum amount of space a user may allocate in one particular permanent tablespace

3. How may tablespace quotas be assigned to one user?
Please select the best answer.
  A. The number is controlled by a DB_MAX_QUOTAS initialization parameter.
  B. Only one quota may be assigned across the entire database.
  C. The user may have one quota for each eligible permanent tablespace.
  D. One quota applies automatically to every permanent and temporary tablespace.

4. What is a major advantage of directing a user's temporary segments to a dedicated temporary tablespace?
Please select the best answer.
  A. Temporary-segment I/O can be isolated from permanent objects and the SYSTEM tablespace.
  B. Every sort operation is guaranteed to use less disk space.
  C. The user no longer needs to include an ORDER BY clause in a query.
  D. Oracle retains intermediate sort data permanently for later sessions.