1Z0-006 Database Administration and Security 4

Question 1

Which Oracle security feature allows row-level access control based on security policies?

Accepted Answer

Oracle Label Security / Virtual Private Database (VPD)

Answer

Virtual Private Database (VPD) / Oracle Label Security enables fine-grained access control by automatically appending WHERE clauses to queries based on security policies.

Question 2

What is Transparent Data Encryption (TDE) in Oracle used for?

Accepted Answer

Encrypting data stored in data files and backups without application changes

Answer

TDE encrypts data at rest in data files and tablespaces, protecting against physical theft of storage media without requiring any application changes.

Question 3

Which command would a DBA use to change a user's password in Oracle?

Accepted Answer

ALTER USER username IDENTIFIED BY new_password

Answer

The ALTER USER ... IDENTIFIED BY statement is the correct SQL syntax to change a user's password in Oracle.

Question 4

What is the purpose of an Oracle PROFILE?

Accepted Answer

To define a set of resource limits and password policies assigned to database users

Answer

An Oracle PROFILE is a named set of limits on database resources (CPU, sessions, etc.) and password settings that can be assigned to users.

Question 5

In Oracle, what is the difference between a system privilege and an object privilege?

Accepted Answer

System privileges allow performing actions on the database; object privileges allow actions on specific schema objects

Answer

System privileges (like CREATE TABLE) allow a user to perform database-wide actions, while object privileges (like SELECT on a specific table) control access to individual schema objects.

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

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

1Z0-006 Database Administration and Security 4