Which clause is mandatory with clause "SELECT" in Mysql?
A. FROM
B. WHERE
C. Both FROM and WHERE
D. None of the mentioned
Answer: Option A
Solution (By Examveda Team)
This question is about the parts of a MySQL query that lets you get information from a database.The SELECT clause tells the database what data you want to retrieve.
The FROM clause tells the database which table to look in for the data.
The WHERE clause is optional and filters the data to get only the rows that meet certain conditions.
Since you always need to specify the table to fetch data from, the FROM clause is required with SELECT.
So the correct answer is Option A: FROM.
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