This preview shows page 1. Sign up to view the full content.
Unformatted text preview: xplanation:
Answers B and C are correct. PCTFEE and MAX_EXTENT parameters can affect the
concurrency of transactions on a data block.
A: PCTUSED parameter cannot affect the concurrency of transactions.
D: NEXT_EXTENT just provide size of next allocated extent, it has nothing to do with the
concurrency of transactions.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 350-352
Chapter 7: Managing the Physical Database Structure
When should a DBA back up the control file? (Choose two)
A. After a log switch.
B. After a checkpoint.
C. After adding a redo log file.
D. After dropping a tablespace.
E. After adding a new user with SYSDBA privileges.
Answer: C, D
Answers C and D are correct. The control file is the physical structure of the Oracle database. It
keeps track of all the files Oracle needs and where they are on the host machine. So a DBA
should back up the control file after adding a redo log file or after dropping a tablespace.
A: DBA does not need to back up...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09