1Z0-006 Database Administration & Security 5 — Questions and Answers
Question 1: Which Oracle feature provides row-level security by automatically appending a WHERE clause to queries on a table?
- Fine-Grained Auditing (FGA)
- Virtual Private Database (VPD) (Correct answer)
- Label Security
- Database Vault
Correct answer: Virtual Private Database (VPD)
Virtual Private Database (VPD) uses security policies to dynamically add WHERE predicates to SQL statements, enforcing row-level access control.
Question 2: What is the purpose of the Oracle recycle bin?
- Stores deleted redo log segments
- Retains dropped tables and their objects so they can be recovered with FLASHBACK TABLE (Correct answer)
- Archives expired audit records
- Holds temporary segments for large sort operations
Correct answer: Retains dropped tables and their objects so they can be recovered with FLASHBACK TABLE
The recycle bin holds dropped tables and dependent objects until the space is needed or the objects are explicitly purged.
Question 3: Which background process cleans up resources of failed user processes in Oracle?
- SMON
- DBWR
- PMON (Correct answer)
- LGWR
Correct answer: PMON
PMON (Process Monitor) detects failed user processes and releases their locks, resources, and rolls back their uncommitted transactions.
Question 4: A DBA wants to prevent users from using passwords from their last 5 password changes. Which profile parameter enforces this?
- PASSWORD_LIFE_TIME
- PASSWORD_REUSE_MAX (Correct answer)
- PASSWORD_REUSE_TIME
- PASSWORD_VERIFY_FUNCTION
Correct answer: PASSWORD_REUSE_MAX
PASSWORD_REUSE_MAX specifies the number of password changes required before an old password can be reused.
Question 5: What is the primary purpose of Oracle Data Guard?
- Encrypting sensitive column data at rest
- Providing high availability through a synchronized standby database (Correct answer)
- Scanning for SQL injection vulnerabilities
- Automatically partitioning large tables
Correct answer: Providing high availability through a synchronized standby database
Oracle Data Guard maintains a synchronized standby database that can take over if the primary database fails, providing disaster recovery and high availability.
Question 6: Which Oracle command immediately terminates a user's session?
- DROP SESSION
- KILL SESSION
- ALTER SYSTEM KILL SESSION (Correct answer)
- DISCONNECT SESSION
Correct answer: ALTER SYSTEM KILL SESSION
ALTER SYSTEM KILL SESSION with the session ID and serial number terminates a user's database session immediately.
Question 7: What does the NOAUDIT statement do in Oracle?
- Clears the audit trail tables
- Disables previously enabled auditing options (Correct answer)
- Exports audit records to an external file
- Encrypts the audit trail
Correct answer: Disables previously enabled auditing options
NOAUDIT disables auditing options that were previously enabled with the AUDIT statement.
1Z0-006 Database Administration & Security 5
Which Oracle feature provides row-level security by automatically appending a WHERE clause to queries on a table?