Oracle Exam 1Z0-116 Topic 1 Question 47 Discussion

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

Question #: 47
Topic #: 1

Examine this configuration and requirement:

1. The hr user created a private database link in the pdb2 pluggable database linking to the hr schema

In the PDBl pluggable database.

2. Other users in pdb2 must query the remote HR.EMPLOYEES table In PDBI using this database link.

Which two operations together ensure that the database link provides access only to the HR.EMPLOYEES table in the PDBI pluggable database?

AOnly grant other users access to the HR.EMPLOYEES table In the pdb2 pluggable database.

BGrant other users access to the database link in the PDBI pluggable database.

CGrant access to the view of the remote HR.EMPLOYEES table In the PDB2 pluggable database.

DGrant other users access to the database link In the PDB2 pluggable database.

ECreate a view In the HR schema for the remote hr. employees table of the pdb2 pluggable database .

Show Suggested Answer

Suggested Answer: A, D

by Pearlene at Jun 01, 2024, 01:10 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Joaquin

16 days ago

I hope the exam doesn't have any questions about database administration. I'm more of a stand-up guy myself!

upvoted 0 times

...

Irene

17 days ago

This is a tricky one. Option B is also a valid answer, as granting access to the database link in PDB1 would allow users in PDB2 to access the remote HR.EMPLOYEES table.

upvoted 0 times

...

Felix

19 days ago

Hmm, I'm leaning towards option E. Creating a view in the HR schema for the remote HR.EMPLOYEES table in PDB2 seems like a more secure way to control access to the specific table.

upvoted 0 times

Casie

1 days ago

I agree, creating a view in the HR schema for the remote table seems like the way to go. It ensures access is controlled.

upvoted 0 times

...

Jani

2 days ago

Yeah, option E seems like the most secure option. It restricts access to just the HR.EMPLOYEES table in PDB2.

upvoted 0 times

...

Therese

3 days ago

Creating a view in the HR schema sounds like a good idea. It limits access to only the specific table.

upvoted 0 times

...

Joesph

6 days ago

I think option E is the best choice. It provides a more secure way to control access to the HR.EMPLOYEES table in PDB2.

upvoted 0 times

...

Chantay

28 days ago

I'm not sure about that. Wouldn't option D also work? Granting access to the database link in PDB2 would allow users to access the remote HR.EMPLOYEES table, but not the entire PDB1 database.

upvoted 0 times

Kassandra

4 days ago

Option D would work as well. Granting access to the database link in PDB2 restricts access to only the HR.EMPLOYEES table in PDB1.

upvoted 0 times

...

Merilyn

19 days ago

Yes, that's correct. Granting access to the database link in PDB2 ensures users can only query the HR.EMPLOYEES table in PDB1.

upvoted 0 times

...

Arlyne

22 days ago

Option D would work as well. Granting access to the database link in PDB2 limits access to just the HR.EMPLOYEES table in PDB1.

upvoted 0 times

...

Jeannetta

2 months ago

Option C seems to be the correct answer. Granting access to a view of the remote HR.EMPLOYEES table in PDB2 will ensure that only that specific table is accessible, and not the entire database link.

upvoted 0 times