Which statement can produce the same output as 'SHOW COLUMNS'?

Solution (By Examveda Team)

This question asks you to find a MySQL command that does the same thing as 'SHOW COLUMNS'.
'SHOW COLUMNS' is used to see the columns (like the name, age, and city in a table about people) within a specific table in your database.

Let's look at the options:

Option A: DESCRIBE
This is the correct answer! 'DESCRIBE' is the command used to get information about the columns in a table. It's basically a shorter way of saying 'SHOW COLUMNS'.

Option B: DISPLAY, Option C: SEE, Option D: GET
These are not valid commands in MySQL for showing table column information. They might be used in other programming languages, but not in MySQL.

So, the answer is Option A: DESCRIBE