Oracle 1Z0-915-1 Exam - Topic 1 Question 38 Discussion

Actual exam question for Oracle's 1Z0-915-1 exam

Question #: 38
Topic #: 1

You want to create a second user called admin2 with the same privileges as the administrator specified when creating the DB system.

Which statement helps you achieve this?

ACREATE USER admin2 IDENTIFIED BY 'Password' DEFAULT ROLE 'administrator';

BCREATE USER admin2 IDENTIFIED BY 'Password'; GRANT SUPER ON *.* TO admin2 WITH GRANT OPTION;

CCREATE USER admin2 IDENTIFIED BY 'Password'; GRANT AUDIT_ADMIN, BACKUP_ADMIN, SESSION_VARIABLES_ADMIN ON *.* TO admin2 WITH GRANT OPTION;

DCREATE USER admin2 IDENTIFIED BY 'Password'; GRANT ALL PRIVILEGES ON *.* TO admin2 WITH GRANT OPTION;

Show Suggested Answer

Suggested Answer: D

by Willard at May 11, 2026, 07:29 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

4 days ago

I think option D might be the right choice since it grants all privileges, which sounds like what an admin would need.

upvoted 0 times

...