Oracle Database 12c: Performance Management and Tuning — Question 14

In which three situations does DB time always increase? (Choose three.)

Answer options

• A. when the host is CPU bound for foreground processes
• B. when I/O wait time increases for foreground processes
• C. when more connections are made to a database instance
• D. when CPU consumption by background processes increases
• E. when wait time for data to be sent over a network increases

Correct answer: B, C, D

Explanation

The correct answers B, C, and D indicate scenarios where DB time invariably rises due to increased I/O waits, additional connections, and heightened CPU usage by background processes. Option A is incorrect because being CPU bound for foreground processes does not necessarily lead to an increase in DB time. Option E, while it indicates a delay, does not directly relate to DB time increase.