SQL – Using the Group Functions Questions 1. Which of the following is NOT a GROUP BY function? MAX MIN NVL AVG Answer: C. NVL is a general function used to provide alternate value to the NULL values. The functions MAX, MIN and AVG can be used as GROUP BY functions. 2. Which of the […]
Category Archives: sql Certificate
SQL Certificate – Useful Resources The following resources contain additional information on SQL Certificate. Please use them to get more in-depth knowledge on this topic. Useful Links on SQL Certificate − Database Language SQL (Proposed revised text of DIS 9075) July 1992 (Second Informal Review Draft). − DB2 resource for SQL users. − Oracle SQL […]
SQL Certificate Mock Exams 1. What will be the outcome of the following query? SELECT ROUND(144.23,-1) FROM dual; 140 144 150 100 2.In which of the following cases, parenthesis should be specified? When INTERSECT is used with other set operators When UNION is used with UNION ALL When MINUS is used for the queries None […]