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

Contribute your Thoughts:

Submit Cancel

19 days ago

Hmm, you might be right. I'll have to review that part again.

upvoted 0 times

...

22 days ago

I disagree, I believe the answer is E because it must contain a SET ROLE statement.

upvoted 0 times

...

25 days ago

I think the answer is D, because it says it can include one or more security checks.

upvoted 0 times

...