|
Explanation: After executing this statement the content and data files belonging to the IND2 tablespace will be dropped. Incorrect Answers: 2: 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. 3: 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. 4: The contents of the tablespace are dropped along with all its data files. Reference: 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
|