Depending on the priority used to take the tablespace

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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 136: Which action physically relocates a tablespace? A. Issuing the ALTER DATABASE MOVE TABLESPACE...command. B. Issuing the ALTER TABLESPACE RENAME DATAFILE...command. C. Issuing the ALTER TABLESPACE RENAME TABLESPACE...command. D. Using an operating system utility like copy or cp to copy the tablespace datafiles to another device. Answer: D Explanation: Actualtests.com - The Power of Knowing 1Z0-02...
View Full Document

Ask a homework question - tutors are online