14.6. Review Questions

  1. System trace files can be found in the directory identified by which initialization 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?

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

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

  5. What does the Oracle utility TKPROF do?

  6. User trace files can be found in the directory identified by which initialization parameter?

  7. User trace files provide which two benefits for the DBA and database users?

  8. True or false: The alert log file is cleared every time the database is started.

  9. Which two dynamic performance ...

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