Examveda

Which Clause is used to select a particular table in Mysql?

A. WHERE

B. SELECT

C. FROM

D. ALTER

Answer: Option C

Solution (By Examveda Team)

This question asks about the part of a MySQL query that tells the database which table you want to get data from.
Think of a query like asking for information. You need to tell the database where to look.
Here's how the options work:
Option A: WHERE - This clause is used to filter data within a table. It's like saying "give me only the rows where the age is 25".
Option B: SELECT - This clause tells the database which columns you want to retrieve from the table. It's like saying "show me the name and age".
Option C: FROM - This is the answer! The FROM clause is used to specify the table you want to work with. It's like saying "look in the 'users' table".
Option D: ALTER - This clause is used to modify the structure of a table, like adding or removing columns. It's not about selecting a table.
So, the correct answer is Option C: FROM.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous