Question

Clive wants to write a query that will display the quantity of the raw materials that failed the quality assurance test, scoring less than 2 points on a scale of 1 to 5. 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

Answer:

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.

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

Answer:

B.

FLOOR(x)

Explanation:

hope it will help you