计算机认证题库 - 答案窝(daanwo.com)-大学生作业答案及考资分享平台

问题：

[多选题]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

答案解析