SQLite - 8 - Filtering Data with WHERE MCQ

SQLite – Filtering Data with WHERE

1 / 22

1. In SQLite, which SQL clause is used to filter rows based on a specified condition?

WHERE

HAVING

FILTER

SELECT

2 / 22

2. What is the primary purpose of the WHERE clause in a SELECT statement in SQLite?

To filter rows based on a condition

To specify the columns to be retrieved

To order the result set

To group rows by one or more columns

3 / 22

3. Which SQL operator is used to specify multiple conditions in the WHERE clause of a SELECT statement?

NOT

XOR

AND

4 / 22

4. How do you specify that a column should be included in the result set in a SELECT statement?

By using the COLUMN keyword

By using the INCLUDE keyword

By listing the column name after SELECT

By using the FROM keyword

5 / 22

5. What happens if you use the * wildcard in the SELECT clause of a SELECT statement in SQLite?

It retrieves all columns from the table

It retrieves the first column only

It retrieves all rows from the table

It retrieves the first row only

6 / 22

6. In SQLite, how do you specify the table from which you want to retrieve data in a SELECT statement?

By using the TABLE keyword

By using the SELECT keyword

By using the WHERE keyword

By using the FROM keyword

7 / 22

7. Which SQL clause is used to sort the result set in ascending or descending order in SQLite?

ORDER

SORT

GROUP

LIMIT

8 / 22

8. What is the default sorting order when using the ORDER BY clause in SQLite?

Random

Descending

Alphabetical

Ascending

9 / 22

9. Which SQL clause is used to limit the number of rows returned in the result set in SQLite?

FETCH

OFFSET

RESTRICT

LIMIT

10 / 22

10. In SQLite, how do you specify that you want to retrieve distinct values in a SELECT statement?

By using the DISTINCT VALUES keyword

By using the UNIQUE keyword

By using the UNIQUE VALUES keyword

By using the DISTINCT keyword

11 / 22

11. What is the purpose of the GROUP BY clause in a SELECT statement in SQLite?

To order the result set

To filter rows based on a condition

To group rows by one or more columns

To select distinct values

12 / 22

12. Which SQL aggregate function is used to count the number of rows in a result set in SQLite?

MAX

COUNT

SUM

AVG

13 / 22

13. What does the HAVING clause do in a SELECT statement in SQLite?

It orders the result set

It specifies the columns to be retrieved

It filters groups based on a condition

It filters rows based on a condition

14 / 22

14. In SQLite, which SQL clause is used to combine rows from two or more tables into a single result set?

UNION

MERGE

COMBINE

JOIN

15 / 22

15. What is the purpose of the ON clause in a JOIN statement in SQLite?

To specify the join condition

To filter rows based on a condition

To group rows by one or more columns

To order the result set

16 / 22

16. In SQLite, what is the primary difference between INNER JOIN and LEFT JOIN?

LEFT JOIN returns only matching rows

INNER JOIN returns all rows from both tables

INNER JOIN returns only matching rows

LEFT JOIN returns all rows from the left table

17 / 22

17. Which SQL clause is used to rename columns in the result set in SQLite?

RENAME

COLUMN AS

RENAME AS

18 / 22

18. How do you use the AS keyword to rename a column in a SELECT statement in SQLite?

SELECT new_name = column_name

SELECT column_name AS new_name

SELECT ALTER column_name TO new_name

SELECT RENAME column_name TO new_name

19 / 22

19. Which SQL clause is used to filter rows based on a condition in SQLite?

FILTER

CONDITION

WHERE

SELECT

20 / 22

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

It orders the result set

It specifies the columns to be retrieved

It selects distinct values

It groups rows by one or more columns

21 / 22

21. Which SQL clause is used to combine the result sets of two or more SELECT statements in SQLite?

COMBINE

JOIN

MERGE

UNION

22 / 22

22. What is the primary purpose of the UNION operator in SQLite?

To combine the result sets of two SELECT statements

To order the result set

To merge the data from two tables

To filter rows based on a condition

Your score is

SQLite – 8 – Filtering Data with WHERE MCQ