Multiple choice technology databases

When an oracle Instance is started, background process are started. Background processes perform which two functions ? (Choose two)

  1. Perform I/O

  2. Lock rows that are not data dictionary rows

  3. Monitor other Oracle processes

  4. Connect users to the Oracle instance

  5. Execute SQL statments issued through an application
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

Oracle background processes perform specialized I/O operations (like DBWn writing dirty buffers) and monitor other Oracle processes (like PMON cleaning up failed processes, SMON performing recovery). These functions are separated from user processes to improve efficiency.

Keep practicing — related questions