Oracle Database 12c: Installation and Administration — Question 157

Which three are true about server processes for dedicated server connections? (Choose three.)

Answer options

• A. They can write and read consistent block images to Oracle data files.
• B. They can parse and execute SQL statements.
• C. They can read data blocks from data files into the default buffer cache.
• D. They can generate archive log entries.
• E. They can generate redo log entries.
• F. They can write current block images contained in clean buffers to Oracle data files.

Correct answer: A, B, C

Explanation

Options A, B, and C are correct because dedicated server processes handle tasks like reading/writing block images, parsing, and executing SQL statements, and managing data blocks in the buffer cache. Options D, E, and F are incorrect as they pertain to functions not specifically related to the dedicated server processes' primary responsibilities.