Oracle
1Z0-888 · Question #82
1Z0-888 Question #82: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.
Backup and Recovery
Question
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-option-transaction Which extra GRANT permissions are required for adam to take mysqldump backups?Options
- AThe
adamuser must also have SINGLE TRANSACTION global grant to take a consistent backup. - BThe
adamuser needs the PROCESS privilege to be able to take a consistent backup while other users are connected. - CThe
adamuser must have the SUPER privilege in order to take data backups. - DThe
adamuser must also have SELECT on the football database for backups to work.
Unlock 1Z0-888 to see the answer
You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#MySQL privileges#mysqldump backups#InnoDB transactions#SUPER privilege