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 primarily handle I/O operations (reading/writing data files, redo logs) on behalf of server processes, and they monitor other Oracle processes for proper functioning. They do NOT execute SQL statements (that's server processes), connect users, or lock non-dictionary rows. LGWR, DBWn, ARCH, and other background processes perform these I/O and monitoring functions.

Keep practicing — related questions