which statement is true regarding the maintenance of tables? 1.truncating a table deletes all rows in a table.corresponding indexes will not be truncated. 2.nonpartitioned table reorgnization moves data into a new segment while preserving the index.Constraints,privileges,and trigger are disable . 3.once a column within a table has been ed as UNUSED,a new column with the same name as the UNUSED column can be added to the table. 4.dropping a column from a table removes the column length and data from each row.indexes and constraints must be re-created .
which statement is true regarding the maintenance of tables?
1.truncating a table deletes all rows in a table.corresponding indexes will not
be truncated.
2.nonpartitioned table reorgnization moves data into a new segment
while preserving the index.Constraints,privileges,and trigger are disable .
3.once a column within a table has been ed as UNUSED,a new column with the
same name as the UNUSED column can be added to the table.
4.dropping a column from a table removes the column length and data
from each row.indexes and constraints must be re-created .
而且表被TRUNCATED以后,相关的INDEXES肯定是被删除了.答案1是有点问题的.
请高手继续赐教