A.14. Chapter 14

  1. System trace files can be found in the directory identified by which initialization parameter?

    Answer: System trace files can be found in the directory identified by the BACKGROUND_DUMP_DEST parameter.

  2. What Oracle tool can the DBA use to monitor the size of a tablespace and notify the DBA when the tablespace is running out of space?

    Answer: Oracle9i's OEM's Event Manager tool or Oracle 10g's EM Database Control can be used to monitor space conditions in database tablespaces.

  3. True or false: The alert log file records both successful and unsuccessful logins to the database.

    Answer: False, the alert log file records database startup and shutdown but not user logins.

  4. The alert log file can be found in the directory identified by which ...

Get Oracle Database Foundations 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.

Start your free trial