Oracle
1Z0-116 · Question #31
1Z0-116 Question #31: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-116 to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.
Configuring and Auditing User Security
Question
Database user SCOTT requires the privilege to select from all tables and you decide to configure this using a global role. You have not yet configured the database with Enterprise User Security. You plan to perform these steps: 1. create role GLOBAI._ROI.E identified globally; 2. grant select any table to GLODAL_COLE; 3. grant GLOBAL_ROLE to SCOTT; What is the result?
Options
- AAll statements succeed even without Enterprise User Security configuration, but the role is not
- BThe third statement falls because global roles can be granted only by using a central authority.
- CThe second statement falls because granting a global role can be completed only by using a
- DThe first statement falls because the database Is not set up with Enterprise User Security.
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
#Global Roles#Enterprise User Security#Role Privileges#Database Authentication