Greenway Health

  www.greenwayhealth.com
Work in HR? Unlock Free Profile

Greenway Health SQL Developer Interview Question

I interviewed in Carrollton, GA and was asked:
"What's the difference between TRUNCATE and DELETE"
Add Tags [?]
Answer

Part of a SQL Developer Interview Review - one of 9 Greenway Health Interview Reviews

Answers & Comments

1
of 1
vote
one gets logged, the other doesn't so you have your performance hit. Need elevated permissions i.e. dbo for TRUNCATE
- Interview Candidate on Mar 6, 2012

To comment on this question, Sign In with Facebook or Sign Up

Tags are like keywords that help categorize interview questions that have something in common.