SQL Joins

A_____ is a query that retrieves rows from more than one table or view

• Start

• End

• Join

• All of the above

How many join types in join condition

• 2

• 3

• 4

• 5

Which join refers to join records from the right table that have no matching key in the left table are include in the result set

• Left outer join

• Right outer join

• Full outer join

• None of the above

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

• 28

• 10

• 0

• 35

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

• Outer Join

• Cross Join

• Inner Join

• None of the above

Which of the following statement is TRUE about FULL OUTER JOIN created on two tables Table1 and Table2

• Retrieves all the unmatched rows of Table1

• Retrieves all the unmatched rows of Table2

• Retrieves both matched and unmatched rows of Table1 and Table2

• Retrieves only matched rows of table1 and Table2

Which join is equivalent to Cartesian Product

• INNER JOIN

• OUTER JOIN

• CROSS JOIN

• NATURAL JOIN

To specify a normal join, using the keyword inner is

• Mandatory

• Optional

• Independent

• Free

SQL Views are also known as

• Simple tables

• Virtual tables

• Complex tables

• Actual Tables

Which of the following is also called an INNER JOIN?

• SELF JOIN

• EQUI JOIN

• NON-EQUI JOIN

• None of the above