READ Free Dumps For Oracle 1z0023
Question ID 8751  When creating rollback segments, what is the recommended value for MINEXTENT minimize dynamic extension?

Option A  15

Option B  20

Option C  Five

Option D  ten per transaction

Option E  number_of_users*25

Correct Answer  B 
Description Explanation/Reference: Explanation: Answer B is correct. By using more extents in the initial rollback segment allocation  determined by the MINEXTENTS storage option  you reduce the probability of your rollback segment extending. Oracle recommends 20 (or more) extents as part of the initial rollback segment allocation. Incorrect Answers: A: To minimize the probability of your rollback segment extending Oracle recommends 20 or more extents for the initial rollback segment, not 15. C: To minimize the probability of your rollback segment extending Oracle recommends 20 or more extents for the initial rollback segment, not 5. D: Each transaction uses one rollback segment, not some, so this answer is completely incorrect. E: There is the Rule of Four to plan rollback segment numbers for OLTP systems. It recommends to calculate number of rollback segments by dividing the total number of concurrent transactions that will hit the database at any given time by 4. This rule have nothing to do with number of users. Also question does not specify exactly that we use OLTP system. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 373374 Chapter 8: Managing Database Objects
Update Date and Time 20170810 04:37:30
Question ID 8753  MINEXTENT must be at least _____ when a rollback segment is created.

Option A  1

Option B  2

Option C  3

Option D  5

Correct Answer  B 
Description Explanation/Reference: Explanation: Answer B is correct. The value for MINEXTENTS should be 2 or greater. Incorrect Answers: A: MINEXTENT parameter should be set to 2 or greater, not 1. C: The question asks about MINIMUM amount of MINEXTENT, this number is 2, not 3. D: The question asks about MINIMUM amount of MINEXTENT, this number is 2, not 5. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 375 Chapter 8: Managing Database Objects
Update Date and Time 20170810 04:40:20