Oracle
1Z0-898 · Question #55
1Z0-898 Question #55: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-898 to reveal the answer and full explanation for question #55. The question stem and answer options stay visible for context.
Question
An application has two entities, Department and Employee, and there is a one-to-many relationship between them. The application has the following query: SELECT d FROM Department d LEFT JOIN FETCH d. employees WHERE d.name = : name After receiving the results of the query, the application accesses the returned department's Employee entities stored in the Department.employees collection-valued attribute. All caching has been turned off in the application. Which statement is true?
Options
- AThe database will be accessed once during the query execution phase, and once for each
- BThe database will be accessed once during the query execution phase ONLY.
- CThe database will be accessed once during the query execution phase, and once when the
- DThe database will be accessed once during the query execution phase, once when the
Unlock 1Z0-898 to see the answer
You've previewed enough free 1Z0-898 questions. Unlock 1Z0-898 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.