You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()A.Each extra column in the copy with more columns must not have a default valueB.Col

题目
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()

A.Each extra column in the copy with more columns must not have a default value

B.Columns that are common to both versions of the table must be defined in the same order on the master and the slave

C.The slave database cannot have more columns than the master. Only the master database can have more columns

D.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server

E.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

相似考题

1.9． _______you _______ stay at home today?A． Do ; have toB． Must; have toC． Have; toD． Do ; must

2.When backing up a replication slave, which three should also be backed up in addition to data?()A.The master.info and relay.info filesB.The relay log filesC.The relay index fileD.Mysql.slave_master_info tableE.Mysql.slave_relay_log_info tableF.Mysql.slave_worker_info table

3.试题（71）～（75）A Bluetooth device can be either a master or a slave and any of the devices within a （71）can be the master. There is only one master and there can be up to （72） active slave devices at a time within a single network. In addition, a device may be a standby slave or a parked slave. There can be up to （73） parked slaves. If there are already maximum number of active slaves, then a parked slave must wait until one of the active slaves switches to （74） mode before it can become active. Within a network, all （75） communications are prohibited.（71）A. Wireless LANB. Wireless MANC. Cellular radio networkD. Piconet（72）A. 7B. 15C. 63D. 255（73）A. 127B. 255C. 511D. 1023（74）A. masterB. standby slaveC. parked slaveD. active slave（75）A. master-to-masterB. master-to-slaveC. slave-to-slaveD. slave-to-master

4.Our tradition ______ be different _____ yours.A、can;withB、must;withC、need;asD、may;from

更多“You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?() ”相关问题

  • 第1题：

    A Bluetooth device can be either a master or a slave and any of the devices within a （ ）can be the master. There is only one master and there can be up to （ ） active slave devices at a time within a single network. In addition, a device may be a standby slave or a parked slave. There can be up to （ ） parked slaves. If there are already maximum number of active slaves, then a parked slave must wait until one of the active slaves switches to （ ） mode before it can become active. Within a network, all （请作答此空） communications are prohibited.

    A.MASTER-TO-MASTER
    B.MASTER-TO-SLAVE
    C.SLAVE-TO-SLAVE
    D.SLAVE-TO-MASTER

    答案：C
    解析：
    解析：参考译文
    蓝牙设备可以是一个主设备也可以是一个从设备，位于（ ）中的任一设备都可以成为主设备。在一个网络中只有一个主设备，最多有（ ）个激活的从设备。另外，一个设备可以是活跃的从设备或是休眠的从设备，最多有（ ）个休眠的从设备。如果已有最大数量的活跃从设备，那么，一个休眠的从设备就必须等到某活跃从设备切换到（ ）模式后才能被激活。在一个网络内，所有的（请作答此空）通信都是被禁止的。

  • 第2题：

    5、MapReduce框架包括多个Master和多个Slave。


    错误

  • 第3题：

    MySQL数据库支持以下哪些复制模式？

    A．master-slave

    B．master-master

    C．master-master-slave

    D．master-slave-slave


    master-slave;master-master;master-master-slave;master-slave-slave

  • 第4题：

    Redis主从复制，下列说法错误的是

    A．同一个Master可以同步多个Slave

    B．多个slave可以连接同一个Master外，还可以连接到其他slave，可以视为树结构

    C．Master server是以阻塞的方式为slave提供服务的，Master-slave同步期间，客户端不能提交查询和修改请求

    D．Slave服务器提供只读操作，写服务必须由Master来完成


    Master server 是以阻塞的方式为slave提供服务的，Master-slave同步期间，客户端不能提交查询和修改请求

  • 第5题：

    MapReduce框架包括多个Master和多个Slave。


    错误

  • 第6题：

    MySQL 5.7中基于组提交的并行复制如何设置

    A．slave-parallel-type 设置为DATABASE

    B．slave-parallel-type 设置为LOGICAL_CLOCK

    C．master-parallel-type 设置为DATABASE

    D．master-parallel-type 设置为LOGICAL_CLOCK


    对

相关内容