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 / 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 |
Post New Answer View All Answers
Enlist some commands of ddl, dml, and dcl.
Which parameters are optional in init.ora parameter file?
What is a deadlock and mention how it can be resolved?
what are the differences between network and hierarchical database model?
How big is google's database?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
Where is data stored in a database?
What is the definition of database management system?
What is the full form of rdbms?
How to do replication of firebird databases?
What is the advantage of the database management approach
What are the advantages of database?
Explain 3nf?
What entity means?
Explain what are tp-lite and tp-heavy monitors?