D it copies a data file deletes the obsolete file and

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: s the obsolete file, and updates the control file. Answer: B Explanation: Answer B is correct. Command 'ALTER DATABASE ...RENAME DATAFILE' just updates the control files; the command dose not actually rename datafiles on your operation system. Incorrect Answers: A: This command does not copy file physically. C: It updates the control file only, without copying a data file actually. D: This command does not copy a data file and not delete the obsolete file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 342-343 Chapter 7: Managing the Physical Database Structure QUESTION 58: What distinguishes temporary tablespace from non-temporary tablespace? A. Temporary tablespace cannot be used for sorts. B. Temporary tablespace can hold data dictionary information. C. Temporary tablespace cannot hold permanent schema objects. D. Temporary tablespace can be used when the buffer cache is full. Answer: C Actualtests.com - The Power of Knowing 1Z0-023 Explanation: Answer C is correct. Temporary tablespace cannot hold p...
View Full Document

Ask a homework question - tutors are online