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
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 artificial key?
what are database files, control files and log files. How many of these files should a database have at least? Why?
What do you mean by e-r model?
Enlist various types of interactions created by dbms?
what do u mean by implementation?
What is Database testing and What are ways of writing test cases for database testing?
Define a relation schema and a relation.
Explain the components of rdbms?
What is openedge rdbms?
What are the properties of a database?
How many number of columns can a RECORD GROUP have ?
what is the difference between filters and conditions?
What is a concurrency problem in dbms?
What is bcnf in the dbms?
Explain concurrency transparency.