READ Free Dumps For Oracle- 1z0-023
| Question ID 8896 | You are shutting down a database with one tablespace offline. What is the status of this tablespace after restarting the database?
|
| Option A | It is lost.
|
| Option B | It is online.
|
| Option C | It is offline
|
| Option D | It is in recover mode.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. This tablespace will have offline status after database restart. A tablespace can be taken offline with one of several priorities, including normal, temporary, and immediate. Depending on the priority used to take the tablespace offline, media recovery on that tablespace may be required. A tablespace taken offline with normal priority will not require media recovery, but a tablespace taken offline with immediate priority will. A tablespace taken offline with temporary priority will not require recovery if none of the datafiles were offline prior to taking the tablespace offline. Incorrect Answers: A: The tablespace will be in offline status, not lost. B: The tablespace will be in offline status, not online. D: The tablespace will be in offline status, not recover. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 340-342 Chapter 7: Managing the Physical Database Structure
| Question ID 8897 | Which action physically relocates a tablespace?
|
| Option A | Issuing the ALTER DATABASE MOVE TABLESPACE...command.
|
| Option B | Issuing the ALTER TABLESPACE RENAME DATAFILE...command.
|
| Option C | Issuing the ALTER TABLESPACE RENAME TABLESPACE...command.
|
| Option D | Using an operating system utility like copy or cp to copy the tablespace datafiles to another device.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. Only operation system utility like copy or cp physically copy tablespace datafiles to another disk. Incorrect Answers: A: ALTER DATABASE MOVE TABLESPACE command just reset data in the control file. B: ALTER TABLESPACE RENAME DATAFILE command just reset data in the control file. C: There is no ALTER TABLESPACE RENAME TABLESPACE command in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 342-343 Chapter 7: Managing the Physical Database Structure