Answer Posted / sachin
the main difference between delete and truncate is that in
the truncate u will delete all the values from the table as
well as from the data dictionaries also while delete is used
to delete selected values and in the same way drop is use
to delete whole data from a table but the deleted data will
occupy the memory space in the extents but if we perform
truncate then the extents are free from the deleted data .....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is dynamic SGA and static SGA
Can multiple cursors being opened at the same time?
What are the types of trigger in oracle?
Differentiate between pre-select and pre-query?
How can I see all tables in oracle?
What are the uses of linked server and explain it in detail?
Explain the use of show option in imp command.
What is a user account in oracle?
What privilege is needed for a user to create views in oracle?
What are the different types of partitions in oracle?
What happens if the imported table already exists?
What are the different types of record groups in oracle? Explain each of them
How to delete a column in an existing table in oracle?
How to turn on or off recycle bin for the session?
what are the default admin accounts in Oracle 10g ?
