Oracle Exam 1Z0-888 Topic 3 Question 82 Discussion

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

Question #: 82
Topic #: 3

The MySQL user 'adam' currently has USAGE permissions to the database.

The football database is transactional and has non-stop updates from application users. The 'adam' user needs to be able to take consistent backups of the football database by using the ---single-transaction option.

Which extra GRANT permissions are required for adam to take mysqldump backups?

AThe 'adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.

BThe 'adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.

CThe 'adam' user must have the SUPER privilege in order to take data backups.

DThe 'adam' user must also have SELECT on the football database for backup to work.

Show Suggested Answer

Suggested Answer: C

by Brock at Dec 10, 2023, 05:40 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!