Data Engineer Interview Questions
Sql
•
22 questions available
Statistics
Total
22
Easy
5
Medium
8
Hard
9
easy
10
Question: Can a table have multiple primary keys?
Constraints
easy
6
Question: Can a table have multiple UNIQUE constraints?
Constraints
Data Quality
easy
7
Question: When would you choose a UNIQUE constraint over a primary key?
Constraints
Data Quality
easy
4
Question: Explain the difference between WHERE and HAVING clauses. Provide a scenario where you'd need to use HAVING.
Fundamentals
medium
6
Question: How would you identify duplicate rows in a table? What are some ways to remove them?
Data Quality
Fundamentals
medium
16
Question: How flexible are CHECK constraints? Can they reference other columns or tables?
Constraints