Managing Tablespaces   «Prev  Next»
 

Moving Data Files in Oracle - Quiz

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

1. You need to move the data file e:\oradata\coin\coin01.dat to the F: drive. The data file is in the COIN tablespace. Which process should you follow?
Please select the best answer.
  A. 1. Issue the command ALTER TABLESPACE coin OFFLINE;.
  B. 2. Issue the command 
ALTER DATABASE RENAME FILE 'e:\oradata\coin\coin01.dat' 
TO 'f:\oradata\coin\coin01.dat';
  C. 4. Issue the command ALTER TABLESPACE coin ONLINE; .
  D. 1. Issue the command ALTER TABLESPACE coin OFFLINE; .
  E. 2. Use operating system commands to copy the file the new location.
  F. 3. Issue the command 
ALTER DATABASE RENAME FILE 'e:\oradata\coin\coin01.dat' 
TO 'f:\oradata\coin\coin01.dat';
.
  G. 4. Issue the command ALTER TABLESPACE coin ONLINE; .
  H. 1. Use operating system commands to copy the file the new location.
  I. 2. Issue the command 
ALTER DATABASE RENAME FILE 'e:\oradata\coin\coin01.dat' 
TO 'f:\oradata\coin\coin01.dat';
  J. 3. Shut down and restart the database in order for the new location to take effect.
  K. 1. Issue the command ALTER TABLESPACE coin OFFLINE; .
  L. 2. Use operating system commands to copy the file the new location.
  M. 3. Issue the command ALTER TABLESPACE ADD DATAFILE 'f:\oradata\coin\coin01.dat' REUSE;
  N. 4. Issue the command ALTER TABLESPACE coin ONLINE; .

2. Which of the following are valid reasons for taking a tablespace offline?
Please select all the correct answers.
  A. To prevent data from being accessed
  B. To make the data read-only
  C. To back up the tablespace
  D. To move a data file in the tablespace

3. Why does Oracle not make it easy to take a data file offline when the database is running in noarchivelog mode?
Please select the best answer.
  A. Bringing the data file back online requires recovery using the archived log files.
  B. Oracle is unable to log the offline event in the database redo log files.
  C. This was an arbitrary design choice on the part of the Oracle software designers.
  D. Only logical structures, such as tablespaces, may be taken offline.

4. What does the OFFLINE DROP option do?
Please select the best answer.
  A. The OFFLINE DROP option takes a data file offline and then deletes it.
  B. The OFFLINE DROP option takes a data file offline so that you can delete it.
  C. The OFFLINE DROP option causes Oracle to delete any data files that are offline.
  D. The OFFLINE DROP option takes a tablespace offline and drops all its data files.