SQL Data Analyst

What is the result of COUNT(*) on a table with 5 rows where 2 rows have NULL in a column?

SQL Data AnalystEasy

Try Now

Which SQL statement is used to retrieve data from a table?

SQL Data AnalystEasy

Try Now

What does a LEFT JOIN return that an INNER JOIN does not?

SQL Data AnalystEasy

Try Now

What is the purpose of GROUP BY in SQL?

SQL Data AnalystEasy

Try Now

Which operator checks if a value falls within a range inclusively?

SQL Data AnalystEasy

Try Now

What does LIMIT 10 do in a query?

SQL Data AnalystEasy

Try Now

What does AVG(salary) return?

SQL Data AnalystEasy

Try Now

Which wildcard matches any sequence of characters in a LIKE pattern?

SQL Data AnalystEasy

Try Now

Which clause filters groups after aggregation?

SQL Data AnalystEasy

Try Now

Which JOIN type returns only rows with matching values in both tables?

SQL Data AnalystEasy

Try Now

What does the IS NULL condition check?

SQL Data AnalystEasy

Try Now

What does ORDER BY salary DESC do?

SQL Data AnalystEasy

Try Now

Which aggregate function returns the number of non-NULL values in a column?

SQL Data AnalystEasy

Try Now

What does SELECT DISTINCT do?

SQL Data AnalystEasy

Try Now

Which SQL clause filters rows before grouping occurs?

SQL Data AnalystEasy

Try Now

Which execution plan operator typically indicates that an index is not being used and a full scan is occurring?

SQL Data AnalystHard

Try Now

In a data warehouse context, what is a degenerate dimension?

SQL Data AnalystHard

Try Now

What is index cardinality and why does it matter for query optimization?

SQL Data AnalystHard

Try Now