Examine the ORDER _ITEms table:Which two queries return rows where QUANTITY is a multiple of...

Oracle 1z0-071 Question Answer

Examine the ORDER _ITEms table:

Which two queries return rows where QUANTITY is a multiple of ten?

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

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 / 10 = TRUNC (quantity);

SELECT” FROM order_ _items WHERE quantity = ROUND (quantity, 1);

1z0-071 PDF/Engine

Get 60% Discount on All Products, Use Coupon: "8w52ceb345"