--:--









Quiz for DISTINCT Keyword

Course: SQL | Subject: SQL | Topic: Grouping and Filtering



Logo

Q1: What does the DISTINCT keyword do in a SELECT query?

Logo

Q2: What does the DISTINCT keyword do in SQL?

Logo

Q3: Which clause is typically used with DISTINCT?

Logo

Q4: Which of the following is correct syntax to retrieve unique department names?

Logo

Q5: Can DISTINCT be used with multiple columns?

Logo

Q6: What is returned by: SELECT DISTINCT city, state FROM customers?

Logo

Q7: Which SQL statement returns unique job titles from employees table?

Logo

Q8: Does DISTINCT eliminate NULLs?

Logo

Q9: What does SELECT DISTINCT salary FROM employees do?

Logo

Q10: How many rows will SELECT DISTINCT department_id FROM employees return if there are 3 unique departments?

Logo

Q11: Which keyword is used to eliminate duplicates in SQL?

Logo

Q12: In SELECT DISTINCT name FROM users WHERE age > 25, what does DISTINCT apply to?

Logo

Q13: What will SELECT DISTINCT COUNT(name) return?

Logo

Q14: Which query returns the number of unique countries from a table?

Logo

Q15: Can DISTINCT be used with aggregate functions?

Logo

Q16: What will SELECT DISTINCT * FROM employees return?

Logo

Q17: Which one is valid to get distinct years from a date column?

Logo

Q18: What will SELECT COUNT(DISTINCT employee_id) do?

Logo

Q19: What does SELECT DISTINCT 1+1 FROM dual return?

Logo

Q20: Which returns total number of distinct salaries?

Logo

Q21: Which query returns distinct first and last name combinations?

Are you ready to start test? Set your time limit