Which of the following functions is used to find the largest value from the given data in MySQL?

1. MAX()
2. MAXIMUM()
3. LARGEST()
4. BIG()

Consider a table named Employees with columns — EName, Age, Salary and Designation. Which SQL statement do we use to find out the total salary given to employees?

1. Select SUM(Salary) From Employees;
2. Select COUNT (*) From Employees;
3. Select FIND (*) From Employees;
4. Select SUM () From Employees;

In SQL, which function is used to extract a date from a date expression?

1. Now()
2. Curdate()
3. Date()
4. Day()

Assertion (A): COUNT() function ignores distinct values.

Reasoning (R): Distinct clause ignores duplicate values.

1. Both A and R are true and R is the correct explanation of A.
2. Both A and R are true but R is not the correct explanation of A.
3. A is true but R is false.
4. A is false but R is true.