Free 1Z0-116 Practice Test Questions and Answers (2026)

A. Grant become user to dbai.

B. Grant sysoper to both users.

C. Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.

D. Grant imp_full_database and exp_full_database to dbai and dba2.

E. Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.

F. Grant become user to dba2.

G. Grant sysdba to both users.

A. Data Redaction

B. Data Guard

C. Real Application Clusters

D. Transparent Data Encryption

E. Data Masking & Subsetting

F. Table Partitioning

G. Database Vault

H. GoldenGate

I. Oracle Sharding

J. Real Application Testing

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

B. AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES current:_user( db_name BY hr;

C. CREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;

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

E. AUDIT POLICY hr_emp_pol BY hr;

F. CREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;

G. AUDIT POLICY hr_emp_pol EXCEPT hr;