READ Free Dumps For Oracle- 1z0-007

Question ID 8011	In which two cases would you use an outer join? (Choose two.)
Option A	The tables being joined have NOT NULL columns.
Option B	The tables being joined have only matched data.
Option C	The columns being joined have NULL values.
Option D	The tables being joined have only unmatched data.
Option E	The tables being joined have both matched and unmatched data.
Option F	Only when the tables have a primary key/foreign key relationship.
Correct Answer	CE

Explanation Explanation/Reference: Explanation : You use an outer join to also see rows that do not meet the join condition. Incorrect answer : A meet a join condition B meet a join condition D meet non join condition only

Question ID 8012	In which two cases would you use an outer join? (Choose two.)
Option A	The tables being joined have NOT NULL columns.
Option B	The tables being joined have only matched data.
Option C	The columns being joined have NULL values.
Option D	The tables being joined have only unmatched data.
Option E	The tables being joined have both matched and unmatched data.
Option F	Only when the tables have a primary key/foreign key relationship.
Correct Answer	CE

Explanation Explanation/Reference: Explanation : You use an outer join to also see rows that do not meet the join condition. Incorrect answer : A meet a join condition B meet a join condition D meet non join condition only F does not take into consideration of primary key and foreign key relationship Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 4-17

Previous-Page 1 2. . . 133 134 135 136 137 138 139. . . 160 161 Next-Page

Send email to admin@getfreedumps for new dumps request!!!