Computer scienceFundamentalsSQL and DatabasesBasics SQLData Definition Language

Comparison of DELETE and TRUNCATE

TRUNCATE operations

Report a typo

Select the main features of the TRUNCATE operator from the list below.

Select one or more options from the list

It is a relatively slow option for removing the entire table from a relation.

The triggers are not activated within this operation.

It locks every tuple/row while removing them.

It deletes data from the entire page at once.

___

Create a free account to access the full topic