网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）
A
MySQL Replication
B
Distributed Replication Block Device
C
Windows Server Failover Clustering
D
MySQL Cluster
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）A MySQL ReplicationB Distributed Replication Block DeviceC Windows Server Failover ClusteringD MySQL Cluster” 相关考题
考题
单选题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/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）A
Increase the value of table_definition_cacheB
Increase the value of table_open_cache_instancesC
Decrease the value of table_open_cache_instancesD
Increase the value of table_open_cacheE
Decrease the value of table_definition_cacheF
Decrease the value of table_open_cache
考题
单选题MySQL is installed on a Linux server and has the following configuration: What is the purpose of changing ownership of datadir to the ‘mysql’ user?（）A
MySQL requires correct file ownership while remaining secureB
MySQL needs to be run as the root user, but file cannot be owned by itC
MySQL cannot be run as the root user
考题
单选题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 SLAVEB
STOP SLAVE; BEGIN; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVEC
STOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVED
STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
考题
单选题Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）A
MySQL ReplicationB
Distributed Replication Block DeviceC
Windows Server Failover ClusteringD
MySQL Cluster
考题
单选题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 number of file handles in use?（）A
Activating the MySQL Enterprise thread pool pluginB
Relocating your data and log files to separate storage devicesC
Disconnecting idle localhost client sessionsD
Implementing storage engine data compression options
考题
多选题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 other running database?（）AMysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';BShell＞ mysql –u root –p sakila sakila2013.sqlCShell＞ mysql import –u root –p sakila sakila2013.sqlDShell＞ mysql –u root -p –e 'use sakila; source sakila2013.sql'EShell＞ mysql –u root –p –silent ＜ sakila2013.sql
热门标签
最新试卷
