A.Can back up a remote database serverB.Allow a consist……

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

单项选择题You adjust a default configuration to the following etc my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?（）

A.Mysqld uses internal configuration versioning and reverts to the previous configuration
B.When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes
C.The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes
D.Mysqld prints to the error log about an unknown variable, and then exits

单项选择题Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）

A.MySQL Replication
B.Distributed Replication Block Device
C.Windows Server Failover Clustering
D.MySQL Cluster

单项选择题Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）

A.Mysqlaccess
B.Mysqldump
C.Mysqlshow
D.Mysqlslow
E.Mysqldumpslow

单项选择题Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= root@localhost SQL SECURITY DEFINER VIEW phone_list AS SELECT e . id as id e . first_name AS first_name e . last_name AS last_name coalesce ( ph1.phone_no, – ) AS office_no coalesce (ph2 .phone_no, – ) AS cell_no FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = office LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = mobile The tables employees and employee_phone are InnoDB tables; all columns are used in this view. The contents of the phone_list view are as follows: Mysql> select * from phone_list; 1 row in set (0.00 sec) Which method can you use to change the cell_no value to 555-8888 for John Doe?（）

A.INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile')
B.UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe'
C.DELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888)
D.UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1