Error Message | MCQs

Explanation

Software bug: an error, flaw or fault in computer software that causes it to produce an incorrect or unexpected result.

*********

FIA VU CONSTABLE PAST PAPER 2021

Explanation

• The correct answer is: Dept_id should not be used in group by clause (although this is not the case in the given query, as it uses dept_name)
• The error in the statement is that the ID column is not included in the GROUP BY clause. When using an aggregate function like AVG, all non-aggregated columns in the SELECT clause must be included in the GROUP BY clause.