What are the different types of joins?1. Outer join 2. Inner join3. Ri – McqOptions

MCQOPTIONS

1.	What are the different types of joins?1. Outer join 2. Inner join3. Right join 4. Left join5. Full join
A.	1 and 3
B.	4 and 5
C.	3,4 and 5
D.	All of the above
Answer» E.

Discussion

No Comment Found

Related MCQs

From the following statements which of them is/are true about SQL1. All attributes used in the group by clause must appear in the select clause2. An SQL query can contain a having clause only if it has a group by clause3. An SQL query can contain a having clause even if it does not have a group by clause4. Not all attributes used in the group by clause need to appear in the select clause
Consider the following set of relationsEMP ( emp_no,emp_name,dept_no,salary)DEPT (dept_no,dept_name,location)Write SQL query for the following Find all the employees whose departments are located in 'Mumbai' and salary is greater than Rs. 20,000.
Which SQL command is used to insert a row in a table?
What are the different types of joins?1. Outer join 2. Inner join3. Right join 4. Left join5. Full join