Home » Other » Training & Certification » Query on outer join (Oracle 9i, Windows)
icon6.gif  Query on outer join [message #321367] Tue, 20 May 2008 01:30
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member


Hi,

Regarding Outer Joins:

Which three are true regarding the use of outer joins? (Choose three.)

A. You cannot use IN operator in a condition that involves an outerjoin.

B. You use (+) on both sides of the WHERE condition to perform an outerjoin.

C. You use (*) on both sides of the WHERE condition to perform an outerjoin.

D. You use an outerjoin to see only the rows that do not meet the join condition.

E. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.

F. You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.


Answer: D, E, F

But the answers I think should be:

Answer: A, E, F

As the statement in D: You use an outerjoin to see only the rows that do not meet the join condition.

It is not only the unmatched rows but the matched rows are also the resulting rows.

Thanks,
Priya.

Previous Topic: backup strategy
Next Topic: buy evouchers online and make exam in Prometric Center
Goto Forum:
  


Current Time: Fri Apr 18 01:41:30 CDT 2014

Total time taken to generate the page: 0.14054 seconds