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
- 6980 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 database development process?
Why do we need database management?
Do we consider null values the same as that of blank space or zero?
Where is data stored in a database?
Define cursor.
How does a database partition work?
What are database data types?
When would you use a database?
How do you start a database?
What are different partitioning techniques in database?
What is the meaning of flat file database?
How do convert or display the date or time as string?
Explain what are triggers and rules?
What do you mean by starvation in dbms?
Explain 5nf?
