可学答题网 > 问答 > 1z0-883题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You want to create a temporary table


You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?()

  • AUse the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
  • BChange the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
  • CStop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
  • DSet binlog_format=MIXED with the – replicate-ignore-temp-table option
  • EUse the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
参考答案
参考解析:
分类:1z0-883题库
相关推荐

1、You want to create&#

You want to create a shortcut to a folder named Project on a network share.&#8194...

2、You want to create&ens

You want to create a filter for your web application and your filter will implement javax....

3、You want to create&ens

You want to create a role to meet these requirements: 1:The role is to be protected&ensp...

4、You want to create&#

You want to create an RMAN recovery catalog in the RC01 database to help you&#819...

5、You want to use RMAN to create compres

You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?()A The BZIP2 co...

6、You want to create&#

You want to create a pie-style chart using the Chart Wizard. What must be you&#81...