Pass with 1z1-116 Practice Materials 100% for sure

An audit administrator wants to log Client Context variables In the audit trail.
Examine this query and the output:

• A. AUDIT POLICY hr_emp_pol EXCEPT hr;
• B. AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id, current_user, db_name BY hr
• C. AUDIT POLICY hr_emp_pol BY hr;
• D. CREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;
• E. AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES current:_user( db_name BY hr;
• F. CREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;
• G. AUDIT CONTEXT NAMESPACE hr_Ct:x ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES ALL BY hr;

You must restrict execution of the alter system checkpoint command to certain conditions, specified in a rule set used by a command rule.
Which two parameters must be specified In the dbms_macadm.create_command_rule procedure to do this?

• A. CLAUSE_NAME=>'SYSTEM'
• B. OBJECT_NAME=>'CHECKPOINT'
• C. PARAMETER_NAM£=>'CHECKPOINT'
• D. OBJECT_OWNER=>'SYS
• E. COMMANI>=>' ALTER SYSTEM'
• F. CLAUSE_NAME=>'CHECKPOINT'
• G. COMMAND=>'ALTER'

Database Vault realm r protects all tables In the fin schema from DBA access User fin is configured as the owner in realm R.
You must also prevent access to realm r protected tables by user FIN. Which achieves this?

• A. Make realm R a mandatory realm.
• B. Remove the owner authorization of user fin in realm R.
• C. Revoke the select any table privilege from user FIN.
• D. Make user FIN participant In realm r. Instead of owner.

Which two represent the set of users that are never affected by connect command rules?

• A. SYS
• B. users with the DV_ADMIN role
• C. users with the DV_OWNER role
• D. SYSTEM
• E. users with the DV_ACCTMGR role

Oracle Database Vault is enabled In the database. You have these requirements:
1. Database administrator dbai must export and import data from and to a non-protected schema.
2. Database administrator dba2 must export and Import data from and to a protected schema.
Which three options together satisfy these requirements?

• A. Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.
• B. Grant become user to dbai.
• C. Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.
• D. Grant imp_full_database and exp_full_database to dbai and dba2.
• E. Grant sysoper to both users.
• F. Grant sysdba to both users.
• G. Grant become user to dba2.