What is the difference between Drop and Truncate
- 20 Answers
- 34137 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / mohsin mohammed abdul
Drop means removing the existing object from the database.
turncate means you are deleting the data from the table and
oracle implicitly issues commit statment and even when you
say rollback , you won't get the data back due to commit ..
| Is This Answer Correct ? | 36 Yes | 12 No |
Post New Answer View All Answers
After removing a table from database, what other related objects have to be dropped explicitly?
What are the approximate numeric data types?
Do you know the different ddl commands in sql?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
When to use Inner join & when to use subquery?
Can two tables share the same primary key?
Does transparent data encryption provide encryption when transmitting data across the network?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is etl - extraction, transformation, and loading?
Explain what is the use of custom fields in report?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
what is the main function of a query parameter?
State a few properties of relational databases?
