Question

In SQL, the CREATE TABLESPACE is used

(a) To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace

(b) To create a database trigger

(c) To add/rename data files, to change storage

(d) All of the mentioned

The question was asked in exam.

Query is from A Simple Transaction Model in chapter Transactions of Database Management

Answer 1

Correct answer is (a) To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace

The best I can explain: Triggers are used to initialize the actions for an activity.