RelationalDBDesign
RelationalDBDesign
SiteMap
Extended DB Features
Oracle SQL Extensions
Auditing Features
«Prev
Extended Features
Partitioned Tables
Partitioning Advantages
Local Index Partition
Dropping Oracle Partitions
Drop Truncate Partitions
Clustering Tables
Clustered Tables Advantages
Oracle Hash Cluster
Creating Oracle Cluster
Size Cluster Properly
Oracle Clustering Advantages
Index Organized
Advantages Disadvantages
Export Table Data
Creating Table Index
Auditing Features
Enable Audit Feature
Purge Audit Trail
Language Support
National Character Set
Using Profiles
Auditing SQL statements - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of these statements about the number of audit records created is most accurate?
Please select the best answer.
A.
Using BY SESSION usually creates more audit records.
B.
Using BY ACCESS usually creates more audit records.
C.
Both types of auditing always create the same number of records.
D.
Using BY ACCESS always creates more audit records.
2.
Which statement is true about the type of events you can audit?
Please select the best answer.
A.
You can audit all events in a database.
B.
You can track only successful or unsuccessful SQL statements, not both.
C.
You can track successful, unsuccessful, or both types of SQL statements.
D.
You can track successful, unsuccessful, invalid, or all types of SQL statements.
3.
Which of these data dictionary views lists all available audit records for the current user?
Please select the best answer.
A.
USER_AUDIT_TRAIL
B.
USER_AUDIT_SESSION
C.
USER_AUDIT_STATEMENT
D.
USER_AUDIT_OBJECT
Score =
Correct answers:
Quiz Explanation