1.

In SQL, which of the following is not a data Manipulation Language Commands?(a) Delete(b) Truncate(c) Update(d) CreateI had been asked this question in examination.Question is from DML Command in chapter SQL Basics of Oracle

Answer» <html><body><p>Correct answer is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) <a href="https://interviewquestions.tuteehub.com/tag/truncate-661938" style="font-weight:bold;" target="_blank" title="Click to know more about TRUNCATE">TRUNCATE</a><br/><br/>Explanation: The SQL TRUNCATE TABLE command is used to delete complete data from an existing table.You can also use DROP TABLE command to delete complete table but it would remove complete table structure form the database and you would need to re-create this table once again if you <a href="https://interviewquestions.tuteehub.com/tag/wish-1457925" style="font-weight:bold;" target="_blank" title="Click to know more about WISH">WISH</a> you <a href="https://interviewquestions.tuteehub.com/tag/store-1228239" style="font-weight:bold;" target="_blank" title="Click to know more about STORE">STORE</a> some data.</p></body></html>


Discussion

No Comment Found

Related InterviewSolutions