InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What are the TRUNCATE, DELETE and DROP statements? |
|
Answer» DELETE statement is USED to delete rows from a table. DELETE FROM CandidatesWHERE CandidateId > 1000;TRUNCATE COMMAND is used to delete all the rows from the table and free the space containing the table. TRUNCATE TABLE Candidates;DROP command is used to remove an object from the database. If you drop a table, all the rows in the table are deleted and the table structure is removed from the database. DROP TABLE Candidates; Write a SQL statement to wipe a table 'Temporary' from MEMORY. Check Write a SQL QUERY to remove FIRST 1000 records from table 'Temporary' based on 'id'. Check Write a SQL statement to delete the table 'Temporary' while keeping its relations intact. Check |
|