1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ175

Database Design

Which two of the following statements are true about general tablespaces?

Choose two
  • A Dropping a table from a general tablespace releases the space back to the operating system.
  • B A new table can be created explicitly in a general tablespace.
  • C General tablespaces support temporary tables.
  • D A general tablespace can have multiple data files.
  • E A table can be moved into a general tablespace.
Explanation

An InnoDB table can be created directly in an existing general tablespace with the TABLESPACE option, and ALTER TABLE ... TABLESPACE can move a table into an existing general tablespace. General tablespaces do not support temporary tables; dropping a table returns space for internal reuse rather than to the operating system; and an InnoDB general tablespace is created with a single data file.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!