多选题

Choose two.Your MySQL server was upgraded from an earlier major version.

AThe sales database contains three tables, one of which is the transactions table, which has 4 million rows.

BYou are running low on disk space on the datadir partition and begin to investigate. Examine these commands and output:

CExecuting SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.

DExecuting ALTER TABLE transactions will enable you to free up disk space.

ETruncating the transactions table will free up the most disk space.

查看答案

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

相似试题

多选题

Choose two.Your MySQL server was upgraded from an earlier major version.

答案解析
多选题

Choose two.Examine this command and output:

答案解析
多选题

Choose two.User account baduser@hostname on your MySQL instance has been compromised. Which two commands stop any new connections using the compromised account?

答案解析
单选题

Your customer wants the document numbers for two separate document types to share the same number range. How can you achieve this?Please choose the correct answer.

答案解析
多选题

Choose two.Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.Which two sets of actions when completed will accomplish this?

答案解析