What will be the output of the following SQL statement?
SELECT * FROM person
WHERE person_id=1;
SELECT * FROM person
WHERE person_id=1;
A. Show all columns but only those rows which belongs to person_id=1
B. Show all columns and rows
C. Shows only columns person_id
D. None of the mentioned
Answer: Option A
Solution(By Examveda Team)
The given SQL statement is a SELECT query that retrieves data from the "person" table where the "person_id" column equals 1. The WHERE clause filters the rows to only those where person_id=1. Therefore, the query will return all columns, but only the rows where person_id=1. Hence, Option A is correct.Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion