MOST FREQUENTLY ASKED SQL INTERVIEW QUESTIONS AND ANSWER
Q1 What is the difference between the “DELETE” and “TRUNCATE” commands? 1.The DELETE command is used to remove rows from a table based on a WHEREcondition whereas TRUNCATE removes all rows from a table.2. So we can use a where clause with DELETE to filter and delete specific recordswhereas we cannot use a Where clause …
MOST FREQUENTLY ASKED SQL INTERVIEW QUESTIONS AND ANSWER Read More »