SQL Scalar Function
6.ROUND(123.456, 2) will return:
-
A. 123.45
-
B. 123.46
-
C. 123.5
-
D. 123
123.46
123.46
7.Output of this?
SELECT LOWER('HELLO SQL');
-
A. hello sql
-
B. HELLO SQL
-
C. Hello Sql
-
D. Error
hello sql
hello sql
8.What does this return?
SELECT ROUND(99.999, 1);
-
A. 100.0
-
B. 99.9
-
C. 99.99
-
D. 100
100.0
100.0
9.What will this return?
SELECT COALESCE(NULL, NULL, 'India');
-
A. NULL
-
B. India
-
C. Error
-
D. 0
India
India
10.Output of this query?
SELECT LENGTH(NULL);
-
A. 0
-
B. NULL
-
C. Error
-
D. Infinite
NULL
NULL