SQL INNER JOIN – Quiz

For each question below, select the best answer. To select the best answer, click on the circle located on the left of this answer. When all questions are answered, click on the Submit button.

Question 1

With an inner join, we are:
matching information between two or more tables.
selecting non-correlated information from two tables.
selecting information inside one table.

Question 2

Consider the following fragment “from clients as cl inner join salespersons as sa”. In such a query, cl.first_name holds:
the salesperson’s first name.
the client’s first name.
both client’s and salesperson’s first name.

Question 3

Consider the following fragment: “select cl.first_name as clientfirstname,“. In this fragment “clientfirstname” corresponds to :
A column in the table.
A column in the displayed result.
A field in the table.
A table in the database.

Question 4

Which following fragment is correct:
inner join salespersons as sa at cl.salesperson_id = sa.id
inner join salespersons as sa in cl.salesperson_id = sa.id
inner join salespersons as sa where cl.salesperson_id = sa.id
inner join salespersons as sa on cl.salesperson_id = sa.id

Question 5

With an inner join, clients without salesperson are displayed:
True.
False.
It depends.

Question 6

With an inner join, salespersons without client are displayed:
True.
False.
It depends.

Question 7

Can “clients” be a valid alias:
Yes.
No.
It depends.

Question 8

Can you join 3 tables together with inner join:
Yes.
No.

 

 

Once you have completed the quiz, calculated your score and reviewed your answers, I invite you to go to the next lesson: SQL Outer Joins.
 
Share on:


Author:
Last udpated: September 10, 2017
Created: September 2, 2014