Which two statements are true regarding the types of table joins available in Oracle Database 10g? (Choose two.)
A.
You can use the JOIN clause to join only two tables.
B.
You can explicitly provide the join condition with a NATURAL JOIN.
C.
You can use the USING clause to join tables on more than one column.
D.
You can use the ON clause to specify multiple conditions while joining tables.
select emp1.sal from emp1 join emp using( empno, deptno, job);
You cannot explicitly have join condition with NATURAL JOIN
C and D is correct
technically A is correct too. Although you can join multiple tables, each join operation only ever involves two tables.
g
Hi,
Today is my exam, Are these questions still valid?
I choose CD
C, D