+1 vote
in Sql by

Which statement is used to delete all rows in a table without having the action logged?

a) DELETE

b) REMOVE

c) DROP

d) TRUNCATE

1 Answer

0 votes
by

TRUNCATE statement removes all rows in a table without logging the individual row deletions. It uses fewer system and transaction log resources, which makes its execution fast. This statement is similar to the DELETE statement without the WHERE clause.

d) TRUNCATE

...