easy5 pts · first answer countssql

DELETE vs TRUNCATE

Which statement about DELETE and TRUNCATE is correct?

A.TRUNCATE can remove selected rows using a WHERE clauseB.DELETE removes the table definition along with the rowsC.They behave the same; TRUNCATE is only a shorter nameD.TRUNCATE removes all rows quickly without a WHERE clause, while DELETE can remove selected rows and fires row-level triggers

← Least privilege for an app user Filtering rows where a value is NULL →