DEMO - SQL Fundamentals
Recap Quiz
Made by @beamishc
0
0
1
303
1: What does this SQL query do?
30s
Creates a new table with a name column
Filters rows where name is not NULL
Selects only the name column from people
Returns the count of names in the table
2: WHERE is the SQL clause used to filter rows.
30s
True
False
3: What does DISTINCT do in SQL?
30s
Returns rows where all columns are unique
Returns only unique values in selected columns
Filters only rows that appear once in the table
Removes NULLs from the output
4: Which SQL statement adds new rows to a table?
30s
INSERT
INSERT INTO
INSERT SELECT
APPEND
5: What is the written order for the following clauses in a query?
60s
SELECT
FROM
WHERE
ORDER BY
6: What is a Primary Key?
30s
To ensure values are never NULL
To uniquely identify each row in a table
To optimize join performance
To define sort order
7: What does this query return?
30s
All columns for all rows with name exactly “Clara”
Only the name column for Clara
All rows that contain “Clara” in any column
All names starting with “C”
8: What does CREATE TABLE do?
30s
Inserts new rows into an existing table
Creates a new database
Defines a new table structure
Adds a column to a table
9: What does ORDER BY 2 mean?
30s
Sort using the column in the second position of SELECT
Use the second-largest column
Sort by 2 columns
Return 2 rows
10: What does this query do?
30s