You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）

来源：考试资料网2018-08-01

What is true regarding InnoDB locking?（）

来源：考试资料网2018-08-01

Your developers have created table to store some of their program's data.
After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.
An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…'
What should you do to improve the overall performance?（）

来源：考试资料网2018-08-01

You have table 'apps','userdata' on server that uses MyISAM storage engine.
You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands:
Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps
Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;'
Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps
What effect does the – order-by-primary argument have on the mysqldump command?（）

来源：考试资料网2018-08-01

You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?（）

来源：考试资料网2018-08-01