Oracle9i DBA JumpStart

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?

1.

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

2.

OEM’s Event Manager tool can be used to monitor space conditions in database tablespaces.

3.

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 the BACKGROUND_DUMP_DEST parameter.

5.

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