You want a record of all queries that ...

单项选择题You want a record of all queries that are not using indexes. How would you achieve this?（）

A.By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B.By enabling the Error Log because not using indexes is an error
C.By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D.By enabling the Error Log and using the – log-queries-not-using-indexes option

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题 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 file options: Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1 However, this configuration is expected to introduce disk I/O overhead.
What three changes will reduce disk I/O overheads?（）

A.Use of soft links for database directories on the same physical disk
B.Use of delay_key_write=ON for batch index update
C.Allocation of RAM to the buffer pool such that more of the data can fit in RAM
D.Placement of InnoDB log files and datadir on separate physical disks
E.Use of separate directories on the same physical disk for log files and data files

点击查看答案

2.单项选择题 Consider the following table:

Which method should used to add a new g201305 partition to the table?（）

A.A
B.B
C.C
D.D
E.E

点击查看答案

3.多项选择题What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）

A.File system snapshots
B.Mysqldumpslow
C.Mysqlhotcopy
D.Mysqldump with – binary-data option
E.Mysql Enterprise Backup

点击查看答案

4.多项选择题You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?（）

A.Shell＞ mysqladmin –u root –p shutdown
B.Shell＞ nmc mysql shutdown
C.Mysql＞ STOP PROCESS mysqld
D.Shell＞ /etc/init.d/mysql stop
E.Shell＞ service mysql safe_exit
F.Shell＞ pkill –u mysql mysqld_safe
G.Shell＞ net stop mysql

点击查看答案

5.多项选择题When backing up a replication slave, which three should also be backed up in addition to data?（）

A.The master.info and relay.info files
B.The relay log files
C.The relay index file
D.Mysql.slave_master_info table
E.Mysql.slave_relay_log_info table
F.Mysql.slave_worker_info table

点击查看答案

6.单项选择题User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）

A.UPDATE pets…
B.SELECT….FROM pets
C.INSERT INTO pets…
D.ALTER TABLE pets…

点击查看答案

7.单项选择题You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?（）

A.STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE
B.STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE
C.STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE
D.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE

点击查看答案

8.多项选择题Which two statements are true regarding partitioning in Mysql?（）

A.Tables with BLOB and TEXT columns cannot be partitioned
B.Partitioning allows easier management of smaller data sets for certain queries
C.Partitioning allows different columns to be stored in separate files
D.The partitioning expression is an integer or function that returns an integer value or NULL value
E.Partitioning is only available for those storage engines that implements it natively

点击查看答案

9.单项选择题Which hardware storage option, when set up with redundant disks, offers the least stability,availability, and reliability for Mysql data?（）

A.RAID 5
B.iSCSI
C.SAN (Storage Area Network)
D.NFS (Networked File System)

点击查看答案

10.多项选择题 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 separate server in a DMZ.
Which two will optimize the security of this setup?（）

A.Disabling connections from named pipes or socket files (depending on the operating system of the server)
B.Enabling and using SSL for connections to the Mysql database
C.Installing Mysql on the application server, and running the database and application on the same server
D.Starting the server with – bind- address=0.0.0.0 specified
E.Running the server with – skip-networking specified
F.Limiting logins to originate from the application server or the server's subnet'

点击查看答案