Oracle Exam 1Z0-116 Topic 5 Question 61 Discussion

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

Question #: 61
Topic #: 5

[All 1Z0-116 Questions]

Examine the statement:

CREATE BOLE hr_admin IDENTIFIED USING pac_mgr.hr_admin_rola_ch9ck;

Which three are true about the sec_mgr. hr_admin_role_check procedure?

AIt must use only one security check to validate the user.

BIt must use the invokcr's rights to enable the role,

CIt must use the deflner's rights to enable the role.

DIt can Include one or more security checks to validate the user.

EIt must contain a SET ROLE statement or a DBMS_SESSION.SET_ROLE call.

FIt can use only the DBMS_SESSION. SET_ROLE procedure.

GIts owner SEC_MGR must be granted the execute any procedure role.

Show Suggested Answer

Suggested Answer: B, C

by Cristal at Nov 17, 2024, 06:45 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Carissa

1 months ago

I'm feeling pretty confident about this one. D and E are definitely the correct answers. The procedure can use multiple security checks, and it must include a way to enable the role. As for the other options, they sound like something the Oracle security team came up with to confuse us. Time to crack open the database security manual again!

upvoted 0 times

Dallas

6 days ago

Yeah, I agree. The other options sound like distractions. We should definitely refer back to the manual for clarification.

upvoted 0 times

...

Eden

11 days ago

I think you're right, D and E seem to be the correct answers. It's important to have multiple security checks and enable the role.

upvoted 0 times

...

Lenita

1 months ago

Ah, the joys of Oracle security procedures. I wonder if the exam will also ask us to draw a diagram of the role hierarchy and recite the Oracle security prayer backwards. Just kidding, but seriously, D and E seem like the safest bet here.

upvoted 0 times

Christa

13 days ago

I agree, D and E seem like the most logical choices.

upvoted 0 times

...

Val

2 months ago

This question is a bit tricky, but I'm going to go with D and E. The procedure can use multiple checks, and it needs to enable the role somehow. As for the other options, I'm not so sure. Maybe the invoker's rights thing is a red herring?

upvoted 0 times

Ellsworth

14 days ago

Yeah, I'm leaning towards D and E as well. It just seems like the most practical approach for the sec_mgr.hr_admin_role_check procedure.

upvoted 0 times

...

Merilyn

18 days ago

I agree, D and E seem like the most logical choices. The invoker's rights might not be necessary for this particular procedure.

upvoted 0 times

...

Jeffrey

20 days ago

I think you're on the right track with D and E. It does make sense that the procedure can have multiple security checks and needs to set the role.

upvoted 0 times

...

Colette

2 months ago

I'm not sure about the correct answer, but I know that the procedure's owner, SEC_MGR, must have the EXECUTE ANY PROCEDURE role to make this work. Gotta love those Oracle security requirements!

upvoted 0 times

...

Melita

2 months ago

D and E seem to be the obvious choices here. The procedure can include multiple security checks, and it must use a SET ROLE statement or DBMS_SESSION.SET_ROLE to enable the role.

upvoted 0 times

...