READ Free Dumps For Oracle- 1z0-023
| 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 |
Explanation 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. 373-374 Chapter 8: Managing Database Objects
| 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 |
Explanation 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