Oracle Tablespaces and Quotas - Quiz

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

1. When you create an object without specifying a tablespace, how does Oracle decide where to put it?
Please select the best answer.
  A. Oracle will always place the object in the SYSTEM tablespace.
  B. Oracle will use your default tablespace, if one exists, otherwise it will use the SYSTEM tablespace.
  C. Oracle will use your default tablespace, if one exists, otherwise it will use your temporary tablespace.
  D. Oracle will use your temporary tablespace, if one exists, otherwise it will use the SYSTEM tablespace.
  The correct answer is B.The correct answer is B because Oracle's last resort is always to use the SYSTEM tablespace. However, Oracle will check your default tablespace assignment first.

2. What is a quota?
Please select the best answer.
  A. A special type of quotation mark that Oracle recognizes in order to allow quoted strings to be nested
  B. The amount of disk space that all users together are allowed to use within a database
  C. The amount of CPU time that a user may use while reading data from one specific tablespace
  D. The amount of disk space a user may use in one specific tablespace
  The correct answer is D. The correct answer is D because a quota represents an allowance of disk space that a user may use in one specific tablespace. If a user is not assigned a quota on a tablespace, then that user will be unable to store objects in that tablespace.


3. How many quotas may a user have?
Please select the best answer.
  A. It depends on the DB_MAX_QUOTAS parameter
  B. A user may have an unlimited number of quotas
  C. A user may have one quota per tablespace
  D. Users are limited to one quota
  The correct answer is C. A user may have one quota per tablespace. So if there are 50 tablespaces in a database, a user may have 50 quotas.

4. What is the major advantage to specifying a temporary tablespace for a user?
Please select the best answer.
  A. Disk activity for sorts can be isolated from the rest of the database
  B. Disk space is conserved because sorted data do not need to be kept permanently
  C. The user does not need to specify a temporary tablespace in his queries
  D. Having a temporary tablespace assignment allows the user to use ORDER BY to sort query results
  The correct answer is B. The correct answer is B because designating one or more tablespaces for sorting allows you to avoid using disks that are used for database objects such as tables, rollback segments, and so forth. Most importantly, specifying a temporary tablespace for a user prevents sorts from being done in the SYSTEM table space.