Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6958 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 do you mean by e-r model & object-oriented model?
What is data model in database?
What is a key in database?
What is index hunting?
What is index and also explain types of indexing in dbms?
What does a database contain?
What do you mean by deadlock dbms?
What are the examples of database?
What you mean by Object Relational DBMS?
What are the importance of database in banking?
What is the database approach?
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
What is database normalization with example?
What is 'cross join'? Or what is cartesian product?
Who is the founder of database?
