Oracle Exam 1Z0-915-1 Topic 3 Question 5 Discussion

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

Question #: 5
Topic #: 3

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 Judy at Aug 03, 2024, 07:58 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-915-1 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Sabina

9 months ago

I believe D is the best option because it grants all privileges.

upvoted 0 times

...

Myra

9 months ago

I'm not sure, but I think A could also work.

upvoted 0 times

...

Chauncey

9 months ago

I agree with Tonja, D seems like the right choice.

upvoted 0 times

...

Tonja

9 months ago

I think the correct statement is D.

upvoted 0 times

...

Mabelle

10 months ago

I believe D is the best choice because it grants all privileges to admin2.

upvoted 0 times

...

Chandra

10 months ago

I'm not sure, but I think A could also be a valid option.

upvoted 0 times

...

Emilio

10 months ago

I agree with Trinidad, D seems like the right choice.

upvoted 0 times

...

Trinidad

10 months ago

I think the correct statement is D.

upvoted 0 times

...

Gertude

10 months ago

I'm going with option D. Why make it complicated? If it ain't broke, don't fix it. Just give admin2 the whole enchilada and call it a day.

upvoted 0 times

Deeanna

9 months ago

Let's go with option D then. Admin2 gets all the privileges.

upvoted 0 times

...

Carman

9 months ago

I agree, no need to overcomplicate things. Option D is the easiest.

upvoted 0 times

...

Rima

9 months ago

Yeah, just give admin2 all the privileges and be done with it.

upvoted 0 times

...

Winifred

9 months ago

I think option D is the way to go. Keep it simple.

upvoted 0 times

...

Viola

10 months ago

Haha, option B is a classic. 'GRANT SUPER ON *.* TO admin2' - that's just asking for trouble! Might as well give them the keys to the kingdom.

upvoted 0 times

...

Martina

10 months ago

Hmm, option C looks interesting. Granting specific admin-level permissions like AUDIT_ADMIN and BACKUP_ADMIN might be a more secure approach than just giving them full access.

upvoted 0 times

Nickolas

10 months ago

Yeah, it's better to grant specific permissions rather than giving full access.

upvoted 0 times

...

Buffy

10 months ago

I think option C is the best choice. It grants specific admin-level permissions.

upvoted 0 times

...

Herman

11 months ago

I think option D is the way to go. Granting all privileges on all databases to the admin2 user is the easiest and most straightforward way to give them the same privileges as the administrator.

upvoted 0 times

Vesta

10 months ago

I think option D covers all the bases by granting all privileges, so admin2 will have the same level of access as the administrator.

upvoted 0 times

...

Fairy

10 months ago

But what about option B? It specifically grants SUPER privileges, which might be necessary for admin2.

upvoted 0 times

...

Raylene

10 months ago

I agree, option D seems like the most efficient choice.

upvoted 0 times

...