Which among the following is not a "query clause"?

Solution (By Examveda Team)

This question is asking about the parts of a SQL query, which are like instructions telling the database what to do.

Let's break down the options:
Option A: WHERE - This clause is used to filter data. It tells the database to only return rows that meet specific conditions.
Option B: MODIFY - This is a command used to change the definition of a column in a table. It's not a clause within a SELECT query.
Option C: ALTER - Similar to MODIFY, this is a command used to change the structure of a table. It's not a clause within a SELECT query.
Option D: FROM - This clause specifies which table(s) the data will be retrieved from. It's a core part of any SELECT query.

Therefore, the correct answer is Option B: MODIFY and Option C: ALTER because they are not used within a SELECT query as clauses. They are commands used to change the database schema.

Here's a simple way to think about it: Imagine you're asking the database for information. The "WHERE" clause is like saying "only show me the data that matches these criteria," the "FROM" clause tells the database which table to look in, but "MODIFY" and "ALTER" are like telling the database to change the structure of the table itself, not to retrieve data.