Oracle Exam 1Z0-116 Topic 10 Question 36 Discussion

Actual exam question for Oracle's 1Z0-116 exam

Question #: 36
Topic #: 10

[All 1Z0-116 Questions]

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?

AGrant become user to dbai.

BGrant sysoper to both users.

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

DGrant imp_full_database and exp_full_database to dbai and dba2.

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

FGrant become user to dba2.

GGrant sysdba to both users.

Show Suggested Answer

Suggested Answer: A

by Marge at Dec 10, 2023, 05:52 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-116 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Ardella

2 months ago

Wait, so we have two DBAs, one who can access the non-protected schema and the other who can access the protected schema? Sounds like a classic case of 'divide and conquer' to me!

upvoted 0 times

Elvis

9 days ago

D) Grant imp_full_database and exp_full_database to dbai and dba2.

upvoted 0 times

...

Shelba

13 days ago

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

upvoted 0 times

...

Bobbye

23 days ago

A) Grant become user to dbai.

upvoted 0 times

...

Yuki

2 months ago

D is an interesting option, but I'm not sure if that's the best approach. Granting full database import/export privileges might be overkill here.

upvoted 0 times

Alesia

23 days ago

D) Grant imp_full_database and exp_full_database to dbai and dba2.

upvoted 0 times

...

Tiera

1 months ago

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

upvoted 0 times

...

Cecilia

2 months ago

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

upvoted 0 times

...

Dell

2 months ago

A) Grant become user to dbai.

upvoted 0 times

...

Luisa

2 months ago

A and F are a bit strange. Why would we grant 'become user' to the admins? That's not really necessary for this use case.

upvoted 0 times

Geraldine

28 days ago

D) Grant imp_full_database and exp_full_database to dbai and dba2.

upvoted 0 times

...

Katina

29 days ago

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

upvoted 0 times

...

Jill

1 months ago

D) Grant imp_full_database and exp_full_database to dbai and dba2.

upvoted 0 times

...

Lisandra

2 months ago

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

upvoted 0 times

...

Renato

2 months ago

I think C and E are the correct answers. We need to authorize the Data Pump utilities for the specific users, not just grant them general privileges.

upvoted 0 times

...

Fernanda

2 months ago

B and G are definitely not the right options here. You can't just grant sysoper or sysdba to users, that's way too much privilege for this scenario.

upvoted 0 times

...

Fidelia

2 months ago

I'm not sure about option C. I think we also need to consider granting imp_full_database and exp_full_database to dbai and dba2 as mentioned in option D.

upvoted 0 times

...

Rutha

3 months ago

I agree with Joaquin. Option C seems to be the most appropriate solution for the requirements given.

upvoted 0 times

...

Joaquin

3 months ago

I think option C is the right choice because it grants privileges to both dbai and dba2 for impdp and expdp utilities.

upvoted 0 times

...