SQL Reboot Quiz

What does SQL stand for?

• Structured Query Language
• Sequential Query Logic
• Standard Query List
• Scripting Quick Language

Which clause is used to retrieve data from a table?

• INSERT
• WHERE
• SELECT
• CREATE

You want to select all columns from the table People. Fill in the blank: SELECT (a)   FROM People

Which clause filters rows based on conditions?

• ORDER BY
• WHERE
• FROM
• GROUP BY

What does SELECT DISTINCT do?

• Sorts the data
• Removes duplicates
• Filters rows
• Adds new columns

You want to rename the column name as first_name. Fill in the blank: SELECT name (a)   first_name FROM People

Which operator is used for pattern matching in SQL?

• IN
• AND
• LIKE
• SUM

What does ORDER BY number_of_children DESC do?

• Filters out rows with NULL values
• Sorts rows from fewest to most children
• Sorts rows from most to fewest children
• Groups people by number of children

SELECT * FROM People WHERE name IN ("Louis", "David") — this returns rows where the name is either ______ or ______.

(a)  

Which clause is used to group data before aggregation?

• JOIN
• GROUP BY
• HAVING
• SORT