Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37841 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / agnel
* A truncate removes all rows from a tablethat operation
cant be rolled back.
* A drop command removes a table from a database all the
tables rows indexes and privilleges will also be removed.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the bookmark lookup and rid lookup?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain the third normal form(3nf)?
What is the standby server?
Write a program to fetch first 10 records from a file?
What happens if you delete a table that is used by a view?
Explain the truncate command?
How can we rewrite sub-queries into simple select statements or with joins?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is serializable?
How to write a query with a right outer join in ms sql server?
What is difference between join and natural join?
what are the critical issues you have resloved in your company
Explain can SSRS reports Cache results?
List out what other servers you can use with ssrs?
