1Z0-883 Exam Questions

Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?

What are four capabilities of the mysql client program?

Consider the Mysql Enterprise Audit plugin. The following event detail is found in the audit log: <AUDIT_RECORD TIMESTAMP="2013-04-09t01:54:17" NAME="Connect" CONNECTION_ID="3" STA...

Consider the Mysql Enterprise Audit plugin. Which statement is true when you identify a connection event that has used external authentication?

You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-run...

Identify a performance impact when using the Performance Schema.

Which statement is true about FLUSH LOGS command?

Which two are correct steps in taking a binary backup of MyISAM tables?

You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. Some details are as fol...

Which two events will cause a slave server to create a new relay log file?

The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?

You want a record of all queries that are not using indexes. How would you achieve this?

The validate_password plugin is loaded and displays the following settings in global variables: Mysql> SHOW VARIABLES LIKE `validate_password%'; When attempting to set your passwor...

You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice: ERROR 2059 (HY000): Authentication plugin `mysql_clear_password' con...

The following commands are available in the Linux binary distributions of Mysql: - Mysqld - Mysqld_safe - Mysql.server What is the correct description of each of these commands?

Another user has issued LOCK TABLES pets READ You can...?

Which of the following statements are true for locks established by the InnoDB storage engine?

Which of the following is true for how the InnoDB storage engine uses diskspace?

Which of the following is true for the command-line programs mysqlcheck and myisamchk?

Which three statements describe how the strict SQL mode provides added security?

You are investigating the performance of the server and see the following information: - Events_waits_summary_global_by_event_name in the performance schema shows that the wait/syn...

Which statement is true about the log-output variable?

The `allplicationdb' is using innoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored. You investigate and...

What is true regarding InnoDB locking?

Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin `audit_log' init function returned er...

A general purpose MySQL instance is configured with the following options: -- log-slow-queries -- long-query-time=,0001 -- log-slow-admin-queries -- general-log -- log-bin -- binlo...

Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?

A MySQL replication slave is set up as follows: - User all InnoDB tables - Receives ROW-based binary logs - Has the read-only option The replication slave has been found in an erro...

Which two statements describe the behavior of the server's SQL mode?

Which two options describe how MySQL Server allocates memory?

MySQL is installed on a Linux server and has the following configuration: [mysqld] User=mysql Datadir=/data/mysql As the `root' user, change the datadir location by executing: Shel...

You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW bac...

A user executes the statement; PURGE BINARY LOGS TO `mysql-bin.010'; What is the result?

You have table `apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following comman...

Which two capabilities are granted with the SUPER privilege?

You use--login-path to access a MySQL server on a Linux installation. Which statement is true about the login-path option that is created by using mysql_config_editor?

Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attem...

Which three methods will show the storage engine for the Country table?

You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?

You are attempting to secure a MySQL server by using SSL encryption. On starting MySQL, you get this error: 130123 10:38:02 [ERROR] mysqld: unknown option `--ssl' What is the cause...

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?

Which three are properties of the MyISAM storage engine?

Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions...

An employee cannot access the company database. You check the connection variables: Mysql> SHOW GLOBAL VARIABLES LIKE `%connect%'; 8 rows in set (0.00 sec) A look at the user privi...

Consider the following: Mysql> EXPLAIN SELECT * FROM City WHERE Name = `Jacksonville' AND CountryCode = `USA' \G ******************************** 1. row ***************************...

Which three statements are true about memory buffer allocation by a MySQL Server?

Which three tasks can be performed by using the performance Schema?

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a...

You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to incl...

Which three data components are needed for point-in-time recovery?