Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle Exam 1Z0-116 Topic 4 Question 43 Discussion

Actual exam question for Oracle's 1Z0-116 exam
Question #: 43
Topic #: 4
[All 1Z0-116 Questions]

A DBA user created and configured this secure application role:

Why does the error occur?

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

Maxima
8 hours ago
I think it's B, the SET ROLE statement needs to be executed using the DBMS_SESSION.SET_ROLE procedure.
upvoted 0 times
...
Judy
17 days ago
I agree with Eric, the solution is to grant the HR_ADMIN role to user PSMITH.
upvoted 0 times
...
Sang
21 days ago
Option D looks promising, the HR_ADMIN role needs to be granted to user PSMITH for the application to work correctly.
upvoted 0 times
...
Eric
26 days ago
I believe the error is due to the HR_ADMIN role not being granted to user PSMITH.
upvoted 0 times
...
Gwen
28 days ago
I think the error occurs because user psmith is connecting outside of the SYSDATE specified.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77