Dell EMC Specialist – Systems Administrator, VPLEX — Question 8

You are designing a cloud to support an Oracle OLTP environment. What is the recommended read/write ratio to use in this environment?

Answer options

• A. 2 to 1
• B. 3 to 1
• C. 4 to 1
• D. 5 to 1

Correct answer: D

Explanation

The recommended read/write ratio for an Oracle OLTP environment is 5 to 1, as OLTP systems typically involve a higher number of read operations compared to write operations. Ratios like 2 to 1, 3 to 1, and 4 to 1 do not adequately reflect the workload distribution common in OLTP scenarios.