Valid 1z0-071 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-071 Exam! ExamDiscuss.com now offer the newest 1z0-071 exam dumps, the ExamDiscuss.com 1z0-071 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-071 dumps with Test Engine here:
Examine the ORDER _ITEms table: Which two queries return rows where QUANTITY is a multiple of ten?
Correct Answer: B,C
* A: This statement will not work because TRUNC(quantity, -1) will truncate the quantity to zero decimal places when the number is a negative power of ten, which does not guarantee that the quantity is a multiple of ten. * B: This statement is correct. The MOD function returns the remainder of a division. If MOD(quantity, 10) equals zero, it means that quantity is a multiple of ten. * C: This statement is correct. FLOOR(quantity / 10) equals TRUNC(quantity / 10) when quantity is an exact multiple of ten, as FLOOR returns the largest integer less than or equal to a number, and TRUNC will truncate the decimal part. * D: This statement is incorrect because TRUNC(quantity) would remove any decimal places from quantity, and comparing it to quantity / 10 will not guarantee that the quantity is a multiple of ten. * E: This statement is incorrect. ROUND(quantity, 1) will round the quantity to one decimal place, not check if it's a multiple of ten.