DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

What is the difference among “dropping a table”,

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

126. What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table.

DROP…..It will drop the table completely.(all values& table structure)
TRUNCATE……All the values in the table will be deleted.(the structure wont be)
DELETE….Can be use to delete particular row or all values i table.(structure wont be deleted)

(Continued on next question...)

Other Job Interview Questions