READ Free Dumps For Oracle- 1z1-051
Question ID 4938 | The PRODUCTS table has these columns: |
Option A | A. The results are not sorted. |
Option B | B. The results are sorted numerically. |
Option C | C. The results are sorted alphabetically. |
Option D | D. The results are sorted numerically and then alphabetically. |
Correct Answer | D |
Question ID 4939 | In which two cases would you use an outer join? (Choose two.) |
Option A | A. The tables being joined have NOT NULL columns. |
Option B | B. The tables being joined have only matched data. |
Option C | C. The columns being joined have NULL values. |
Option D | D. The tables being joined have only unmatched data. |
Option E | E. The tables being joined have both matched and unmatched data. |
Option F | F. Only when the tables have a primary key/foreign key relationship. |
Correct Answer | C,E |