Explain the truncate command?
Submitted by: AdministratorTruncate command is used to remove all rows of the column.
The removed records are not recorded in the transaction log.
It is the fast way to remove all the records from the table.
The records once removed can't be rolled back.
It can't activate trigger.
It resets the identity of the column.
Submitted by: Administrator
The removed records are not recorded in the transaction log.
It is the fast way to remove all the records from the table.
The records once removed can't be rolled back.
It can't activate trigger.
It resets the identity of the column.
Submitted by: Administrator
Read Online SQL Server Architecture Job Interview Questions And Answers
Top SQL Server Architecture Questions
| ☺ | What do you know about system database? |
| ☺ | Explain the Microsoft SQL Server delete command? |
| ☺ | What is Model Database? |
| ☺ | Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? |
| ☺ | What is MSDB Database? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
