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
- 5818 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 metadata and why should I use it?
What are the advantages of database system?
What is data model in database?
What are queries in dbms?
How do you maintain a database?
Which database is best for large data?
How many number of columns can a RECORD GROUP have ?
What is limit in dbms?
What is first normal form in dbms?
What are procedures in dbms?
i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites.
Explain a checkpoint and when does it occur?
What is difference between database and website?
How to schedule ssas database backup
Write down the differences between nosql and rdbms?
