Managing Tablespaces   «Prev  Next»
 

Coalescing Freespace - Quiz

Tablespace extents and space

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

1. You need to add 100 megabytes of space to the COIN tablespace, which already has 100 megabytes of space. Which two of the following SQL statements represent possible approaches you could take?
Please select all the correct answers.
  A. ALTER TABLESPACE DATAFILE 'coin01.dat' RESIZE 200M;
  B. ALTER TABLESPACE coin ADD DATAFILE 'coin02.dat' SIZE 100M;
  C. ALTER DATAFILE 'coin01.dat' RESIZE 200M;
  D. ALTER DATABASE DATAFILE 'coin01.dat' RESIZE 200M;

2. You are creating a new tablespace, and you want Oracle to increase the size of that tablespace automatically as needed. How do you accomplish this?
Please select the best answer.
  A. In the STORAGE clause for your CREATE TABLESPACE statement, set MAXEXTENTS to UNLIMITED.
  B. Add the AUTOEXTEND clause to your CREATE TABLESPACE statement, and set the maximum size to UNLIMITED.
  C. Add the AUTOEXTEND clause to your CREATE TABLESPACE statement, and set the NEXT size to UNLIMITED.
  D. When you create objects in the new tablespace, create them using a MAXEXTENTS value of UNLIMITED.

3. You have just issued this command: ALTER TABLESPACE coin COALESCE;. What is the result?
Please select the best answer.
  A. All extents for tables and indexes within the COIN tablespace will be merged into one large extent.
  B. All free extents within the COIN tablespace will be merged into a single, large free extent.
  C. Adjacent free extents within the COIN tablespace will be merged into a single, larger free extent.
  D. Large extents of free space within the COIN tablespace will be broken up into smaller, more usable extents.