Oracle
1Z0-900 · Question #68
1Z0-900 Question #68: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-900 to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.
Manage Persistence using JPA Entities and BeanValidation
Question
Given the JPQL code fragment: Select pub.title, pub.author, pub.pages FROM Publisher pub Which two clauses do you add to this JPQL query to retrieve only those books with between 500 and 750 total pages? (Choose two.)
Options
- AWHERE MIN(pages) >= 500 AND MAX(pages) <= 750
- BWHERE pub.pages <= 500 OR pub.pages >= 750
- CWHERE pub.pages BETWEEN 500 AND 750
- DWHERE pub.pages <= 500 AND pub.pages >=750
Unlock 1Z0-900 to see the answer
You've previewed enough free 1Z0-900 questions. Unlock 1Z0-900 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.
Topics
#JPQL WHERE clause#BETWEEN operator#Range filtering#JPA queries