C 16 rollback segments d four rollback segments e

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: ents. E. Eight rollback segments. Answer: E Explanation: Answer E is correct. You need to create 8 rollback segments to handle 32 transactions in the OLTP system. There is the Rule of four to plan rollback segments numbers for OLTP systems. Take the total number of transactions that will hit the database at any given time, and divide by 4 to decide how many rollback segments to create. Incorrect Answers: A: It's just wasting of resources to keep one rollback segment for each user. B: It's not reasonable to create one rollback segment for each transaction. C: Use the Rule of four to calculate the number of rollback segments. D: Use the Rule of four to calculate the number of rollback segments. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 373 Chapter 8: Managing Database Objects I QUESTION 110: A transaction fails and returns an ORA-01562 indicating that there is insufficient space in the rollback segment. What are two possible causes? (Choose two) Actualtests.com - The Power of Kn...
View Full Document

Ask a homework question - tutors are online