Which of the following statements will successfully create a table that scores index data in a different table space than the table data?
Which of the following statements will successfully create a table that scores index data in a different table space than the table data?
To create a table that stores index data in a different table space than the table data, the correct syntax should indicate which table space holds the table data and which holds the index data. The correct statement is 'CREATE TABLE t1 (c1 INT, c2 INT) DATA IN TS1 INDEX IN TS2;' This specifies the table data space as TS1 and the index space as TS2.
B i good
Correct Answer