1.

Which command is used for removing a table and all its data from the database:(a) Create command(b) Drop table command(c) Alter table command(d) All of the MentionedI had been asked this question during an interview for a job.The doubt is from DDL Command in section SQL Basics of Oracle

Answer» <html><body><p>Right answer is (b) Drop table command<br/><br/>For <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a> I <a href="https://interviewquestions.tuteehub.com/tag/would-3285927" style="font-weight:bold;" target="_blank" title="Click to know more about WOULD">WOULD</a> <a href="https://interviewquestions.tuteehub.com/tag/say-1195451" style="font-weight:bold;" target="_blank" title="Click to know more about SAY">SAY</a>: The DROP INDEX <a href="https://interviewquestions.tuteehub.com/tag/statement-16478" style="font-weight:bold;" target="_blank" title="Click to know more about STATEMENT">STATEMENT</a> is used to delete an index in a table.</p></body></html>


Discussion

No Comment Found

Related InterviewSolutions