单项选择题

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