Oracle
1Z0-061 · Question #311
1Z0-061 Question #311: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #311. The question stem and answer options stay visible for context.
Question
Consider these three statements: create view v1 as select department_id,department_name,last_name from departments join employees using (department_id); select department_name,last_name from v1 where department_id=20; select d.department_name,e.last_name from departments d, employees ewhere d.department_id=e.department_id and d.department_id=20; The first query will be quicker than the second because (choose the best answer):
Options
- AThe view has already done the work of joining the tables.
- BThe view uses ISO standard join syntax, which is faster than the Oracle join syntax used in the
- CThe view is precompiled, so the first query requires less dynamic compilation than the second
- DSad but true. Views do not help performance.
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 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.