1Z0-883 Exam Questions

While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the numbe...

Which two are true regarding MySQL binary and text backups?

A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output: Last_SQL_Error: Error 'Duplicate entry '8' f...

Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?

You inherit a legacy database system when the previous DBA, Bob, leaves the company. You are notified that users are getting the following error: mysql> CALL film_in_stock (40, 2,...

When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_r...

Mysqldump was used to create a single schema backup; Shell> mysqldump u root p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with...

Consider the Mysql Enterprise Audit plugin. You are checking user accounts and attempt the following query: Mysql> SELECT user, host, plugin FROM mysql.users; ERROR 1146 (42S02): T...

Which query would you use to find connections that are in the same state for longer than 180 seconds?

A database exists as a read-intensive server that is operating with query_cachek_type = DEMAND. The database is refreshed periodically, but the resultset size of the queries does n...

You have a login-path named "adamlocal" that was created by using the mysql_config_editor command. You need to check what is defined for this login_path to ensure that it is correc...

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

Which two statements are true about InnoDB auto-increment locking?

Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following...

You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: \> mysqld install Mysql56 defaults file = C : \my op...

Assume that you want to know which Mysql Server options were set to custom values. Which two methods would you use to find out?

You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132 $tai...

A Mysql Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain the following additional configuration: [mysqld] Default-auth...

Of the following mechanisms available to connect a MySQL client to a MySQL database server, which types of connections are only available on Windows based systems?

Which of the following statements correctly describes the way to enable and use shared memory connections to the MySQL database server?

Which mysqld command line option disables incoming TCP/IP connections?

When making connections to a MySQL server on a Unix platform, which of the following is true?

Which of the following best describes the processing model for how the MySQL server handles queries?

Which of the following best describes how MySQL utilizes the grant table buffers?

You have been notified that the `apps' . `reports' table has been accidentally truncated. You have single file mysqldump backup available taken prior to the truncate. The backup co...

You have forgotten the root user account password. You decide to reset the password and execute the following: Shell> /etc/init.d/mysql stop Shell> /etc/init.d/mysql start ?skip-gr...

Which two requirements would lead towards a high availability solution?

Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?

You have enabled the Slow Query Log for a short period. When you process the Slow Query Log, you receive the following snip of output: Count: 100 Time=0 .22a (22s) Lock=0.00s (0s)...

Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= `root'@localhost' SQL SECURITY DEFINER VIEW `phone_list' AS SELECT e . id as id `e . first_...

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data. Which method would use mysqlbinlog for greater consistency?

Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?

Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?

You adjust a default configuration to the following /etc/my.cnf on a Linux installation: [mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_forma...

You are using the performance Schema to investigate replication on a slave: Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime...

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two chang...

What are three facts about backups with mysqldump?

In a test database, you issue the SELECT ... INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it. Mysql> SELECT * INTO OUTFILE...

Which two statements are true about setting the per-thread buffers higher than required?

A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a...

Which hardware storage option, when set up with redundant disks, offers the least stability, availability, and reliability for Mysql data?

Which two statements are true regarding partitioning in Mysql?

You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-ccc- ddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?

User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?

When backing up a replication slave, which three should also be backed up in addition to data?

You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?

What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?

Consider the following table: CREATE TABLE `game' ( `id' int (10) unsigned NOT NULL AUTO_INCREMENT, `keyword' varchar (45) DEFAULT NULL, `date' datetime NOT NULL, PRIMARY KEY (`id'...

Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data. This requires the following config f...