Exam Prep Questions

1:Which statement about an Oracle instance is true?
  • A. The data dictionary cache is not part of the shared memory area of an Oracle instance.

  • B. Multiple instances and therefore multiple databases can execute on the same computer.

  • C. The Oracle Server is a combination of memory structures, background processes, and external files.

  • D. Database writer writes the redo logs from the redo log buffer to the redo log files.

A1: Answer B is correct. It is possible, and often the case, to have multiple instances running on a single computer, each accessing its own physical database. Answer A is incorrect because the data dictionary cache is part of the shared memory area, or the SGA, of an Oracle instance. Answer C is incorrect because ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.