Millionaire Mode

Oracle Database Administration and Development Practice Test

Question 1 of 20

An OLTP database was being operated in manual undo management mode and it was noticed that the query SELECT COUNT(*) from V$TRANSACTION is always less than or equal to 160 during peak transaction hours. How many rollback segments should be configured?

  1. 40
  2. 160
  3. 180
  4. 640

Prize Money

15₹7 Crores
14₹1 Crore
13₹50,00,000
12₹25,00,000
11₹12,50,000
10₹6,40,000
9₹3,20,000
8₹1,60,000
7₹80,000
6₹40,000
5₹20,000
4₹10,000
3₹5,000
2₹2,000
1₹1,000