※This sample exam is different from those that appear in the actual OSS-DB Exam.
Before the tablespace is created, all tables and indexes are created under the base directory of the database cluster.
The tablespace is created with CREATE TABLESPACE, and the directory used is specified as the tablespace.
The table and index are created as a file within the directory specified as the tablespace.
The tablespace used by the table can be specified as a CREATE TABLE option and modified using ALTER TABLE.
The table and index can be placed in different tablespaces. Distributing the I/O in this manner can improve performance.
Striping, where one giant database is divided across multiple disks, cannot be used with the tablespace function.
Striping via RAID, which distributes one table across multiple disks, is a realistic method for improving performance.
Therefore, the correct answers are B and D.
Other RDBMS also have the tablespace function.
They have the following in common.
The tablespace is created using CREATE TABLESPACE.
The tablespace into which the table will be placed can be specified when executing CREATE TABLE.
However, we must consider the following two questions.
Is the tablespace itself a file or a directory?
What are the benefits of using the tablespace function?
There are differences depending on the type of RDBMS used, so care should be taken.