RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Database Monitoring
«Prev
Next»
DBA Taks
Database Monitoring
Control File Parameters
Protecting Control Files
Removing Control File
Add Control File
Backingup Control File
Recreating Control Files
Checking Parameter Values
v Parameter Dynamic
Changing DB Parameters
Managing DB Parameters
Managing Redo Log
Protecting redoLog Files
Listing RedoLog Files
Create Redo Log Files
Dropping Redo Log Files
Moving Redo Log Files
Manually Switch Log Files
Managing RedoLog Conclusion
Redolog Files
Archivelog Mode
Archive Log Destination
Naming Archive Log Files
Manually Archiving Log File
Archive Log History
Archivelog Mode Conclusion
Manage Tablespace Files
Routine Monitoring on Oracle RDBMS - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
What are two things that you should monitor on a regular basis?
Please select
all the correct answers
.
A.
The buffer cache hit ratio
B.
The Oracle release number
C.
Disk space
D.
The location of the $ORACLE_HOME directory
2.
What are V$ views?
Please select
the best answer
.
A.
Data dictionary views that return information about objects in the database
B.
Dynamic performance views that return information about database operation
C.
Views created so users can have access to Oracle's data dictionary
D.
Views created so that database administrators can access remote databases
3.
Why is it important to monitor aspects of your database's operation routinely?
Please select
the best answer
.
A.
Routine monitoring enables you to produce statistical charts and graphs for use by management.
B.
Routine monitoring enables you to assess the need to create new database objects for use by users.
C.
Routine monitoring enables you to discover potential problems and prevent them from occurring.
D.
Routine monitoring enables you to determine the proper time to upgrade to the next Oracle release.