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

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

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

How many tables may be included with a join?

• 1]

  One

• 2]

  Two

• 3]

  Three

• 4]

  All of the mentioned

How many join types in join condition:

• 1]

  2

• 2]

  3

• 3]

  4

• 4]

  5

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

• 1]

  Join

• 2]

  Selection

• 3]

  Union

• 4]

  Cross product