Joins MCQ

This section focuses on the "Joins" in the SQL. These Multiple Choice Questions (mcq) should be practiced to improve the SQL skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.

1.  How many join types in join condition:

A. 2
B. 3
C. 4
D. 5

View Answer


2. Which are the join types in join condition:

A. Cross join
B. Natural join
C. Join with USING clause
D. All of the mentioned

View Answer


3. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

A. Left outer join
B. Right outer join
C. Full outer join
D. None of the above

View Answer


4. Relation R1 has 10 tuples and 5 attributes. Relation R2 has 0 tuples and 7 attributes. When a CROSS JOIN is achieved between R1 and R2, how many tuples would the resultant set have?

A. 28
B. 10
C. 0
D. 35

View Answer


5. Which join is to be used between two tables A and B when the resultant table needs rows from A and B that matches the condition and rows from A that does not match the condition?

A. Outer Join
B. Cross Join
C. Inner Join
D. None of the above

View Answer


6. Which of the following conditions has to be satisfied for INNER JOIN to work?

A. Columns used for joining must have same name
B. Columns used for joining can have same or different name
C. Columns used for joining must have different names
D. Columns used for joining must have different names

View Answer


7. Which join is equivalent to Cartesian Product?

A. INNER JOIN
B. OUTER JOIN
C. CROSS JOIN
D. NATURAL JOIN

View Answer


8. Which of the following statements are False?

A. RIGHT OUTER JOIN is equivalent to LEFT OUTER JOIN if order of tables are reversed
B. FULL OUTER JOIN is same as CROSS JOIN
C. SELF JOIN is a special type of OUTER JOIN
D. Both B and C

View Answer


9. To specify a normal join, using the keyword inner is?

A. Mandatory
B. Optional
C. Independent
D. Free

View Answer


10. Left outer join preserves tuples only in the relation named before

A. Right outer join operation
B. Right inner join operation
C. Left inner join operation
D. Left outer join operation

View Answer






Also check :


Discussion


* You must be logged in to add comment.