Completed
Math Functions
Questions From This Challenge
Q1mcq1 mark
What does the SQL function POWER(x, y) return?
The value of x raised to the power y ✓
The value of x multiplied by y
The remainder when x is divided by y
The square root of x
Q2mcq1 mark
What is the value returned by POWER(2, 3)?
6
8 ✓
9
5
Q3mcq1 mark
What is the value returned by POWER(5, 0)?
0
1 ✓
5
25
Q4mcq1 mark
What does the SQL function ROUND() do?
Rounds a number to the nearest integer, or to a specified number of decimal places if given a second argument ✓
Always rounds a number down to the nearest integer
Removes the decimal part of a number without any rounding
Returns the remainder after division
Q5mcq1 mark
What is the value returned by ROUND(15.68)?
15
16 ✓
15.7
15.6
Q6mcq1 mark
What is the value returned by ROUND(15.684, 2)?
15.68 ✓
15.69
15.7
15.6
Q7mcq1 mark
What does the SQL function MOD(x, y) return?
The remainder when x is divided by y ✓
The quotient when x is divided by y
The value of x raised to the power y
The absolute difference between x and y
Q8mcq1 mark
What is the value returned by MOD(17, 5)?
2 ✓
3
5
12
Q9output1 mark
Table Circle(RadiusId INT, Radius INT) has rows (1,2), (2,3), (3,5). What is the result of: SELECT RadiusId, POWER(Radius,2) FROM Circle; (format: RadiusId | value, one row per line)
SELECT RadiusId, POWER(Radius,2) FROM Circle;
Correct output:
1 | 4
2 | 9
3 | 25Q10output1 mark
Table CubeShape(Side INT) has rows (2), (3), (4). What is the result of: SELECT Side, POWER(Side,3) FROM CubeShape; (format: Side | value, one row per line)
SELECT Side, POWER(Side,3) FROM CubeShape;
Correct output:
2 | 8
3 | 27
4 | 64Q11output1 mark
Table Marks(RollNo INT, Score DECIMAL(6,3)) has rows (1,78.456), (2,65.234), (3,89.678). What is the result of: SELECT RollNo, ROUND(Score,1) FROM Marks; (format: RollNo | value, one row per line)
SELECT RollNo, ROUND(Score,1) FROM Marks;
Correct output:
1 | 78.5
2 | 65.2
3 | 89.7Q12output1 mark
Table Numbers(N INT) has rows (10), (15), (23), (8). What is the result of: SELECT N, MOD(N,3) FROM Numbers; (format: N | value, one row per line)
SELECT N, MOD(N,3) FROM Numbers;
Correct output:
10 | 1
15 | 0
23 | 2
8 | 2Q13output1 mark
What is the result of: SELECT POWER(2,10);
SELECT POWER(2,10);
Correct output:
1024Q14output1 mark
What is the result of: SELECT ROUND(45.5), ROUND(45.4); (format: value | value, single row)
SELECT ROUND(45.5), ROUND(45.4);
Correct output:
46 | 45Q15output1 mark
Table Employee(EmpId INT, Bonus DECIMAL(8,3)) has rows (1,1234.567), (2,876.321), (3,999.995). What is the result of: SELECT EmpId, ROUND(Bonus,2) FROM Employee; (format: EmpId | value, one row per line)
SELECT EmpId, ROUND(Bonus,2) FROM Employee;
Correct output:
1 | 1234.57
2 | 876.32
3 | 1000.00