Which two methods allow a DBA to reset a user's password? (Choose two.)

• A. mysqladmin client program
• B. ALTER USER statement
• C. mysql_secure_installation utility
• D. SET PASSWORD statement
• E. GRANT statement

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?

• A. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
• B. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
• C. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
• D. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql

You want to dump all databases with names that start with "db".
Which command will achieve this?

• A. mysqlpump --include-databases=db% --result-file=all_db_backup.sql
• B. mysqlpump > all_db_backup.sql
• C. mysqlpump --include-databases=db --result-file=all_db_backup.sql
• D. mysqlpump --include-tables=db.% --result-file=all_db_backup.sql

MySQL programs look for option files in standard locations.
Which method will show the option files and the order in which they are read?

• A. mysql> SHOW GLOBAL VARIABLES;
• B. shell> mysqladmin --debug
• C. shell> mysqld --help --verbose
• D. shell> mysql --print-defaults

Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)

• A. All databases are backed up to the output file.
• B. All binary logs are backed up and then deleted.
• C. All databases, excluding master metadata, are backed up to the output file.
• D. All binary logs are deleted from the master.
• E. All details regarding deleted logs and master metadata are captured in the output file.
• F. All non-active binary logs are removed from the master.