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 views contain information about sessions in the database?

  10. Oracle Database 10g's EM Database Control can trigger an alert for out of space conditions at how many different threshold levels?

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset