READ Free Dumps For Oracle- 1z0-023
| Question ID 8904 | Which two main processes are involved when a user starts a new session on the database server in a dedicated environment? (Choose two)
|
| Option A | The user process.
|
| Option B | The Oracle server process.
|
| Option C | The Oracle shared-server process.
|
| Option D | The database writer (DBW0) process.
|
| Option E | The process monitor (PMON) process.
|
| Correct Answer | AB |
Explanation Explanation/Reference: Explanation: Answers A and B are correct. When the user starts a new session on the database server in a dedicated environment the user process and the Oracle server process are involved. Incorrect Answers: C: There is no Oracle shared-server process in a dedicated environment. D: The database writer (DBW0) has nothing to do with new session, it just writes data blocks from buffer cache to datafiles. E: The process monitor (PMON) process is designed to clean up messes left by dedicated servers with no user sessions attached to them. It does not work directly with new user processes. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 257-261 Chapter 6: Basics of the Oracle Database Architeture
| Question ID 8905 | Which are two components of an Oracle database? (Choose two)
|
| Option A | The SGA
|
| Option B | The redo logs
|
| Option C | The data files
|
| Option D | The large pool
|
| Option E | The DBW0 process
|
| Correct Answer | BC |
Explanation Explanation/Reference: Explanation: Answers B and C are correct. The redo logs and the data files are components of an Oracle database. Incorrect Answers: A: The SGA is an Oracle instance memory structure. D: The large pool is optional Oracle instance memory structure. E: The DBW0 process is Oracle instance process, not part of an Oracle database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 257-261 Chapter 6: Basics of the Oracle Database Architeture