Examveda

What will be the output of the following SQL statement?
SELECT *
 FROM person;

A. Show all rows and columns of table "person"

B. Show all rows of table "person"

C. Show all columns of table "person"

D. None of the mentioned

Answer: Option A

Solution (By Examveda Team)

This question is about how to retrieve data from a table in MySQL.

The statement SELECT * FROM person; is used to get information from a table called "person".

Let's break it down:

* SELECT *: This part tells MySQL to select all the data (* means all) from the table.
* FROM person: This part tells MySQL to select the data from the table named "person".

So, the statement will show all the data from all the columns in the table "person."

Therefore, the correct answer is Option A: Show all rows and columns of table "person"

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous