Skip to contentSkip to footer
      employer cover photo
      employer logo
      employer logo

      Greenway Health

      Part of Vista Equity Partners

      Engaged employer

      Greenway Health SQL Developer interview

      Greenway Health interview question

      SQL Developer Interview

      What's the difference between TRUNCATE and DELETE

      Interview Answers

      Anonymous

      20 June 2017

      Both delete the data but Delete is a DML command can roll back but Truncate is a DDL command and don’t roll back and faster than DML

      Anonymous

      7 Mar 2012

      one gets logged, the other doesn't so you have your performance hit. Need elevated permissions i.e. dbo for TRUNCATE

      1
      Related searches: Greenway Health reviews | Greenway Health jobs | Greenway Health salaries | Greenway Health benefits
      Greenway Health interviews