READ Free Dumps For Oracle- 1z0-023
Question ID 8779 | What are two components of Oracle instance? (Choose two)
|
Option A | The SGA
|
Option B | The redo logs
|
Option C | The control cache
|
Option D | The password file
|
Option E | The PMON process
|
Correct Answer | AE |
Explanation Explanation/Reference: Explanation: Answers A and E are correct. The SGA and PMON process are components of Oracle instance. Incorrect Answers: B: The redo logs files are not a part of Oracle instance. C: The control cache does not exist in Oracle. D: The password file is external file, it is not a part of Oracle instance. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 256-259 Chapter 6: basics of the Oracle Database Architecture
Question ID 8780 | Which two main processes are involved when a user starts a new session on the database server? (Choose two)
|
Option A | The user process.
|
Option B | The Oracle login process.
|
Option C | The Oracle server process.
|
Option D | The system monitor (SMON) process.
|
Option E | The process monitor (PMON) process.
|
Correct Answer | AC |
Explanation Explanation/Reference: Explanation: Answers A and C are correct. When user starts a new session on the database server the user and the server process are involved. Server process acts on the user's behalf to pull Oracle data from disk into the buffer cache, where the user can manipulate it. There are two ways DBAs can set up Oracle to run server process: shared servers and dedicated servers. Incorrect Answers: B: There is no Oracle login process in Oracle. D: The system monitor process (SMON) is used to handle instance recovery after database startup if necessary and to coalescing free space within tablespace into contiguous segments. E: The system monitor process (PMON) is used to clean up messes left by dedicated servers with no user sessions attached to them - it rolls back changes and silently kills the dedicated server in order to release its memory and CPU usage. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 256-259 Chapter 6: Basics of the Oracle Database Architecture