SQL Test Paper 2 | SQL Quiz 2

SQL Server Quiz Paper-2

In this sql server quiz paper 2 we have prepared questions based on Difference between Truncate and Delete command in SQL. It is frequently asked question in sql server interview

Delete command is ________?

A) DML Command
B) DDL Command

{{Que1}}

Truncate command is ________?

A) DML Command
B) DDL Command

{{Que2}}

Can we use where clause with truncate command in SQL Server?

A) Yes
B) No

{{Que3}}

If We use Delete command then Identity would be reset?

A) Yes
B) No

{{Que4}}

SQL Server Quiz Paper 2

SQL Server Quiz Paper-2

Delete command is ________?

Truncate command is ________?

Can we use where clause with truncate command in SQL Server?

If We use Delete command then Identity would be reset?