The following MySQL query belongs to which condition types?

SELECT fname
FROM person
WHERE title=’TELLER’;

Solution(By Examveda Team)

Equality condition: This is the correct option. The condition in the query title='TELLER' specifies that the value in the "title" column must be exactly equal to 'TELLER'. It checks for equality between the column value and the specified constant value.
Inequality condition: This option is incorrect. Inequality conditions involve comparisons such as greater than, less than, greater than or equal to, or less than or equal to. The query provided does not involve any inequality comparisons.
Range condition: This option is incorrect. Range conditions involve specifying a range of values for comparison, such as between two constants or greater than a certain value. The provided query does not involve any range comparisons.
All of the mentioned: This option is incorrect. While the query involves an equality condition, it does not involve inequality or range conditions, so selecting "All of the mentioned" would be inaccurate.

Therefore, the correct answer is Option A: Equality condition, as the condition in the query checks for equality between the "title" column and the constant value 'TELLER'.