AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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
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. 373-374 Chapter 8: Managing Database Objects
Update Date and Time 2017-08-10 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 2017-08-10 04:40:20