单选题

Choose two.You have an installation of MySQL 8 on Oracle Linux.
Which statement is true about disk temporary tables for this installation?

AOnly internal temporary tables from the optimizer will be created in tmpdir.

BTemporary tables are created in tmpdir only after they reach tmp_table_size.

CTemporary tables are created in tmpdir only if configured to use MyISAM.

DTemporary tables will use the InnoDB temporary tablespace located in datadir.

ETemporary tables will use the InnoDB temporary tablespace located in /tmp.

查看答案

正确答案：A （备注：此答案有误）

相似试题

单选题

You should choose a dentist in _____ the same way as you choose a physician, get the names of two or three dentists from friends and relatives and have a preliminary visit with each.

答案解析
单选题

Choose two.You have an installation of MySQL 8 on Oracle Linux.Which statement is true about disk temporary tables for this installation?

答案解析
多选题

Choose two.You are investigating performance problems in a MySQL database; all data fits in memory. You determine that SELECT queries to one table is the main cause for poor response times. Which two have the biggest potential for eliminating the problem?

答案解析
单选题

You have failed two tests. You’d better start working harder , you won’t pass the course.

答案解析
多选题

Choose two.You are using mysqlcheck for server maintenance. Which two statements are true?

答案解析