Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 162

Examine the ORDER_ITEMS table:

Which two queries return rows where QUANTITY is a multiple of ten? (Choose two.)

SELECT * FROM order_items WHERE quantity / 10 - TRUNC(quantity

SELECT * FROM order_items WHERE MOD(quantity, 10) - 0;

SELECT * FROM order_items WHERE FLOOR(quantity / 10) = TRUNC(quantity / 10);

SELECT * FROM order_items WHERE quantity = TRUNC(quantity, -1);

SELECT * FROM order_items WHERE quantity = ROUND(quantity, 1);

Correct Answer: C, D

To find rows where QUANTITY is a multiple of ten, we can use mathematical functions to determine this. The query in option C uses the FLOOR and TRUNC functions to verify that dividing QUANTITY by 10 results in an integer, which is accurate for multiples of ten. Similarly, the query in option D compares QUANTITY with the truncated value of QUANTITY at the tens place, which will only be true if QUANTITY is a multiple of ten. Therefore, options C and D are correct.

Discussion

benjamin2023Options: BC

B has a typo , should be = 0

XTIMONOptions: BD

BD is correct

yaya32Option: D

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

IzzicertificacionOptions: CD

C, D IS CORRECT

benjamin2023

C is wrong, it just returns all rows.