Databases Reference
In-Depth Information
Review Questions
1.
System trace files can be found in the directory identified by which initializa-
tion 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 initializa-
tion 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 10
g
's EM Database Control can trigger an alert for out of
space conditions at how many different threshold levels?
