Database MCQS - QUESTION DETAILS
What is the purpose of the Oracle 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 Oracle.

Similar Questions

What is the purpose of the SQL WHERE clause?





Which MySQL data type is used to store a fixed-length string?





What is the purpose of the SQL IN operator?





In MySQL, what is the purpose of the SHOW TABLES statement?





Which SQL statement is used to add a new column to an existing table?





What does the SQL INNER JOIN clause do?





Which command is used to select all columns from a table named "employees"?





What is the purpose of the SQL GROUP BY clause?





What is the purpose of the SQL ORDER BY clause?





Which SQL statement is used to insert new data into a table?