问题详情

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

未搜索到的试题可在搜索页快速提交,您可在会员中心"提交的题"快速查看答案。 收藏该题
查看答案

相关问题推荐

在下列哪种情况中,成本变更可能需要重订基准线()。

A、CV都很糟糕,需要一个实际的业绩衡量方法

B、修正成本估计已经准备好并发送给干系人

C、必须采取矫正行为以使预期的未来业绩表现与项目计划相统一

D、EAC显示了即使不需要范围变更完成项目所需要的额外的资金

A IBM Director V5 customer is considering Systems Director V6 and updating their BladeCenter servers. The sales professional is asked how BladeCenter Configuration Manager works with Director V6. Which of the following is correct?()

A、This was replaced by Configuration Manager for V6

B、This must be upgraded toBladeCenter Open Fabric Manager (BOFM) for V6

C、Automation Manager must be used with Director V6

D、This is common to both V5 and V6, no change is required

Consider the query: Mysql> SET @run = 15; Mysql> EXPLAIN SELECT objective, stage, COUNT (stage) FROM iteminformation WHERE run=@run AND objective=’7.1’ GROUP BY objective,stage ORDER BY stage; The iteminformation table has the following indexes; Mysql> SHOW INDEXES FROM iteminformation: This query is run several times in an application with different values in the WHERE clause in a growing data set. What is the primary improvement that can be made for this scenario?()

A、 Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes

B、 Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations

C、 Drop the run_2 index because it has caused a conflict in the choice of key for this query

D、 Execute the run_2 index because it has caused a conflict in the choice of key for this query

E、 Add a composite index on (run,objective,stage) to allow the query to fully utilize an index

以下选项中,值为1的表达式是(  )。

A、'1'-0

B、1-'0'

C、1-'\0'

D、'\0'-'0'

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

A、Mysqlaccess

B、Mysqldump

C、Mysqlshow

D、Mysqlslow

E、Mysqldumpslow

联系客服 会员中心
TOP