Oracle
1Z0-116 · Question #61
1Z0-116 Question #61: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-116 to reveal the answer and full explanation for question #61. The question stem and answer options stay visible for context.
Configuring and Auditing User Security
Question
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?
Options
- 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.
Unlock 1Z0-116 to see the answer
You've previewed enough free 1Z0-116 questions. Unlock 1Z0-116 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Role-Based Authentication#Definer's Rights#DBMS_SESSION.SET_ROLE#Procedure Security Privileges