Question

Peter want to query a product database to determine products that have the maximum consumption (greater than 100 units in a quarter) among customers of an online shopping portal

Answer 1

B. FLOOR(x)

Step-by-step explanation:

The options are:

A. ABS(x) B. FLOOR(x) C. POWER(x) D. MOD(x,y)

B. FLOOR(x) is the correct option.

In CS and Maths, we have the floor function which is a function that needs input as a real number, and it gives as the output the maximum integer which is equal to or less than what is denoted. And hence, the correct option is the FLOOR(x). And here the value of the x is 100.