1Z0-888 Exam Questions

You have just executed a manual backup by using this command: mysqldump -u root -P --socket=/tmp/my.sock --backup-dir=/my/backup/ backup The operation completed without error. What...

Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

Consider: mysql> EXPLAIN SELECT * FROM City WHERE Name = 'Jacksonville' AND CountryCode = 'USA'\G *************************** 1. row *************************** id: 1 select_type:...

Examine the mydata table and SELECT statements: CREATE TABLE `mydata` ( `id` int (11) NOT NULL AUTO_INCREMENT, `a` int (11) DEFAULT NULL, `b` int (11) DEFAULT NULL, PRIMARY KEY (`i...

A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limitin...

Exhibit: mysql> EXPLAIN SELECT * FROM City Where CountryCode = 'USA'\G ***************************1.row*************************** id: 1 select_type: SIMPLE table: City type: ALL p...

Is it true that binary backups always take less space than text backups?

You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size. You start to restore your backup with this command: shell> mysql -u root -P < backup...

Which two options describe how MySQL Server allocates memory?

Which three are key advantages of standard MySQL replication?

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is: CREATE TABLE transactions ( User VARCHAR (255) NOT NULL, Amount DECIMA...

A database database, 'db_prod', just disappeared from your production MySQL instance. In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level...

Which three statements correctly describe MySQL InnoDB Cluster?

Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations. Which two other steps can...

Consider these global status variables: mysql> SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE '%connection%' OR VARIABLE_NAME LIKE '%thread%'; +-----------...

You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema. - Total dataset size is 200G with an average schema size of 2G. - The data is transient...

You have the following in my.cnf configuration file: [mysqld] default_authentication_plugin=sha256_password You want to create a new user who will be connecting from the IP address...

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact t...

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 accessi...

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. T...

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output: Last_SQL_Error: Error 'Duplicat entry '8' for key 'PR...

After rebooting the host, you attempt to start the mysqld service. You get the following error: Can't start server: Bind on TCP/IP port: Address already in use What is the most lik...

You enable binary logging on MySQL Server with the configuration: binlog-format=STATEMENT log-bin Which database updates are logged on the master server to the binary log by defaul...

What two statements are true regarding FLUSH TABLES FOR EXPORT?

Examine the mysqldumpslow output: Count: 109 Time=66.73s (6183s) Lock-0.00s (0s) Rows=3990419.2 (434955691), appuser[appuser]@localhost SELECT id, firstname, surname, address, age,...

Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoi...

Which statement best describes the purpose of the InnoDB buffer pool?

One of your colleagues is trying to make a change using the mysql command-line client for his or her application session: mysql> SET SESSION max_connections = 200; Why does the com...

MYSQL is installed on a Linux server and has this configuration: [mysqld] user=mysql datadir=/data/mysql/ As the 'root' user, you change the datadir location by executing: shell> c...

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

What is the best method for monitoring Group Replication conflict resolution?

To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509. Which additional task needs to be performed for those user accounts to fu...

You created a backup of the world database with this command: `shell> mysqldump --opt world > dump.sql` Which two will import the data from dump.sql?

How does the InnoDB storage engine handle deadlocks when they are detected?

Which two statements describe how InnoDB recovery works?

The query is not using an index. Which two methods can be used to allow the query to use an index?

Consider this statement on a RANGE-partitioned table: `mysql> ALTER TABLE orders DROP PARTITION p1, p3;` What is the outcome of executing this statement?

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

Consider the join_buffer_size parameter in MySQL Server. Which two statements are true about the join buffer?

A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to re...

The following grants were executed: `GRANT CREATE ROUTING ON sales.* TO 'webadmin'@'%';` `GRANT ALTER ON PROCEDURE sales.myproc TO 'webadmin'@'%';` A user successfully connects to...

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the reverts takes too long. The DBA w...

The MySQL error log shows: InnoDB: Warning: a long semaphore wait The relevant parts of the InnoDB monitor output shows: ---Thread 140259946129152 has waited at btr0sea.cc line 658...

Which two statements are true regarding the creating of new MySQL physical and logical backups?

You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE. mysql> SELECT THREAD_ID, th...

There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqldump command. The /etc/my.cnf contains default values, for example, datadir=/va...

You have created a new user with this statement: `CREATE USER 'erika'@'localhost' IDENTIFIED BY 'first#1Pass' PASSWORD EXPIRE;` What is the outcome?

An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user's shel...

Consider the CHECK TABLE command. In which two situations should this command be used? (Choose two.)

You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary l...