多选题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?（）AEach extra column in the copy with more columns must not have a default valueBC

题目
多选题
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.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.Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC.The slave database cannot have more columns than the master. Only the master database can have more columnsD.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 serverE.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

2.Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

3.A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()A.TableB.ColumnsC.Table and AliasD.Columns and Alias

4.The EMPLOYEES table has these columns:Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:What is true about your ALTER statement?()A. Column definitions cannot be altered to add DEFAULT values.B. A change to the DEFAULT value affects only subsequent insertions to the table.C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

更多“多选题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?（）AEach extra column in the copy with more columns must not have a default valueBC”相关问题

  • 第1题：

    In which of the following situations should correlation names be used?()

    A.A table referenced in the FROM clause has no indexed column.

    B.The table referenced in the FROM clause has more than 200 columns.

    C.Two or more tables in the FROM clause have identical column names.

    D.The FROM clause contains two or more tables in the SELECT statement.


    参考答案：C

  • 第2题：

    While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

    • A、A primary key must have been created.
    • B、A mapping table must have been created.
    • C、An overflow tablespace must have been specified.
    • D、The PCTTHRESHOLD option must have been specified.

    正确答案:B

  • 第3题：

    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、Change 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

    正确答案:B,E

  • 第4题：

    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

    正确答案:B,D

  • 第5题：

    The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY DEFAULT 5000); What is true about your ALTER statement?（）

    • A、Column definitions cannot be altered to add DEFAULT values.
    • B、A change to the DEFAULT value affects only subsequent insertions to the table.
    • C、Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.
    • D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

    正确答案:B

  • 第6题：

    The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); Which is true about your ALTER statement?（）

    • A、Column definitions cannot be altered to add DEFAULT values.
    • B、A change to the DEFAULT value affects only subsequent insertions to the table.
    • C、Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.
    • D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

    正确答案:B

  • 第7题：

    The EMPLOYEES table has these columns:LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATEManagement wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000);Which is true about your ALTER statement?（）

    • A、Column definitions cannot be altered to add DEFAULT values.
    • B、A change to the DEFAULT value affects only subsequent insertions to the table.
    • C、Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.
    • D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

    正确答案:B

  • 第8题：

    多选题
    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

    Change 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


    正确答案： A,D
    解析： 暂无解析

  • 第9题：

    多选题
    Which two statements are true regarding the USING and ON clauses in table joins?（）
    A

    Both USING and ON clauses can be used for equijoins and nonequijoins

    B

    Amaximum of one pair of columns can be joined between two tables using the ON clause

    C

    The ON clause can be used to join tables on columns that have different names but compatible data types

    D

    The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause


    正确答案： A,C
    解析： 暂无解析

  • 第10题：

    单选题
    The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); Which is true about your ALTER statement?（）
    A

    Column definitions cannot be altered to add DEFAULT values.

    B

    A change to the DEFAULT value affects only subsequent insertions to the table.

    C

    Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

    D

    All the rows that have a NULL value for the SALARY column will be updated with the value 5000.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    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


    正确答案： B,A
    解析： 暂无解析

  • 第12题：

    单选题
    The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY DEFAULT 5000); What is true about your ALTER statement?（）
    A

    Column definitions cannot be altered to add DEFAULT values.

    B

    A change to the DEFAULT value affects only subsequent insertions to the table.

    C

    Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.

    D

    All the rows that have a NULL value for the SALARY column will be updated with the value 5000.


    正确答案： A
    解析： 暂无解析

  • 第13题：

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

  • 第14题：

    In which of the following situations should correlation names be used?（）

    • A、A table referenced in the FROM clause has no indexed column.
    • B、The table referenced in the FROM clause has more than 200 columns.
    • C、Two or more tables in the FROM clause have identical column names.
    • D、The FROM clause contains two or more tables in the SELECT statement.

    正确答案:C

  • 第15题：

    While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（） 

    • A、A primary key must have been created.
    • B、A mapping table must have been created.
    • C、An overflow tablespace must have been specified.
    • D、The PCTTHRESHOLD option must have been specified.

    正确答案:B

  • 第16题：

    A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）

    • A、Table
    • B、Columns
    • C、Table and Alias
    • D、Columns and Alias

    正确答案:A

  • 第17题：

    Which three statements about subqueries are true? （）

    • A、A main query can have more than one subquery.
    • B、A subquery can have more than one main query.
    • C、The subquery and main query must retrieve data from the same table.
    • D、The subquery and main query can retrieve data from different tables.
    • E、Only one column or expression can be compared between the subquery and main query.
    • F、Multiple columns or expression can be compared between the subquery and main query.

    正确答案:A,C,E

  • 第18题：

    Which of the following statements is true regarding implementing a Flashback Table recovery？  （）

    • A、 An SCN is never used to perform a Flashback Table recovery.
    • B、 If a significant number of changes have been made to the table， row movement must be enabled.
    • C、 The tablespace must be offline before performing a Flashback Table recovery.
    • D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.

    正确答案:D

  • 第19题：

    You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）

    • A、Specify a view based on the archival data table and current data tables.
    • B、Specify that the data must be queried by using a stored procedure.
    • C、Specify that both the archival data table and the current data tables must have indexes created on the same columns.
    • D、Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

    正确答案:A

  • 第20题：

    多选题
    Which three statements about subqueries are true? （）
    A

    A main query can have more than one subquery.

    B

    A subquery can have more than one main query.

    C

    The subquery and main query must retrieve data from the same table.

    D

    The subquery and main query can retrieve data from different tables.

    E

    Only one column or expression can be compared between the subquery and main query.

    F

    Multiple columns or expression can be compared between the subquery and main query.


    正确答案： C,D
    解析： 暂无解析

  • 第21题：

    单选题
    While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
    A

    A primary key must have been created.

    B

    A mapping table must have been created.

    C

    An overflow tablespace must have been specified.

    D

    The PCTTHRESHOLD option must have been specified.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    The EMPLOYEES table has these columns:LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATEManagement wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000);Which is true about your ALTER statement?（）
    A

    Column definitions cannot be altered to add DEFAULT values.

    B

    A change to the DEFAULT value affects only subsequent insertions to the table.

    C

    Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

    D

    All the rows that have a NULL value for the SALARY column will be updated with the value 5000.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    In which of the following situations should correlation names be used?（）
    A

    A table referenced in the FROM clause has no indexed column.

    B

    The table referenced in the FROM clause has more than 200 columns.

    C

    Two or more tables in the FROM clause have identical column names.

    D

    The FROM clause contains two or more tables in the SELECT statement.


    正确答案： B
    解析： 暂无解析

相关内容