HomeCode HereReading data quiz Reading data quiz Admin 1 min read Updated November 16, 2026 Nine questions on SELECT, WHERE, ORDER BY, LIMIT, NULL and comparison operators. SQL Reading data quiz 9 questions, instant feedback Question 1 of 9 Which clause chooses the columns a query returns? A SELECT B FROM C WHERE D ORDER BY SELECT lists the columns or expressions to return. FROM names the table they come from. Question 2 of 9 What does SELECT * return? A Only the primary key B Every column of the table C The number of rows D The first row only The asterisk means all columns. It is convenient while exploring and risky in application code, where a schema change can break assumptions. Question 3 of 9 Which operator matches a pattern? A = B LIKE C IN D BETWEEN LIKE compares text against a pattern where % matches any run of characters and _ matches one character. Question 4 of 9 Which clause is evaluated before GROUP BY? A HAVING B ORDER BY C WHERE D LIMIT WHERE filters individual rows before grouping. HAVING filters groups after aggregation. Question 5 of 9 What does ORDER BY price DESC do? A Sorts by price ascending B Sorts by price descending C Removes duplicate prices D Filters prices above zero DESC reverses the default ascending order, so the highest price comes first. Question 6 of 9 Which statement about NULL is correct? A NULL = NULL is true B NULL means zero C NULL is unknown and needs IS NULL D NULL sorts before every value NULL represents an unknown value, so comparisons with = return unknown rather than true. Use IS NULL or IS NOT NULL. Question 7 of 9 What does LIMIT 10 OFFSET 20 return? A Rows 1 to 10 B Ten rows starting from the twenty-first C Twenty rows starting from the tenth D The last ten rows OFFSET skips twenty rows and LIMIT then returns ten. Without ORDER BY the skipped rows are not guaranteed to be stable. Question 8 of 9 Which query finds rows where city is either Pune or Delhi? A WHERE city = 'Pune' AND city = 'Delhi' B WHERE city IN ('Pune', 'Delhi') C WHERE city LIKE 'Pune, Delhi' D WHERE city BETWEEN 'Pune' AND 'Delhi' IN checks membership in a list. Using AND with two different values for the same column matches nothing. Question 9 of 9 Why is ORDER BY needed for reliable pagination? A It speeds up the query B Without it, row order is not guaranteed between runs C It removes duplicates D It is required by LIMIT A database may return rows in any order without ORDER BY, so LIMIT/OFFSET pages can repeat or skip rows. Add a unique tiebreaker such as the id. Check my answers Try again Your answers stay in this browser. Nothing is sent to a server. More quizzes Summarising data quiz 9 questions Joins and changes quiz 9 questions Design and safety quiz 9 questions All quizzes