If I delete a table and then rollback it, do the index on the table remains?

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

Question Posted / kishore

2 Answers
6870 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If I delete a table and then rollback it, do the index on the table remains? What if I drop the t..

Answer / 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

If I delete a table and then rollback it, do the index on the table remains? What if I drop the t..

Answer / dinesh kumar

DDL COMMANDS HAVE AUTO COMMIT ....
DML COMMANDS DOES NOT HAVE AUTO COMMIT FEATURE...
SO IF WE USE "DELETE" THE STRUCTURE AND THE TABLE INDEX ARE NOT DELETD, BUT THE RECORDS ARE DELETED...

NOW IF WE USE "ROLLBACK" ALL THE RECORDS ARE GETTING BACK...

IF WE USE "DROP" ALL THE RECORDS+INDEX+STRUCTURE DELETED.
NOW WE USE "ROLLBACK" NO USE OF IT. BECAUSE AFTER EXECUTING THIS COMMAND SQL ENGINE PERFORMS "COMMIT" OPERATION.

IF WE USE "TRUNCATE" ALL THE RECORDS ARE ONLY DELETED . NOT THE STRUCTURE AND INDEX .. THIS IS ALSO DDL SO SQL ENGINE PERFORMS "COMMIT" OPERATION AFTER EXECUTING THIS COMMAND.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Database Management Interview Questions

What is a table called in database?

0 Answers

Define the relationship between ‘view’ and ‘data independence’.

0 Answers

What is the importance of query in database?

0 Answers

What is an entity-relationship model?

0 Answers

What are the advantages of database software?

0 Answers

What is the use of RECORD option in EXP command ?

1 Answers

Why its better to use files than a DBMS when there are multiple users to access the data

0 Answers Infosys,

How to use multiple database server in back end ?

0 Answers MCN Solutions,

Is it good to store image in database?

0 Answers

How to deactivate triggers?

0 Answers

1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?

2 Answers 3i Infotech,

what are the differences between an exclusive lock and a shared lock?

0 Answers

For more Database Management Interview Questions Click Here