Exxat Configuration Analyst Interview Questions and Answers

Normal Aptitude Test

Q1. What is Truncate
Ans. 
Truncate is a SQL command used to delete all rows from a table without deleting the table structure.
• Truncate is faster than using the DELETE command because it does not log individual row deletions.

• Truncate resets the identity seed of the table.

• Truncate cannot be rolled back like the DELETE command.

• Truncate is typically used when you want to quickly remove all data from a table.

• Example: TRUNCATE TABLE TableName;
Answered by AI
Add your answer
Q2. SQL related questions
Add your answer