Oracle Business Intelligence Foundation Suite 11g Essentials 1z0-591 Question # 22 Topic 3 Discussion
1z0-591 Exam Topic 3 Question 22 Discussion:
Question #: 22
Topic #: 3
One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______.
A.
Multiple SQL queries are performed
B.
Two SQL queries are performed to get data from both tables
C.
A single SQL query is performed to get data from both tables
D.
No SQL queries are performed against the source tables
A single query can be performed accessing data from both tables through a join on the columns in the foreign key relation.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit