READ Free Dumps For Oracle- 1z1-051
Question ID 4936 | Which best describes an inline view? |
Option A | A. a schema object |
Option B | B. a sub query that can contain an ORDER BY clause |
Option C | C. another name for a view that contains group functions |
Option D | D. a sub query that is part of the FROM clause of another query |
Correct Answer | D |
Question ID 4937 | Examine the structure of the EMPLOYEES and DEPARTMENTS tables: |
Option A | A. SELECT last_name, department_name, location_id |
Option B | B. SELECT employees.last_name, departments.department_name, departments.location_id |
Option C | C. SELECT e.last_name, d.department_name, d.location_id |
Option D | D. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D |
Correct Answer | D |