OCP Security and Auditing Flashcards
6 cards from real OCP practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 OCP Security and Auditing flashcards as text
Which Oracle auditing framework introduced in Oracle 12c consolidates all audit data into a single unified audit trail?
Answer: Unified Auditing
Unified Auditing, introduced in Oracle 12c, consolidates audit records from all sources into a single trail in the AUDSYS schema.
Which Oracle component creates 'realms' to prevent even privileged DBAs from accessing sensitive application data?
Answer: Oracle Database Vault
Oracle Database Vault uses realms and command rules to restrict privileged users, including DBAs, from accessing protected data.
What is the default profile automatically assigned to a new Oracle user if no profile is specified during creation?
Answer: DEFAULT
The DEFAULT profile is automatically assigned to all new Oracle users unless a specific profile is named in the CREATE USER statement.
Which data dictionary view shows the auditing options currently configured for individual database objects?
Answer: DBA_OBJ_AUDIT_OPTS
DBA_OBJ_AUDIT_OPTS displays the audit options set for every database object, showing which operations are audited.
What does Oracle Data Redaction do to sensitive data when a user queries a protected column?
Answer: Masks the value in query results without altering stored data
Oracle Data Redaction dynamically replaces sensitive column values in query output while leaving the actual stored data unchanged.
Which user profile parameter specifies the number of consecutive failed login attempts before an Oracle account is locked?
Answer: FAILED_LOGIN_ATTEMPTS
FAILED_LOGIN_ATTEMPTS in a user profile defines how many consecutive incorrect passwords trigger an automatic account lock.