Module 3 Quiz – Analytics Engineering

Question 1: Which SQL keyword is used to filter rows from a query result? *

A) ORDER BY

B) SELECT

C) WHERE

D) LIMIT

Question 2: How would you limit a query result to show only the first 10 rows? *

A) SELECT TOP 10

B) WHERE ROWNUM = 10

C) FIRST 10

D) LIMIT 10

Question 3: Which SQL function is used to count the number of rows? *

A) COUNT(*)

B) SUM()

C) ROWCOUNT()

D) TOTAL()

Question 4: What clause would you use to filter after aggregation? *

A) WHERE

B) GROUP BY

C) HAVING

D) ORDER BY

Question 5: What kind of join returns only matching records from both tables? *

A) LEFT JOIN

B) RIGHT JOIN

C) OUTER JOIN

D) INNER JOIN

Question 6: What does a subquery in the FROM clause return? *

A) A boolean result

B) A single scalar value

C) A derived table or temporary result set

D) A JSON object

Question 7: What does the SQL CASE statement do? *

A) Performs conditional logic in queries

B) Loops through rows

C) Dynamically selects columns

D) Drops tables

Question 8: What SQL keyword combines the results of two SELECT statements and removes duplicates? *

A) JOIN

B) UNION

C) MERGE

D) UNION ALL

Question 9: What function returns the length of a string in SQL? *

A) CHARCOUNT()

B) LENGTH()

C) STRSIZE()

D) LENCOUNT()

Question 10: Which of the following improves query performance? *

A) Using SELECT *

B) Avoiding indexes

C) Using specific column names instead of *

D) Running queries multiple times