SQL

Question 1

(INNER) JOIN

Answer 1

Returns records that have matching values in both tables

Question 2

LEFT (OUTER) JOIN

Answer 2

Returns all records from the left table, and the matched records from the right table

Question 3

RIGHT (OUTER) JOIN

Answer 3

Returns all records from the right table, and the matched records from the left table

Question 4

FULL (OUTER) JOIN

Answer 4

Returns all records when there is a match in either left or right table

Question 5

Difference between inner and outer joins

Answer 5

Inner join requires matching values in both tables, outer only one table

Question 6

Difference between union and join

Answer 6

Blank

Question 7

What is SQL?

Answer 7

Blank

Question 8

What is noSQL?

Answer 8

Blank

Question 9

SQL Order of Operations

Answer 9

Blank

Question 10

GROUP BY

Answer 10

BLANK

Question 11

CASE

Answer 11

BLANK

Question 12

JOIN syntax

Answer 12

BLANK

Question 13

COUNT

Answer 13

BLANK

Question 14

SUM

Answer 14

BLANK

Question 15

MIN/MAX

Answer 15

BLANK

Question 16

AVG

Answer 16

BLANK

Question 17

*

Answer 17

All

Question 18

What is a wildcard?

Answer 18

Represents one or more characters in a string

Question 19

%

Answer 19

Wildcard that represents 0 or more characters

Question 20

WHERE CustomerName LIKE ‘a%’

Answer 20

Finds any values that starts with “a”

Question 21

WHERE CustomerName LIKE ‘%a’

Answer 21

Finds any values that ends with “a”

Question 22

WHERE CustomerName LIKE ‘_r%’

Answer 22

Finds any values that have “r” in the second position

Question 23

WHERE ContactName LIKE ‘a%o’

Answer 23

Finds any values that starts with “a” and ends with “o”

Question 24

_

Answer 24

Wildcard that represents a single character

Question 25

What is a primary key?

Answer 25

Blank

Question 26

What is a foreign key?

Answer 26

Blank

Question 27

What is a nested query?

Answer 27

Blank