Question 6 of 10Pro Only
What are tablespaces, and how do you use them to manage storage in a database environment?
Sample answer preview
Tablespaces provide a way to control where database objects are physically stored on the file system. They allow a DBA to distribute data across multiple disks or storage volumes, which is important for performance, capacity management, and storage tiering.
tablespacefilegroupstorage tieringSSDI/O distributioninnodb_file_per_table