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
- 7088 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 schema in dbms?
Which is better saving files in database or in file system?
What are the properties of a database?
What do you understand by clause in sql?
What do you know about Master Data & Transaction Info Package?
In DBMS, what are the two integrity rules used?
Define entity, entity type, and entity set.
what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?
Why do I need netlib?
What is domain in dbms?
Explain the syntax of named procedure?
How do we select distinct values from a table?
Why rdbms is not suitable for big data?
What do you know about DBMS?
How many number of columns can a RECORD GROUP have ?
