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
Who is the owner of a schema in ms sql server?
What do you understand by recursive stored procedure?
What happens if null values are involved in arithmetic operations?
What is meant by referential integrity?
What is wrong with sql server client libarary dll, ntwdblib.dll?
is there a column to which a default can't be bound? : Sql server database administration
What language is sql server written in?
Do you know the capabilities of cursors?
Explain partitioned view?
what are triggers? : Sql server database administration
sql database suspect We have a sql database that is showing as suspect. How can we recover?
How to define and use table alias names in ms sql server?
What is the difference between local and global temporary tables?
What is the difference between grant and with grant while giving permissions to the user?
Explain what is “asynchronous” communication in sql server service broker?