Practice: DBMS rapid-fire and SQL drill
60 min · Advanced
This set drills the DBMS module the way a technical round does: fast theory questions, a normalisation task, SQL written against a small schema, and broken queries to repair. Time each part, then use the scoring sheet in the Summary tab to decide what to revise.
Topics in this lesson
- Rapid-fire DBMS round
- Normalise two tables
- Write six interview SQL queries
- Fix wrong queries
- Self-scoring sheet and revision map
Interview questions this lesson answers
- Rapid-fire: Why use a DBMS instead of files?
- Rapid-fire: What is data independence?
- Rapid-fire: Super key vs candidate key?
- Rapid-fire: Primary key vs unique key?
- Rapid-fire: What is a foreign key?
- Rapid-fire: What is a composite key?
- Rapid-fire: How do you map an M:N relationship?
- Rapid-fire: What is a weak entity?
- Rapid-fire: What is a functional dependency?
- Rapid-fire: What is attribute closure used for?
Sign in free to continue this lesson
Create a free account to read every lesson, practise with the exercises and keep track of your progress.