Database Administration & Security Flashcards

Which Oracle feature provides row-level security by automatically appending a WHERE clause to queries on a table?

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.

What is the purpose of the Oracle recycle bin?

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.

Which background process cleans up resources of failed user processes in Oracle?

Answer: PMON

PMON (Process Monitor) detects failed user processes and releases their locks, resources, and rolls back their uncommitted transactions.

A DBA wants to prevent users from using passwords from their last 5 password changes. Which profile parameter enforces this?

Answer: PASSWORD_REUSE_MAX

PASSWORD_REUSE_MAX specifies the number of password changes required before an old password can be reused.

What is the primary purpose of Oracle Data Guard?

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.

Which Oracle command immediately terminates a user's session?

Answer: ALTER SYSTEM KILL SESSION

ALTER SYSTEM KILL SESSION with the session ID and serial number terminates a user's database session immediately.

What does the NOAUDIT statement do in Oracle?

Answer: Disables previously enabled auditing options

NOAUDIT disables auditing options that were previously enabled with the AUDIT statement.