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
- 6957 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
Define ddl and dml.
How is the pattern matching done in the sql?
When does checkpoint occur in dbms?
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
Difference between data and information, and how are they related in a database?
Explain 4nf?
What is optimization in database?
How to drop all foreign keys in database?
Explain the importance of database partitioning.
Explain degree of a relation?
What are the advantages of dbms?
What is a checkpoint in dbms and when does it occur?
What is database management definition?
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
What is difference between sql and rdbms?
