Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

19 Cards in this Set

  • Front
  • Back
  • 3rd side (hint)
The NT Performance Monitor is very good for viewing which kind of information?
i/o and cpu info
You can gather a tremendous amount of information about the Oracle processes by querying the internal performance tables using the
V$ views
Contains information about virtual connections that are created through the dispatcher and server processes
Contains miscellaneous system statistics
Contains information about multithreaded message lines
What is the name of the V$ view that contains I/O information for each session?
To enable the audit trail, first you must run the administration SQL script
This script is located in the directory Orant\\Rdbms80\\Admin
When you are done auditing and want to remove the audit trail views when they are no longer needed, use the administrative SQL script
What command is used to turn off auditing on a specified function or user?
With the audit command there are certain keywords, that are used to indicate auditing of associated SQL statements. these are called?
statement options
Which parameter in the AUDIT statement causes an audit record to be written for each SQL statement issued?
by access
What is the parameter to use when you want an audit record to be written only when the SQL statement is successful?
whenever successful
This parameter specifies the type of operation that is audited.
What is the object option you can use in the AUDIT objects statement that specifies that all operations are to be audited?
Which ON parameter specifies that objects that have not been created yet will be audited with the same auditing options as other objects?
on default
Which system privilege should be limited to DBAs only, to keep others from deleting the audit trail?
delete any tablespace
Audit entries for CONNECT and DISCONNECT operations
Audit all audit trail entries
The audit trail concerning GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM commands