Question 1 of 30
A database administrator is tasked with configuring user access for a new application that requires specific privileges to certain tables while ensuring that users cannot access other sensitive data. The administrator decides to create a role that encapsulates the necessary privileges and assigns this role to the users. What is the primary benefit of using a role in this scenario?
It simplifies the management of user privileges by allowing multiple users to share the same set of permissions.
It ensures that all users have unrestricted access to the database, enhancing collaboration.
It allows for the automatic revocation of privileges when a user leaves the organization.
It provides a way to enforce complex password policies for all users in the database.

Preparing for Oracle Database 23ai Administration Associate? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free