多项选择题
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
相关考题
-
单项选择题
You are attempting to secure a MySQL server by using SSL encryption. On starting MySQL, you get this error: 130123 10:38:02 [ERROR] mysqld: unknown option —ssl What is the cause of the error?（）
A.The — ssl level was not specified
B.The server was not started with the – enable–ssl-plugin option
C.— ssl is not a valid server option
D.The mysqld binary was not compiled with SSL support
E.The server's SSL certificate was invalid -
多项选择题
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?（）
A.Table_open_cache
B.Table_open_cache_instancs
C.Table_definition_cache
D.Tmp_table_size
E.Max_heap_table_size
F.Max_tmp_tables -
多项选择题
Which three methods will show the storage engine for the Country table?（）
A.A
B.B
C.C
D.D
E.E
