If I delete a table and then rollback it, do the index on
the table remains?
What if I drop the table and roll back?Do index on the
table remains?
What if I truncate the table and roll back? Do the index on
the table remains
- 2 Answers
- 6352 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohammed
DROP and TRUNCATE are DDL commands, whereas DELETE is a DML
command. Therefore DELETE operations can be rolled back
(undone), while DROP and TRUNCATE operations cannot be
rolled back.It is possible to delete all rows in a table
without deleting the table. This means that the table
structure, attributes, and indexes will be intact.Indexes,
tables, and databases can easily be deleted/removed with
the DROP statement. If we only want to delete the data
inside the table, and not the table itself....
Then, use the TRUNCATE TABLE statement.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How does notification services work?
What are the characteristics of database?
Is database a data structure?
Explain the three Level Architecture of the Database System
What is the e-r model?
Explain what are the types of transparencies?
how to generate an auto incremental number in a ssis package?
What is table normalization?
Who invented schema theory?
How many database systems are there?
What is ims software environment?
What is the data in a database?
What are the different types of database?
What are the 4 types of database?
How index hunting contributes in improving the query performance?
