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
- 6342 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What do you mean by dml compiler?
What is first normal form in dbms?
What are the features of openedge features?
Where is database used?
What is the maximum size of an access database?
hello to all i want code for like this site "Submit Question" page.please give answers thanks.
Define checkpoint.
What is normalisation and its type?
In DBMS, what are the two integrity rules used?
What are the components of a database management system?
what is storage manager?
What is the meaning of flat file database?
How do you create a blank database?
What is database partitioning?
What is a sequence in a database?
