Which clause is used in query to place the condition on groups in MySQL?

1. WHERE
2. HAVING
3. GROUP BY
4. Both (i) & (ii)

If column "Marks" contains the data set {25, 35, 25, 35, 38}, what will be the output after the execution of the given query?

SELECT DISTINCT(MARKS) FROM STUDENTS;

1. 25, 35, 25, 35, 38
2. 25, 25, 35, 35, 38
3. 25, 35, 38
4. 25, 25, 35, 35

What SQL statement do we use to find the total number of records present in the table Product?

1. SELECT * FROM PRODUCT;
2. SELECT COUNT(*) FROM PRODUCT;
3. SELECT FIND(*) FROM PRODUCT;
4. SELECT SUM() FROM PRODUCT;

What SQL statement do we use to display the record of all students whose last name contains 5 letters ending with "A"?

1. SELECT * FROM STUDENTS WHERE LNAME LIKE '_ _ _ _A';
2. SELECT * FROM STUDENTS WHERE LNAME LIKE '_ _ _ _';
3. SELECT * FROM STUDENTS WHERE LNAME LIKE '????A';
4. SELECT * FROM STUDENTS WHERE LNAME LIKE '*A';