Q627
Which command is used to remove existing tables or database?
A.
DROP TABLE
AnswerB.
DELETE
C.
Either DROP TABLE or DELETE
D.
None of the mentioned
Answer: Option A
Solution
Answer: Option A
Solution:
This question is about removing data from a MySQL database. Let's break down the options:
Option A: DROP TABLE
This command is used to completely remove an entire table from the database. Imagine you have a table called 'students' and you want to get rid of it entirely. You would use the 'DROP TABLE' command.
Option B: DELETE
This command is used to delete rows (individual entries) from a table. If you want to remove a specific student from the 'students' table, you would use the 'DELETE' command.
Option C: Either DROP TABLE or DELETE
This option is incorrect because 'DROP TABLE' removes the entire table, while 'DELETE' removes only specific rows within the table.
Option D: None of the mentioned
This option is incorrect because we already have a command that removes tables: 'DROP TABLE'.
Therefore, the correct answer is Option A: DROP TABLE.
'DROP TABLE' is the command used to remove an entire table from your database.