Answer Posted / surendra
truncate
it deletes only the records from the table
it doesn't delete the structure of the table
we cannot rollback it
we cannot delete a particular record from the table
it is ddl
drop
it deletes the records as well as structure of the table too
we cannot rollback the records
we can flashback the table from the version 9x
it is ddl
delete
it deletes the only records which are we mention in the where clause or whole records
it is dml
we can rollback it
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Explain the use of grant option in imp command.
How to assign values to variables?
Will you be able to store pictures in the database?
How to define an oracle cursor variable?
Please explain compound trigger in oracle?
How to pass parameters to procedures?
What is the use of oracle?
What is an oracle table?
How to fetch the row which has the max value for a column?
What is oracle in java?
What is a private synonym?
What is the difference between hot backup and cold backup in oracle?
How to define a cusotmer as a supplier in ORACLE R12
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?