CLASS TEST FOR CLASS XII C&D

 Link for class test start from here

1.    SELECT DATE('2004-12-21 01:02:03');  

2.    SELECT DATE('2008-05-17 11:31:31') as required_DATE;'20

3.    SELECT MONTHNAME('2009-05-18');

4.    SELECT ROUND(4.43);

SELECT POW(3, 2);

5.    SELECT MOD(17,5);

6.    SELECT ABS(-5);

7.    SELECT INSTR('myteststring','st');

8.    SELECT SUBSTR('w3resource',4,3);

9.    SELECT RIGHT('w3resource',8);04-12-21 01:02:03'); 

Explain these question

1. What is single line and multiple line function?
2. What is difference between where and having clause?
3. What is  Aggregate function ? explain with suitable example  ?