Question

Clive wants to write a query that will display the names of the students who scored less than 10 in their final exams. Which numerical function should he use in his query?

A.POWER(x,y)


B.FLOOR(x)


C.SQRT(x)


D.MOD(x,y)


E.CEILING(x)

Answer 1

Clive wants to write a query that will display the names of the students who scored less than 10 in their final exams. Which numerical function should he use in his query?

Answer- CEILING(x)

CEILING(x) returns the smallest integer value that is greater than or equal to x

Answer 2

I'd go for FLOOR(x)

The numerical function FLOOR(x) can be used to return the largest integer value that is less than or equal to the numerical expression provided. The numerical function CEILING (x) is the opposite of FLOOR(x) since it gives the smallest integer value that is greater or equal to the numerical expression.