1. What is SELECT ? Junior A. retrieves one or more columns from a table B. sorts the result set by one or more columns, ascending by default C. removes duplicate rows from the result set D. restricts how many rows are returned and skips a number of leading rows
2. Which term means: "retrieves one or more columns from a table"? Junior A. LIMIT / OFFSET B. ORDER BY C. WHERE D. SELECT
3. Which statement is correct? Junior A. SELECT — filters rows based on a condition before any grouping B. SELECT — matches text against a pattern using % (any run) and _ (single char) wildcards C. SELECT — retrieves one or more columns from a table D. SELECT — removes duplicate rows from the result set
4. What is WHERE ? Junior A. restricts how many rows are returned and skips a number of leading rows B. filters rows based on a condition before any grouping C. retrieves one or more columns from a table D. removes duplicate rows from the result set
5. Which term means: "filters rows based on a condition before any grouping"? Junior A. LIMIT / OFFSET B. LIKE C. ORDER BY D. WHERE
6. Which statement is correct? Junior A. WHERE — matches text against a pattern using % (any run) and _ (single char) wildcards B. WHERE — retrieves one or more columns from a table C. WHERE — restricts how many rows are returned and skips a number of leading rows D. WHERE — filters rows based on a condition before any grouping
7. What is ORDER BY ? Junior A. sorts the result set by one or more columns, ascending by default B. matches text against a pattern using % (any run) and _ (single char) wildcards C. retrieves one or more columns from a table D. restricts how many rows are returned and skips a number of leading rows
8. Which term means: "sorts the result set by one or more columns, ascending by default"? Junior A. SELECT B. LIMIT / OFFSET C. ORDER BY D. WHERE
9. Which statement is correct? Junior A. ORDER BY — retrieves one or more columns from a table B. ORDER BY — restricts how many rows are returned and skips a number of leading rows C. ORDER BY — removes duplicate rows from the result set D. ORDER BY — sorts the result set by one or more columns, ascending by default
10. What is DISTINCT ? Junior A. retrieves one or more columns from a table B. restricts how many rows are returned and skips a number of leading rows C. filters rows based on a condition before any grouping D. removes duplicate rows from the result set
11. Which term means: "removes duplicate rows from the result set"? Junior A. DISTINCT B. SELECT C. LIMIT / OFFSET D. ORDER BY
12. Which statement is correct? Junior A. DISTINCT — removes duplicate rows from the result set B. DISTINCT — filters rows based on a condition before any grouping C. DISTINCT — matches text against a pattern using % (any run) and _ (single char) wildcards D. DISTINCT — sorts the result set by one or more columns, ascending by default
13. What is LIMIT / OFFSET ? Mid A. filters rows based on a condition before any grouping B. retrieves one or more columns from a table C. restricts how many rows are returned and skips a number of leading rows D. removes duplicate rows from the result set
14. Which term means: "restricts how many rows are returned and skips a number of leading rows"? Mid A. SELECT B. ORDER BY C. WHERE D. LIMIT / OFFSET
15. Which statement is correct? Mid A. LIMIT / OFFSET — restricts how many rows are returned and skips a number of leading rows B. LIMIT / OFFSET — sorts the result set by one or more columns, ascending by default C. LIMIT / OFFSET — retrieves one or more columns from a table D. LIMIT / OFFSET — filters rows based on a condition before any grouping
16. What is LIKE ? Junior A. sorts the result set by one or more columns, ascending by default B. matches text against a pattern using % (any run) and _ (single char) wildcards C. retrieves one or more columns from a table D. restricts how many rows are returned and skips a number of leading rows
17. Which term means: "matches text against a pattern using % (any run) and _ (single char) wildcards"? Junior A. LIKE B. LIMIT / OFFSET C. WHERE D. ORDER BY
18. Which statement is correct? Junior A. LIKE — removes duplicate rows from the result set B. LIKE — matches text against a pattern using % (any run) and _ (single char) wildcards C. LIKE — filters rows based on a condition before any grouping D. LIKE — restricts how many rows are returned and skips a number of leading rows