Question 1 of 30
A database administrator is tasked with granting a user the ability to select data from a specific table while ensuring that the user cannot grant this privilege to others. Which of the following actions should the administrator take to achieve this goal?
Grant the SELECT privilege on the table without the GRANT OPTION.
Grant the SELECT privilege on the table with the GRANT OPTION.
Create a role that includes the SELECT privilege and assign it to the user.
Grant the SELECT privilege on the table and also the EXECUTE privilege on a related procedure.

Preparing for Oracle Database Program with PL/SQL? 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