Database Administrator
SQL questions
12 questions on SQL for database administrators, easiest first.
Easy 11
- Purpose of a primary keyeasy
- INNER JOIN vs LEFT JOINeasy
- DELETE vs TRUNCATEeasy
- Filtering rows where a value is NULLeasy
- COUNT(*) vs COUNT(column)easy
- What a foreign key enforceseasy
- WHERE vs HAVINGeasy
- View vs materialized vieweasy
- UNION vs UNION ALLeasy
- Row order without ORDER BYeasy
- Rejecting bad valueseasy