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
- 7089 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 stored procedures.
What is difference between database and server?
What do you understand by database triggers?
What is a distributed database?
what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000
What is rdbms data?
What is a data type in a database?
What is the role of database server in database management system?
Explain the different types of constraints in dbms?
dear sir please provide what question will be asked in bank it officer interview
Explain the types of database normalization?
What is an image database?
What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?
Enlist various types of interactions created by dbms?
What is tabular form?
