多选题

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?()

A. Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B. hange the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D. Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E. Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table

查看答案
该试题由用户716****97提供 查看答案人数:43606 如遇到问题请联系客服
正确答案
该试题由用户716****97提供 查看答案人数:43607 如遇到问题请联系客服
热门试题
购买搜题卡会员须知|联系客服
会员须知|联系客服
关注公众号,回复验证码
享30次免费查看答案
微信扫码关注 立即领取
恭喜获得奖励,快去免费查看答案吧~
去查看答案
全站题库适用,可用于聚题库网站及系列App

    只用于搜题看答案,不支持试卷、题库练习 ,下载APP还可体验拍照搜题和语音搜索

    支付方式

     

     

     
    首次登录享
    免费查看答案20
    登录成功
    首次登录已为您完成账号注册,
    可在【个人中心】修改密码或在登录时选择忘记密码
    账号登录默认密码:手机号后六位