18 Querying Basics questions from the SQL bank, written for Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd.
Free to start: the 2-minute IT readiness check — six questions and a result.
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
Answer + AI explanation with Pro
2. Which term means: "retrieves one or more columns from a table"?
Junior
A.LIMIT / OFFSET
B.ORDER BY
C.WHERE
D.SELECT
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
5. Which term means: "filters rows based on a condition before any grouping"?
Junior
A.LIMIT / OFFSET
B.LIKE
C.ORDER BY
D.WHERE
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
11. Which term means: "removes duplicate rows from the result set"?
Junior
A.DISTINCT
B.SELECT
C.LIMIT / OFFSET
D.ORDER BY
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
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
Answer + AI explanation with Pro
Free to start
Start with a free readiness check
Sign up free for the 2-minute IT readiness check and a scored result. Answers, explanations and the AI tutor on every Querying Basics question come with Pro.