Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37859 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
Is there any difference between primary key and unique with the not null condition?
What is 'Join' and explain its various types.
How to create a view with data from multiple tables?
What is a primary key?
What does truncate do?
Explain about sql server login?
Can a trigger be created on a view?
What's the information that can be stored inside a bit column?
Mention the different authentication modes in sql server.
What is the recovery model?
What are distinctive joins find as a part of sql?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is a bit datatype?
What are the different types of stored procedures?
How to see existing views in ms sql server?
