Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ashu singh
Drop deletes the table along with its structure from the database.
Delete command deletes the records from the table and it also deletes the table space allocated in the database.
Truncate is similar to Delete but it does not delete the table space from the database.
Drop and Truncate are the DDL command hence can't be rolled back whereas Delete is a DML command and can be rolled back.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
what is the difference between functional dependecy and multilevel dependency?
What is execute immediate in oracle?
How will you identify oracle database software release?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is translate in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to convert a string to a date in oracle database?
How to convert characters to times in oracle?
What is archive log in Oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What happens if you lost a data file?
Define oracle database
What is Data Dictionary Cache in Oracle?
What to do if the binary spfile is wrong for the default instance?
How to connect to the server with user account: sys?
