1Z0-006 Security Management 2

Question 1

Which Oracle feature allows you to restrict the rows a user can see in a table based on a policy function?

Accepted Answer

Virtual Private Database (VPD)

Answer

Virtual Private Database (VPD) attaches security policies to tables so that queries are automatically modified to filter rows based on the policy function's return value.

Question 2

What is the purpose of the Oracle AUDIT statement?

Accepted Answer

To track and record database activity for security analysis

Answer

The AUDIT statement enables auditing of specific SQL statements, schema objects, or privileges so the database records who did what and when.

Question 3

Which data dictionary view lists all database users and their account status?

Accepted Answer

DBA_USERS

Answer

DBA_USERS contains one row per database user and includes columns such as USERNAME, ACCOUNT_STATUS, and EXPIRY_DATE.

Question 4

A user needs to read data from a table in another schema but should not be able to modify it. Which privilege should be granted?

Accepted Answer

SELECT on the table

Answer

Granting SELECT on a table allows the user to query rows without the ability to insert, update, or delete data.

Question 5

What happens to a user's session when their account is LOCKED?

Accepted Answer

Existing sessions continue but new logins are denied

Answer

Locking an account prevents new logins but does not kill already-connected sessions; those sessions remain active until they disconnect.

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

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

1Z0-006 Security Management 2