What is the difference between Drop and Truncate
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
Which rendering formats are affected by the pagesize properties?
What is the difference between a unique key and primary key?
How to see the event list of an existing trigger using sys.trigger_events?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What are “unrepeatable reads”?
which backup strategy you are following at ur company
How can you control the amount of free space in your index pages?
How can we delete Duplicate row in table?
how we use window authentication connection with sql server.?
Explain tablesample?
Can you tell me about the concept of ER diagrams?
Create and insert into temp table in sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain what is meant by replication of database?
Do you know what is xpath?