Select the right syntax to delete all the rows from the table employee_Details but retain the table :

  1. delete * from employee_Details

  2. delete from employee_Details

  3. truncate table employee_Details

  4. drop table employee_Details


Correct Option: B,C

Find more quizzes: