Go Career
Explore
Pricing
Resources
Login
Get Started
Interview Prep
Back to SQL
Beginner
17 questions
Questions
1
Question 1
2
Question 2
3
Question 3
4
Question 4
5
Question 5
6
Question 6
7
Question 7
8
Question 8
9
Question 9
10
Question 10
11
Question 11
12
Question 12
13
Question 13
14
Question 14
15
Question 15
16
Question 16
17
Question 17
Toggle Sidebar
Back to Beginner
Question 7
/
17
beginner
Select one answer
What is the difference between DELETE and TRUNCATE?
They are exactly the same
DELETE removes specific rows and can be rolled back, TRUNCATE removes all rows and is faster
TRUNCATE can use WHERE clause, DELETE cannot
DELETE is faster than TRUNCATE
Show hint
Check Answer
Previous
Back to Beginner
Next
Go Career