ORACLE-joins

Question

ORACLE supports:

(A) inner join and outer join only

(B) outer join and semi join only

(C) inner join, outer join , semi join only

(D) inner join, outer join, semi join and anti join

Answer 1

Oracle Supports

1- inner join,

2-outer join,

3-semi join 

4-anti join

https://docs.oracle.com/cd/B28359_01/server.111/b28286/queries006.htm#SQLRF52338

so option D

Comments

Oracle support all of the above joins i.e. Inner join, outer join, semi join and anti join.

So answer is options D

Answer 2

Oracle support all of the above joins i.e. Inner join, outer join, semi join and anti join.

So answer is options D