mysql 1z0-888_mysql ocp 1z0-888 每日一题(9)

10月9号

What two statements are true regarding FLUSH TABLES FOR EXPORT?

A. It is the safest way to extract tables from the shared tablespace.

B. Partitioned tables are not supported.

C. It can be used to export TEMPORARY tables.

D. Table only exports when the table has its own tablespace.

E. The InnoDB Storage engine must be used for the table being exported.

解析:

官网原文:

This statement applies only to existing base (non-TEMPORARY) tables. If a name refers to a base table, that table is used. TEMPORARYER_WRONG_OBJECTER_NO_SUCH_TABLE

InnoDBFOR EXPORT.ibdinnodb_file_per_tableInnoDBFOR EXPORTFOR EXPORT.ibdFOR EXPORTInnoDBInnoDBFULLTEXT

FOR EXPORTInnoDBInnoDBtable_name.cfg.cfg

FOR EXPORTInnoDBdirty pageschange buffer.ibd.cfg

参考资料:

A应该不是最安全的,安全的应该是sqldump,for export会锁表,只有表空间文件复制时需要使用(A错)

分区不可用 B对

D对

myisam也可用 E错

答案应该是BD