This preview shows page 1. Sign up to view the full content.
Unformatted text preview: s the obsolete file, and updates the control file.
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.
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
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.
Actualtests.com - The Power of Knowing 1Z0-023 Explanation:
Answer C is correct. Temporary tablespace cannot hold p...
View Full Document
- Fall '09