Pctfree c maxextent d nextextent answer b c

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: xplanation: Answers B and C are correct. PCTFEE and MAX_EXTENT parameters can affect the concurrency of transactions on a data block. Incorrect Answers: 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 QUESTION 115: 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 Explanation: 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. Incorrect Answers: A: DBA does not need to back up...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online