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
Explain the use of Merge statement in oracle 11g
What is the difference between online and offline backups?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What do you understand by a database object?
What are the general rules on data consistency?
Explain the blob datatype?
what is the difference between restoring and recovering?
Are truncate and delete commands same? If so why?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What is memory advisor in Oracle?
What are temporal data types in oracle?
How to start a new transaction in oracle?
How many types of segments in Oracle?
How to define a data source name (dsn) in odbc manager?
What is the difference between $oracle_base and $oracle_home?