Chapter 9: Structured Query Language (SQL)
1 / 50
Clause executes last?
2 / 50
Subquery is:
3 / 50
IN operator checks:
4 / 50
BETWEEN used for:
5 / 50
IS NULL used to:
6 / 50
NULL means:
7 / 50
ORDER BY default:
8 / 50
LIMIT used to:
9 / 50
Alias created using:
10 / 50
DISTINCT removes:
11 / 50
Cartesian product occurs in:
12 / 50
Join uses ON clause?
13 / 50
Foreign key refers to:
14 / 50
Composite key is:
15 / 50
Primary key can have:
16 / 50
Self join is:
17 / 50
FULL JOIN returns:
18 / 50
RIGHT JOIN returns:
19 / 50
LEFT JOIN returns:
20 / 50
INNER JOIN returns:
21 / 50
_ wildcard:
22 / 50
% wildcard:
23 / 50
LIKE used for:
24 / 50
Difference WHERE vs HAVING:
25 / 50
HAVING used with:
26 / 50
MIN() returns:
27 / 50
MAX() returns:
28 / 50
AVG() calculates:
29 / 50
SUM() used for:
30 / 50
COUNT() returns:
31 / 50
Deletes all rows keeps table?
32 / 50
UNIQUE ensures:
33 / 50
DEFAULT provides:
34 / 50
NOT NULL means:
35 / 50
Foreign key used for?
36 / 50
Primary key is:
37 / 50
Creates table?
38 / 50
CHAR stores?
39 / 50
VARCHAR used for?
40 / 50
Stores numbers?
41 / 50
Deletes records?
42 / 50
Modifies existing data?
43 / 50
Used with aggregate functions?
44 / 50
Sorts data?
45 / 50
Adds new data?
46 / 50
SQL is:
47 / 50
Clause to filter records?
48 / 50
Command to remove a table?
49 / 50
Which is used to retrieve data?
50 / 50
SQL stands for:
Your score is
The average score is 0%
