RelationalDBDesign RelationalDBDesign


Space Management   «Prev  Next»

Oracle TableSpace - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which of the following SQL statements will not allow you to set storage parameters?
Please select the best answer.
  A. CREATE TABLE
  B. CREATE TABLESPACE
  C. CREATE DATABASE
  D. CREATE INDEX

2. If the NEXT parameter for an extent is 100K and the PCTINCREASE parameter is 50, the third extent allocated will be?
Please select the best answer.
  A. 50K
  B. 100K
  C. 150K
  D. 225K

3. Specifying default storage parameters for a tablespace can do which two things?
Please select all the correct answers.
  A. You can set storage parameters when you create or alter a table.
  B. If you specify storage parameters for a table, all segments in the table use them.
  C. You must specify storage parameters for each object.
  D. Specifying default storage parameters for a tablespace can decrease maintenance overhead.