SQL joins

Question 1

A SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.

Answer

true

Question 2

The most common kind of SQL JOIN in an INNER JOIN.

Answer

true

Question 3

When two tables are joined, it it done by referring to their PRIMARY KEYS and FOREIGN KEYS

Answer

true

Question 4

When you call a JOIN statement, you must also include the following command after the second table is defined.

FROM table_1 JOIN table_2 "----"

Accepted Answer

ON

Answer

WITH

Answer

TOGETHER WITH

Answer

ALONG WITH

Question 5

To join a movies table and a genres table based on the genres id, what syntax would you use?

[blank_start]SELECT[blank_end] movies.title, genres.title 
[blank_start]FROM[blank_end] movies [blank_start]JOIN[blank_end] genres [blank_start]ON[blank_end] movies.genres_id [blank_start]=[blank_end] genres.id;

Accepted Answer

SELECT

Accepted Answer

FROM

Accepted Answer

JOIN

Accepted Answer

ON

Accepted Answer

=

Question 6

It is possible to alter the names of the columns using the AS statement.

SELECT movies.name AS movie, genres.name AS genre

Answer

true

Question 7

Is the following JOIN statement correct?

SELECT movies.title AS movie, genres.name AS genre
FROM movies JOIN genres ON movies.genre_id,  genres.id LIMIT 10;

Answer

true

Question 8

If you wanted to add a more specific filter to the following JOIN statement, what command would you use?

SELECT movies.title, genres.name
FROM movies JOIN genres ON movies.genre_id = genres.id
[blank_start]WHERE[blank_end] genres.name = 'Horror' LIMIT 10;

Accepted Answer

WHERE

Question 9

You are limited to only joining two tables

Answer

true

Question 10

To join more than one table you have to create another JOIN statement that refers back to  the original table

SELECT movies.title AS movie, genres.name AS genre, studios.name AS studio
FROM movies
  JOIN genres ON movies.genre_id = genres.id
  JOIN studios ON movies.studio_id = studios.id
LIMIT 10;

Answer

true

Question 11

When checking to see if a value in a SQL statement is empty, we use what command?

Accepted Answer

NULL

Answer

EMPTY

Answer

VOID

Answer

MISSING

Question 12

when checking to see if a value is NULL, we have to use an "IS" statement instead of an = sign

Answer

true

SQL joins

Preguntas del test (12)

Información

Escríbenos

¿Qué te parece el nuevo diseño?