SQL Function 2

Which of the following is not a numeric function ?

Which statements are true about Character Function ?

What will be output of the following

SELECT POWER(2,2), POWER(-2,2), POWER(2,-2) FROM Dual;

What will be output of the following ?

SELECT FLOOR(18.7), FLOOR(-18.7), FLOOR(0) FROM Dual;

What will be output of the following

SELECT TRUNC(12345, -2), TRUNC(12.345,2),TRUNC(12.345,3) FROM Dual;

What will be output of the following ?

SELECT UPPER('BullRaider quiz') my_length FROM Dual;

What will be output of the following ?
SELECT SUBSTR('Bull Raider Quiz',1,3) as quiz from dual;

Which of the following functions show current date only ?

 Which of the following are aggregate functions ?

Which of the following  clause cab be used both SQL and PLSQL statement ?