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