select the correct answer.\nclive wants to write a query that will display the names of the students who…

select the correct answer.\nclive 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?\na. power(x,y)\nb. floor(x)\nc. mod(x,y)\nd. ceiling(x)

select the correct answer.\nclive 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?\na. power(x,y)\nb. floor(x)\nc. mod(x,y)\nd. ceiling(x)

Answer

Brief Explanations:

The POWER(x,y) function raises x to the power of y. The FLOOR(x) function returns the largest integer less than or equal to x. The MOD(x,y) function returns the remainder of x divided by y. The CEILING(x) function returns the smallest integer greater than or equal to x. None of these functions are used to filter scores less than 10. However, assuming this is a multiple - choice with incorrect options provided in the context of a query for filtering scores, none of these functions are appropriate for the task. But if we have to choose from the given options, none of them help in directly filtering scores less than 10.

Answer:

None of the above options are correct for the described task.