Database MCQS - QUESTION DETAILS
Which statement is used to remove all records from a table in MySQL?
A. DELETE FROM table;
B. REMOVE * FROM table;
C. TRUNCATE TABLE table;
D. DROP TABLE table;

'TRUNCATE TABLE table;' removes all records from a table in MySQL.

Similar Questions

In Oracle, what is the purpose of the INSTR() function?





Which MySQL command is used to retrieve the definition of a table?





What is the purpose of the SQL Server INNER JOIN clause?





Which SQL statement is used to grant specific privileges to a user in MySQL?





What is the purpose of the SQL Server ORDER BY clause?





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





Which SQL Server statement is used to update values in a table based on a condition?





What is the purpose of the Oracle UTL_FILE package?





Which MySQL statement is used to create a unique constraint on a column?





In MySQL, which type of index allows only unique values and nulls are considered distinct?