Database MCQS - QUESTION DETAILS
What is the purpose of the SQL TRUNCATE TABLE statement?
A. Remove specific records
B. Remove all records and reset auto-increment
C. Remove duplicate records
D. Remove NULL values

'TRUNCATE TABLE' removes all records and resets the auto-increment in MySQL.

Similar Questions

What is the purpose of the Oracle SYS_GUID() function?





What is the purpose of the SQL LEFT JOIN clause?





In MySQL, which function is used to concatenate two or more strings?





In Oracle, what is the purpose of the BETWEEN operator?





Which MySQL statement is used to grant all privileges to a user?





Which SQL statement is used to change the value of an existing record in a table?





Which SQL function is used to find the highest value in a column?





Which MySQL clause is used to add an index to an existing table?





What is the default storage engine in MySQL?





What is the purpose of the SQL COALESCE() function?