Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do I uninstall oracle 11g?
What are the tools for Oracle ?
What is the meaning of recursive hints in oracle?
What is data file?
What to do if dba lost the system password?
What is the usage of save points in oracle database?
What is format trigger?
How to create a table index?
What is oracle data type?
Explain an integrity constrains?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What happens if variable names collide with table/column names?
Where do you use decode and case statements?
Explain the use of constraints option in exp command.
What is a database schema in oracle?
