1Z0-006 Database Administration & Security 5

Question 1

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

Accepted Answer

Virtual Private Database (VPD)

Answer

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?

Accepted Answer

Retains dropped tables and their objects so they can be recovered with FLASHBACK TABLE

Answer

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?

Accepted Answer

PMON

Answer

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?

Accepted Answer

PASSWORD_REUSE_MAX

Answer

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?

Accepted Answer

Providing high availability through a synchronized standby database

Answer

Oracle Data Guard maintains a synchronized standby database that can take over if the primary database fails, providing disaster recovery and high availability.

(1Z0-006) Oracle Database Foundations Associate Practice Test

(1Z0-006) Oracle Database Foundations Associate Practice Test

1Z0-006 Database Administration & Security 5