SQL SELECT Statement Syntax Fundamentals

Submit

3. Which clause is used to group rows based on column values before applying aggregate functions?

ORDER BY

GROUP BY

HAVING

WHERE

4. True or False: The asterisk () in SELECT FROM table retrieves only primary key columns.

True

False

Submit

6. Which keyword would you use to count the number of rows returned by a SELECT statement?

COUNT()

SUM()

AVERAGE()

TOTAL()

7. In a SELECT statement, the ORDER BY clause can sort results in which directions?

Only ascending (ASC)

Only descending (DESC)

Both ascending (ASC) and descending (DESC)

Only alphabetical order

8. What does the LIKE operator do in a WHERE clause?

Finds exact matches only

Performs pattern matching on text

Checks if a value is null

Compares two numbers

9. True or False: You can select columns from multiple tables in a single SELECT statement.

True

False

10. Which logical operator allows you to specify multiple conditions in a WHERE clause where all must be true?

OR

AND

NOT

IF

11. What is the primary purpose of a SELECT statement in SQL?

To retrieve data from one or more database tables

To modify existing data in a table

To delete records from a database

To create a new database table

12. In SQL, which comparison operator is used to find values not equal to a specified value?

==

=>

~=

13. What does the DISTINCT keyword do in a SELECT statement?

Removes duplicate rows from results

Sorts data in ascending order

Limits the number of rows returned

Joins multiple tables together

14. True or False: A SELECT statement must always include a WHERE clause.

True

False

15. Which clause would you use to sort the results of a SELECT statement?

SORT BY

ORDER BY

GROUP BY

ARRANGE BY

Submit

17. To retrieve all columns from a table, which symbol do you use in the SELECT clause?

#

@

*

&

18. What is the correct basic syntax for a SELECT statement?

SELECT FROM WHERE table column

SELECT column FROM table WHERE condition

FROM table SELECT column WHERE

WHERE condition SELECT FROM table

19. In a SELECT statement, what does the FROM clause specify?

The columns to display

The table or tables from which to retrieve data

The conditions for filtering rows

The order of results

20. Which keyword is used to specify which columns to retrieve in a SELECT statement?

FROM

WHERE

SELECT

ORDER BY

ITF+ SELECT Statement Basic Syntax Quiz

1. The LIMIT clause in a SELECT statement is used to ____.

2.

What first name or nickname would you like us to use?

2. In SQL, the IN operator is used to ____.

3. Which clause is used to group rows based on column values before applying aggregate functions?

4. True or False: The asterisk () in SELECT FROM table retrieves only primary key columns.

5. An alias in a SELECT statement allows you to ____.

6. Which keyword would you use to count the number of rows returned by a SELECT statement?

7. In a SELECT statement, the ORDER BY clause can sort results in which directions?

8. What does the LIKE operator do in a WHERE clause?

9. True or False: You can select columns from multiple tables in a single SELECT statement.

10. Which logical operator allows you to specify multiple conditions in a WHERE clause where all must be true?

11. What is the primary purpose of a SELECT statement in SQL?

12. In SQL, which comparison operator is used to find values not equal to a specified value?

13. What does the DISTINCT keyword do in a SELECT statement?

14. True or False: A SELECT statement must always include a WHERE clause.

15. Which clause would you use to sort the results of a SELECT statement?

16. The WHERE clause in a SELECT statement is used to ____.

17. To retrieve all columns from a table, which symbol do you use in the SELECT clause?

18. What is the correct basic syntax for a SELECT statement?

19. In a SELECT statement, what does the FROM clause specify?

20. Which keyword is used to specify which columns to retrieve in a SELECT statement?

ITF+ SELECT Statement Basic Syntax Quiz

1. The LIMIT clause in a SELECT statement is used to ____.

2.

What first name or nickname would you like us to use?

2. In SQL, the IN operator is used to ____.

3. Which clause is used to group rows based on column values before applying aggregate functions?

4. True or False: The asterisk (*) in SELECT * FROM table retrieves only primary key columns.

5. An alias in a SELECT statement allows you to ____.

6. Which keyword would you use to count the number of rows returned by a SELECT statement?

7. In a SELECT statement, the ORDER BY clause can sort results in which directions?

8. What does the LIKE operator do in a WHERE clause?

9. True or False: You can select columns from multiple tables in a single SELECT statement.

10. Which logical operator allows you to specify multiple conditions in a WHERE clause where all must be true?

11. What is the primary purpose of a SELECT statement in SQL?

12. In SQL, which comparison operator is used to find values not equal to a specified value?

13. What does the DISTINCT keyword do in a SELECT statement?

14. True or False: A SELECT statement must always include a WHERE clause.

15. Which clause would you use to sort the results of a SELECT statement?

16. The WHERE clause in a SELECT statement is used to ____.

17. To retrieve all columns from a table, which symbol do you use in the SELECT clause?

18. What is the correct basic syntax for a SELECT statement?

19. In a SELECT statement, what does the FROM clause specify?

20. Which keyword is used to specify which columns to retrieve in a SELECT statement?

4. True or False: The asterisk () in SELECT FROM table retrieves only primary key columns.