SQL -Structured Query Language - SQL Joins - Joins and its type Quiz

The____condition allows a general predicate over the relations being joined.

• 1]

  On

• 2]

  Using

• 3]

  Set

• 4]

  Where

Which of the join operations do not preserve non-matched tuples?

• 1]

  Left outer join

• 2]

  Right outer join

• 3]

  Inner join

• 4]

  Natural join

SELECT * FROM student JOIN takes USING (ID);

The above query is equivalent to

• 1]

  SELECT *
  FROM student INNER JOIN takes USING (ID);

   

• 2]

  SELECT *
  FROM student OUTER JOIN takes USING (ID);

   

• 3]

  SELECT *
  FROM student LEFT OUTER JOIN takes USING (ID);

   

• 4]

  None of the mentioned

What type of join is needed when you wish to include rows that do not have matching values?

• 1]

  Equi-join

• 2]

  Natural join

• 3]

  Outer join

• 4]

  All of the mentioned

How many tables may be included with a join?

• 1]

  One

• 2]

  Two

• 3]

  Three

• 4]

  All of the mentioned

Which are the join types in join condition:

• 1]

  Cross join

• 2]

  Natural join

• 3]

  Join with USING clause

• 4]

  All of the mentioned

How many join types in join condition:

• 1]

  2

• 2]

  3

• 3]

  4

• 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:

• 1]

  Left outer join

• 2]

  Right outer join

• 3]

  Full outer join

• 4]

  Half outer join

The operation which is not considered a basic operation of relational algebra is

• 1]

  Join

• 2]

  Selection

• 3]

  Union

• 4]

  Cross product

In SQL the statement select * from R, S is equivalent to

• 1]

  Select * from R natural join S

• 2]

  Select * from R cross join S

• 3]

  Select * from R union join S

• 4]

  Select * from R inner join