Sample Exam Questions

From the objective of OSS-DB Exam Silver
S3.1 SQL commands (Tablespace)

Sample Question


The tablespace ts1 was created with the CREATE TABLESPACE command. Choose two appropriate statements from the following descriptions.

  1. ts1 is available only from the database to which it was connected at the time of creation and cannot be used from any other database in the database cluster.

  2. To create a new object such as a table in ts1, you must have the appropriate privileges for ts1.

  3. To access the tables created in ts1, you must have the appropriate privileges for ts1.

  4. ts1 is dedicated to creating new objects only; you cannot move existing objects to ts1.

  5. For an existing table, only an index can be created on ts1.

※This sample exam is different from those that appear in the actual OSS-DB Exam.

Answer and Explanation

By creating tablespaces, you can place database objects, such as tables and indexes, in a file system that is different from the one used in your existing configuration. Tablespaces are shared within a database cluster, so they can also be used by other databases in the cluster.

To create objects in a tablespace, you need the CREATE privilege for the tablespace. To access a table in a tablespace, you only need SELECT or other privileges for the table, and you do not need any privileges for the tablespace itself.

To create an object in the tablespace ts1, specify TABLESPACE ts1 as an option in CREATE TABLE or CREATE INDEX. It is also possible to place tables and indexes in different tablespaces. You can also change the tablespace where an object is located. For example, if you specify SET TABLESPACE ts1 as an option in ALTER TABLE, the table will be moved to ts1.

Therefore, the correct answers are B and E.