[多选题]Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > saki
[多选题]Which two are correct steps in taking a binary backup of MyISAM tables?()
[单选题]You have table 'apps','userdata' on server that uses MyISAM storage engine. You
[单选题]Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1,
[单选题]You are investigating the performance of the server and see the following information: Events_waits_
[单选题]You have a login-path named "adamlocal" that was created by using the mysql_config_editor
[多选题]Which two statements are true about setting the per-thread buffers higher than required?()
[多选题]Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA sol
[单选题]Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?()
[多选题]Which three methods will show the storage engine for the Country table?()
[单选题]MySQL is installed on a Linux server and has the following configuration: What is the purpose of cha
[多选题]Which two statements are true regarding partitioning in Mysql?()
[多选题]The InnoDB engine has a feature known as clustered indexes. Which three statements are true about cl
[多选题]What are four capabilities of the mysql client program?()
[多选题]A MySQL replication slave is set up as follows: User all InnoDB tables Receives ROW-based binary log
[多选题]You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is
[多选题]Which two options describe how MySQL Server allocates memory?()
[多选题]Which three are properties of the MyISAM storage engine?()
[多选题]Which two statements are true about InnoDB auto-increment locking?()
[单选题]A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?()
[单选题]Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash,
[单选题]You have a server that has very limited memory but has a very large table. You will use mysqldump to
[单选题]You want a record of all queries that are not using indexes. How would you achieve this?()
[多选题]Which three statements describe how the strict SQL mode provides added security?()
[多选题]Consider the events_% tables in performance Schema. Which two methods will clear or reset the collec