Oracle Database Vault is enabled In the database.

Oracle 1z0-116 Question Answer

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?

Grant become user to dbai.

Grant sysoper to both users.

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

Grant imp_full_database and exp_full_database to dbai and dba2.

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

Grant become user to dba2.

Grant sysdba to both users.

Oracle 1z0-116 Summary

Price: $52.5 ~~$149.99~~