题目:
Which statement is true about tablespaces?
答案:D
A) All tables must be in either the system tablespace or a general tablespace.
B) General tablespaces can be configured to span multiple files.
C) All tablespace files must be in the directory specified by the --datadir option.
D) The system tablespace can be configured to span multiple files.
解析:来源官方文档
14.6.3 Tablespaces
14.6.3.1 The System Tablespace
14.6.3.2 File-Per-Table Tablespaces
14.6.3.3 General Tablespaces
14.6.3.4 Undo Tablespaces
14.6.3.5 The Temporary Tablespace
A错、表还可以放在File-Per-Table Tablespaces中
B错、General tablespaces可以含多个表,但是不能含多个数据文件
C错、General tablespaces创建语法中datafile可以指明路径
system tablespace
The system tablespace is the storage area for the InnoDB data dictionary, the doublewrite buffer, the change