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
Answers were Sorted based on User's Feedback
Answer / mohammed
DROP and TRUNCATE are DDL commands, whereas DELETE is a DML
command. Therefore DELETE operations can be rolled back
(undone), while DROP and TRUNCATE operations cannot be
rolled back.It is possible to delete all rows in a table
without deleting the table. This means that the table
structure, attributes, and indexes will be intact.Indexes,
tables, and databases can easily be deleted/removed with
the DROP statement. If we only want to delete the data
inside the table, and not the table itself....
Then, use the TRUNCATE TABLE statement.
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / 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 |
What is db flush?
What is a degree of relation?
What is database definition (dbd)?
Describe the four types of indexes.
What is the difference between case version and decode version?
describe middleware applications that ease the connection of databases to web?
How to deactivate triggers?
What built in subprogram is used to manipulate images in image items ?
What is tuple with example?
What is normalization in database with example?
What is the use of PARFILE option in EXP command ?
how to generate an auto incremental number in a ssis package?