Question

Truncate command in SQL

A TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, indexes, and so on remain. Correct Answer Incorrect Answer
B The working of truncate command is similar to the working of Delete command without a where clause. Correct Answer Incorrect Answer
C TRUNCATE TABLE tablename; Correct Answer Incorrect Answer
D Both 1 and 2 are correct Correct Answer Incorrect Answer
E All are correct Correct Answer Incorrect Answer

Solution

The correct answer is E

Practice Next
×
×