Oracle Database 12c: Installation and Administration — Question 179

Which task is performed by a background process in a database instance?

Answer options

• A. Connecting between a client process and a dispatcher
• B. Executing PL/SQL code
• C. Creating dedicated server connections
• D. Copying online redo log files to offline storage

Correct answer: D

Explanation

The correct answer is D because background processes are responsible for managing the online redo log files and ensuring they are copied to offline storage for recovery purposes. Options A, B, and C involve tasks that are typically handled by foreground processes or client interactions, not background processes.