1Z0-006 Security Management 4

Question 1

Which Oracle feature encrypts entire tablespaces transparently without requiring application changes?

Accepted Answer

Oracle Advanced Security TDE (Transparent Data Encryption)

Answer

Transparent Data Encryption (TDE) encrypts data at rest at the tablespace or column level without requiring any modifications to existing applications.

Question 2

A DBA wants to prevent the SYS user from accessing sensitive payroll data in a specific schema. Which Oracle feature can enforce this restriction?

Accepted Answer

Oracle Database Vault

Answer

Oracle Database Vault creates realms that restrict even highly privileged users like SYS from accessing protected application data.

Question 3

What is the minimum number of characters Oracle enforces for passwords when using the default password complexity function?

Accepted Answer

8

Answer

Oracle's default password verification function (ora12c_strong_password_verify_function) requires a minimum of 8 characters.

Question 4

Which audit trail type stores Oracle audit records in database tables within the AUDSYS schema?

Accepted Answer

Unified Auditing Trail

Answer

Unified Auditing, introduced in Oracle 12c, writes all audit records to the UNIFIED_AUDIT_TRAIL view stored in the AUDSYS schema.

Question 5

Which type of Oracle role is automatically enabled when a user logs in, without needing SET ROLE?

Accepted Answer

Default role

Answer

Default roles are automatically activated at login, while non-default roles must be explicitly enabled during the session with SET ROLE.

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

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

1Z0-006 Security Management 4