Which of the following statements is/are true about SQL queries?

1. A.

   All attributes present in the SELECT clause without an aggregation function must be present in the GROUP BY clause.

2. B.

   The HAVING clause can be used without a GROUP BY clause.

3. C.

   The degree of a relation is the number of tuples present at an instance of time in the relation.

4. D.

   (SELECT * FROM employee_details WHERE name LIKE '_____%') returns all employee names whose name length is exactly 5.

Attempted by 723 students.