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.

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.

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.

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

Answer: The alert log file can be found in the directory identified by the BACKGROUND_DUMP_DEST parameter.

What does the Oracle utility TKPROF do?

Answer: The Oracle utility TKPROF formats a user trace file containing SQL statement statistics into a readable format.

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

Answer: User trace files can be found in the directory identified by the USER_DUMP_DEST parameter.

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

Answer: User trace files provide information about error conditions encountered in a user's session in addition to SQL statement execution statistics.

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

Answer: False, the alert log file grows in size indefinitely until it is renamed or deleted by the DBA.

Which two dynamic performance views contain information about sessions in the database?

Answer: The dynamic performance views V$SESSION and V$PROCESS contain information about user sessions.

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

Answer: Oracle Database 10g triggers alerts for all database error conditions, including out of space conditions, at two threshold levels: warning and critical.