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
- 6113 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
What is difference between database and schema?
What are procedures in dbms?
What database does facebook use?
when All datafiles related to a Tablespace are removed ?
Define fragmentation.
What is the best database management system?
What is sql in dbms?
What are the types of database management system?
What is meant by a database?
What is a concurrency problem in dbms?
What is progress apama?
Define denormalization.
Which database is best for storing large data?
What are the main components of a database in healthcare?
What is db context?
