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
- 6112 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 is indexing in database with example?
Can you explain the 'between' clause?
What is dbms and its functions?
What are different types of transaction isolation levels?
How many types of data are there?
What is query in database?
Who is end user in database?
Explain the Logical Schema of Database
What is the 3-tier architecture?
What are the types of tables in database?
What are the properties of a primary key in DBMS?
Which two statements are true about a foreign key?
What are the three levels of data abstraction?
What is big data in database?
Can you explain the select into statement?
