Question

Peter wants to query to determine the names of the students who scored more than 95 in the internal assessment test. which function should he use in the query? a. abs(x) b. floor(x) c. ceiling(x) d. mod(x,y)

Answer 1

Peter should use the ceiling(x) function in the query to determine the names of the students who scored more than 95 in the internal assessment test.

Step-by-step explanation:

In order to query for the names of the students who scored more than 95 in the internal assessment test, Peter should use the ceiling(x) function in the query. The ceiling(x) function rounds up a number to the nearest whole number.

For example, if Peter has a table with the names of the students and their scores, he can use the ceiling(x) function to round up the scores. Then, he can filter out the students whose scores are greater than 95 using the WHERE clause in the query. This will give him the names of the students who scored more than 95.