1Z0-182 practice question 3 of 15
Which three tasks are performed by background processes in an Oracle database instance?
Full set: 94 questionsOracle background processes perform maintenance tasks for the database instance. The Listener Registration (LREG) process registers instance and service information with the listener. The Log Writer (LGWR) process is responsible for writing redo log entries from the redo log buffer to the online redo log files. The Database Writer (DBWn) process writes modified (dirty) data blocks from the database buffer cache to the data files on disk. These are all fundamental background process tasks.
A. The Oracle Net Listener, a separate process, creates dedicated server processes in response to client connection requests.
E. Reading data blocks from disk into the buffer cache is performed by foreground server processes at the request of a user session.
1. Oracle Database Concepts 23ai, Chapter 7, "Processes". The section "Background Processes" provides a detailed list and description of mandatory and optional background processes.
2. Oracle Database Concepts 23ai, Chapter 7, "Processes". The description for "Listener Registration Process (LREG)" states it registers information with the listener.
3. Oracle Database Concepts 23ai, Chapter 7, "Processes". The description for "Log Writer Process (LGWR)" states it writes redo log entries to disk.
4. Oracle Database Concepts 23ai, Chapter 7, "Processes". The description for "Database Writer Process (DBWn)" states its primary purpose is to write modified blocks from the buffer cache to data files.
5. Oracle Database Concepts 23ai, Chapter 7, "Processes". The section "Server Processes" explains that these processes fulfill user requests, which includes reading data blocks from disk into the SGA.
Keep practicing
Take the free 1Z0-182 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-182 practice questions
- Question 1Which data dictionary view describes the data sources of external tables?
- Question 2You want to view the initialization parameter settings for only a specific PDB. Which of …
- Question 4Which statement is true about database links?
- Question 5Which three statements are true about the Oracle Database server during and immediately a…
- Question 6Which two methods can be used to purge audit records of the Unified Audits?
- Question 7What are Oracle Database Metrics?
