Exam 1z0-071 topic 1 question 169 discussion

D: returns 0 if the Quantity is less than 10, not just some tens.

B. SELECT * FROM order_items WHERE MOD(quantity, 10) = 0; This is correct. The MOD function returns the remainder of a division operation. If MOD(quantity, 10) equals 0, it means that quantity is evenly divisible by 10, i.e., quantity is a multiple of 10. C. SELECT * FROM order_items WHERE FLOOR(quantity / 10) = TRUNC(quantity / 10); This is correct. FLOOR(quantity / 10) and TRUNC(quantity / 10) will both give the same result when quantity is a multiple of 10, because the division of a multiple of 10 by 10 will always be an integer. This ensures that quantity is a multiple of 10.

D is correct for sure, I think that B has a typo.

B has a typo , should be = 0

BD is correct

C, D IS CORRECT