User psmith Is connecting outside of the SYSDATE specified.

The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.

user psmith is connecting remotely.

The HR_ADMIN role must be granted to user PSMITH.

The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.

The HR.ROLE_CHECK procedure must be created without the AUTHID clause.

You treated an access control list that references a non-existent policy.

You created an access control list that references a non-existent realm.

You created a policy that references a non-existent access control list.

You created a realm and an access control list that reference a non-existent policy.

You created a policy that references a non-existent realm.

You created a realm that references a non-existent policy.

The client Identifier is automatically included In the audit trail.

The client Identifier is automatically set by the SQL-Net layer.

A session can have multiple client Identifier values set simultaneously.

The client Identifier cannot be changed during the session.

AUDIT CONTEXT NAMESPACE hr_Ct:x ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES ALL BY hr;

AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES

current:_user( db_name BY hr;

CREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;

AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id, current_user, db_name BY hr

AUDIT POLICY hr_emp_pol BY hr;

CREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;

AUDIT POLICY hr_emp_pol EXCEPT hr;

Option A

Option B

Option C

Option D

Option E

ALTER DATABASE DICTIONARY REKEY CREDENTIALS;

SELECT * FROM DBA_OBJECTS;

SELECT * FROM DBA_TABLESPACES WHERE ENCRYPTED = ' YES*;

ADMINISTER KEY MANAGEMENT SET KFYSTOBF OPEN IDENTIFIED BY password:

ALTER SYSTEM FLUSH PASSWORDFILE_METADATA_CACHE;

ALTER TABLESPACE APPDATA ENCRYPTION OFFLINE ENCRYPT;

You do not have select privileges on this database view.

The master key has been corrupted.

The key store is not open.

The master key has not been created.

This is expected behavior for this view.

setting the SQL92_SECURITy initialization parameter to false

enabling salt tor an encrypted column

creating a procedure that defines the VPD restrictions in a VPD policy

collecting sensitive data Information with Database Security Assessment Tool (DBSAT)

enforcing row-level security at the table level

enforcing row-level security at the database level

Add or remove realm-protected objects to or from the reaim.

Grant or revoke privileges on realm-protected objects to or from other users.

Add or remove realm-secured database roles to or from the realm.

Grant or revoke system privileges to access objects protected by the realm.

Add or remove participants to or from the realm.

Add or remove owners to or from the realm.

Grant or revoke realm-secured database roles.

It runs only on UNIX/Linux systems.

It must connect to the database using a SYSDBA connection.

It must be run by an OS user with read permissions on files and directories under ORACLE_HOME.

It runs only on Windows systems.

It must be run on the server that contains the database.