Home » Oracle » 1z0-052 v.2 » Which statements describe the effect of the command?
You execute the following command to change the status of the SALES tablespace:
SQL> ALTER TABLESPACE sales OFFLINE;
Which statements describe the effect of the command? (Choose all that apply.)
A. The tablespace would require recovery to go back online.
B. A checkpoint is taken on all data files that are associated with the SALES tablespace.
C. The sessions that subsequently try to access the objects in the SALES tablespace receivean error.
D. The new status of the SALES tablespace is recorded in the control file when the database instance is closed.
Correct Answer: BC
Explanation/Reference:
Altering a Tablespace (continued)
• Offline: You can take an online tablespace offline so that this portion of the database is temporarily unavailable for general use. The rest of the database is open and available for users to access data. When you take it offline, you can use the following options:
-Normal: A tablespace can be taken offline normally if no error conditions exist for any of the data files of the tablespace. Oracle Database ensures thatall data is written to disk by taking a checkpoint for all data files of the tablespace as it Takes Them offline.
-Temporary: A tablespace can be taken offline temporarily even if there are error conditions for one or more files of the tablespace. Oracle Databasetakes the data files (which are not already offline) offline, performing checkpointing on them as it does so. If no files are offline, but you use the Temporary clause, media recovery is not required to bring the tablespace back online. However, if one or more files of the tablespace are offline because of write errors, and you take the tablespace offline temporarily, the tablespace requires recovery before you can bring it back online. – Immediate: A tablespace can be taken offline immediately without Oracle Database taking a checkpoint on any of the data files. When yon specify Immediate, media recovery for the tablespace is required before the tablespace can be brought online. You cannot take a tablespace offline immediately if the database is running in NOARCHIVELOG mode.
-For Recover: The FOR RECOVER setting has been deprecated. The syntax is supported for backward compatibility.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
