Question: What are the differences between performing a DELETE versus a TRUNCATE statement on a SQL database table? ( Select Three. ) DELETE can be used
What are the differences between performing a DELETE versus a TRUNCATE statement on a SQL database table?
Select Three.
DELETE can be used without a WHERE clause to remove all rows in a table.
TRUNCATE is slower than using DELETE.
TRUNCATE can be used to remove all rows from a table.
DELETE can be used with a WHERE clause to remove specific rows.
TRUNCATE can be used with a WHERE clause to remove specific rows from a table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
