Managing Tablespaces   «Prev  Next»
 

Tablespace Information Oracle - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What is the purpose of the DEFAULT STORAGE clause in a CREATE TABLESPACE statement?
Please select the best answer.
  A. It defines storage attributes that are always applied to objects created in that tablespace.
  B. It defines attributes that are applied when objects are created without storage attributes of their own.
  C. It defines storage attributes that are applied for all tablespaces in the database.
  D. It allows you to change the way in which existing objects are stored in the tablespace.

2. Which of the following commands creates a tablespace of 1,000 megabytes, an initial extent size of 1 megabyte, a next extent size of 1 megabyte, and an unlimited number of extents?
Please select the best answer.
  A. CREATE DATAFILE '/m01/oradata/coin/midsize.dat' SIZE 1000M
  B. FOR TABLESPACE midsize
  C. DEFAULT STORAGE (INITIAL 1M NEXT 1M MAXEXTENTS UNLIMITED);
  D. CREATE TABLESPACE midsize
  E. DATAFILE '/m01/oradata/coin/midsize.dat' SIZE 1000M
  F. INITIAL 1M
  G. NEXT 1M
  H. MAXEXTENTS UNLIMITED
  I. CREATE TABLESPACE midsize
  J. DATAFILE '/m01/oradata/coin/midsize.dat' SIZE 1000M
  K. DEFAULT STORAGE (INITIAL 1M NEXT 1M MAXEXTENTS UNLIMITED);
  L. CREATE TABLESPACE midsize SIZE 1000M
  M. DATAFILE '/m01/oradata/coin/midsize.dat'
  N. DEFAULT STORAGE (INITIAL 1M NEXT 1M MAXEXTENTS UNLIMITED);