Oracle
1Z0-860 · Question #166
1Z0-860 Question #166: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-860 to reveal the answer and full explanation for question #166. The question stem and answer options stay visible for context.
Question
Which Java Persistence query uses the aggregate function correctly, assuming that chairs field is of type int?
Options
- ASELECT ANY(r. chairs) FROM Room r
- BSELECT NEW Integer(MAX(r. chairs)) FROM Room r
- CSELECT r FROM Room r WHERE r.chairs > AVG(r.chairs)
- DSELECT c FROM Chair c WHERE LOCATE (c.type, lazyboy) > -1
Unlock 1Z0-860 to see the answer
You've previewed enough free 1Z0-860 questions. Unlock 1Z0-860 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.