Online Access Free 1Z0-888 Practice Test

The MySQL instance is a default RPM installation on a Linux server.
Where are the errors written?

• A.in the /var/log/mysqld.err file
• B.in the syslog daemon on the server
• C.no logging enabled by default
• D.in the /var/lib/mysql/hostname.log file

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?

• A.The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.
• B.The `adam' user must also have SELECT on the football database for backups to work.
• C.The `adam' user must have the SUPER privilege in order to take data backups.
• D.The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.

When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

• A.it contains the binary log.
• B.it contains the undo log.
• C.it contains the redo log.
• D.it contains a general tablespace.
• E.it is the default location for all new tables that you create.
• F.it contains the system tablespace.

The /myfolder/my.cnf file has option set:
[mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?

• A.MySQL starts but Binary Logging is disabled.
• B.MySQL starts and Binary Logging is enabled.
• C.MySQL fails to start due to conflicting options on the command line.
• D.MySQL fails to start due to the conflicting options in the configuration files.

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

• A.enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
• B.The sync_relay_log=1000 setting on the slave is too small.
• C.binlog_cache_size=1024 is too small and transactions are lost.
• D.binlog_format=STATEMENT and a non-deterministic query was executed.
• E.sync_binlog=0 and the master server crashed.