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
6998 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 n tier architecture in dbms?

0 Answers

What are the characteristics of database?

0 Answers

Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?

0 Answers

What is the difference between a shared lock and exclusive lock?

0 Answers

Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz

1 Answers

What are the applications of database?

0 Answers

What is the maximum size of an access database?

0 Answers

How do you exit a database?

0 Answers

What is metadata and why should I use it?

0 Answers

What does a COMMIT statement do to a CURSOR?

1 Answers Microsoft, Oracle,

What are the advantages of a database?

0 Answers

What is atomicity in dbms?

0 Answers

For more Database Management Interview Questions Click Here