SQL Scalar Function
1.What is a scalar function in SQL?
-
A. Returns multiple rows
-
B. Returns one value per row
-
C. Only works with integers
-
D. Used for grouping
Returns one value per row
Returns one value per row
2.Which of the following is NOT a scalar function?
-
A. UPPER()
-
B. AVG()
-
C. LENGTH()
-
D. ROUND()
AVG()
AVG()
3.What does this return?
SELECT LENGTH('Ashutosh');
-
A. 8
-
B. 9
-
C. 10
-
D. Error
9
9
4.Which scalar function capitalizes all letters in a string?
-
A. LOWER()
-
B. PROPER()
-
C. UPPER()
-
D. INITCAP()
UPPER()
UPPER()
5.What does the COALESCE function do?
-
A. Returns total rows
-
B. Returns first non-null value
-
C. Capitalizes input
-
D. Converts to float
Returns first non-null value
Returns first non-null value