New Features for Administrators - Question 049

Examine the statement:

DROP TABLESPACE IND2
INCLUDING CONTENTS
AND DATAFILES;

What is the result of the statement?

A. The contents and data files belonging to the IND2 tablespace are dropped.

B. The statement will only succeed if the IND2 tablespace was built using Oracle-Managed Files (OMF) data files.

C. The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle-Managed Files (OMF) or if the database was created using OMF.

D. The contents of the tablespace are dropped along with all its data files except those identified with the Oracle-Managed Files (OMF) naming convention.

Answer: A

Explanation:

After executing this statement the content and data files belonging to the IND2 tablespace will be dropped.

Incorrect Answers

B: The statement will only succeed in any case if the tablespace is offline. There is no requirement that IND2 tablespace had to be built using Oracle-Managed Files (OMF) data files.

C: The statement will only succeed in any case if the tablespace is offline. There is no requirement that IND2 tablespace had to be built using Oracle-Managed Files (OMF) data files or the database was created using OMF.

D: The contents of the tablespace are dropped along with all its data files.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-158

Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 2-12

Chapter 1: Oracle9i Database Administration and Management Features