What will be the order of the data being sorted after the execution of given SQL query?

SELECT * FROM STUDENT ORDER BY ROLL_NO;

1. Custom Sort
2. Descending
3. Ascending
4. None of these

Which values will not be considered by SQL while executing the following statement?

SELECT COUNT(column name) FROM DEPARTMENT;

1. Numeric value
2. Text value
3. Null value
4. Date value

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