DBMS Q5

When the related data is stored across multiple tables, JOINs help to…

• 
  combine data from two or more tables in a database

• split data from two or more tables in a database

• 
  extract one table out of another

• remove data from one of the tables

How many tables can be joined by using INNER JOIN clause?

• one

• two

• no more than five

• 
  as many as possible

Choose correct statement

• An Outer Join retrieves all the records in two tables even if there is no counterpart row of one table in another table

• An Inner Join retrieves all the records in two tables even if there is no counterpart row of one table in another table

• An Outer Join is a type of join that combines multiple tables by retrieving records that have matching values in both tables

• An Inner Join is a type of connection that removes all characters, spaces by default, from the end of a string

It is a type of join that combines multiple tables by retrieving records that have matching values in both tables

• Inner Join

• Outer Join

• Full Join

• Natural join

It is a type of join that retrieves all the records in two tables even if there is no counterpart row of one table in another table

• 
  Inner Join

• Outer Join

• Full Join

• Natural join

It is a type of join that creates a new table by joining two tables as a whole. The joined table contains all records from both the tables and fills NULL values for missing matches on either side

• Inner Join

• Outer Join

• Full Join

• Natural join

It is a type of join that creates an implicit join based on the same column names in the joined tables

• Inner Join

• 
  Outer Join

• Full Join

• Natural join

Query in SQL that returns all rows from the right table, even if there are no matches in the left table

• Right Inner Join

• 
  Left Outer Join

• Left Join

• Right Join

It is a type of join that allows you to produce a Cartesian Product of rows in two or more tables

• 
  Natural Join

• 
  Full Join

• Self-Join

• 
  Cross Join

It is typically used to query hierarchical data or to compare rows within the same table

• Natural Join

• 
  Full Join

• Self-Join

• 
  Cross Join