SQL Join 1

By default Equi-join is same as inner-equi-join .

true

false

Which one is not type of Outer Join ?

Left Outer-join

Right outer-join

Full outer-join

Non of these above

Which type of join retrieves the unmatched rows and matched from the left (1st)table and only matched rows from right(2nd) table ?

Outer join

Right Outet Join

Full Outer Join

Left Outer Join

In Right Outer-Join retrieves the unmatched rows and matched from the LEFT
table and only matched rows from RIGHT table.

true

false

What type of joining we are using here?
SELECT * FROM EMP E INNER JOIN DEPT ON D WHERE E.DEPTNO=D.DEPTNO;

Outer-join

Sami-join

Anti join

Equi-join

Which JOIN is a JOIN operation that creates an implicit join clause for you based on the common columns in the two tables being joined ?

Natural Join

Inner Join

Implicit join

Self join

If you want to select columns that have the same name in both emp and dept table table , which of the among is correct one

select empno,ename,job,dname,loc from emp Common join dept;

select empno,ename,job,dname,loc from emp Self join dept;

select empno,ename,job,dname,loc from emp Natural join dept;

select empno,ename,job,dname,loc from emp Equijoin dept;

SELECT * FROM EMP E1,EMP E2 WHERE E1.JOB=E2.JOB;

What type of joining we are using here ?

Anti-join

Self-join

Equi-join

Non-Equi-Join

Which of the following join is kown as Co-Related-Sub-query ?

sami-join

anti-join

outer-join

equi-join

Cross join jenerally generate cross product between two table. Each row of Table1 ,combined with each rows of Table2.

true

false