Exam Questions
38 sets · 298 questions — organized by topic.
- Q1.
Explain What is SQL? and illustrate with a short SQL program.
Hint: Aim for a definition + runnable snippet + sample output.
5 pts - Q2.
Write a SQL program that demonstrates History of SQL in practice.
Hint: Include input, logic, and commented output lines.
8 pts - Q3.
Compare Features of SQL with a related concept and state when each is preferable.
Hint: Build a tiny pros/cons table; give a use-case for each side.
5 pts - Q4.
Debug — given a broken snippet using Applications of SQL, identify the bug and fix it.
Hint: Explain the root cause in one line, then give the corrected code.
7 pts - Q5.
Design question — how would Types of Databases scale for 1 million users?
Hint: Think about time/space complexity, caching, batching.
5 pts - Q6.
Explain Relational Database Concepts and illustrate with a short SQL program.
Hint: Aim for a definition + runnable snippet + sample output.
5 pts - Q7.
Write a SQL program that demonstrates RDBMS vs DBMS in practice.
Hint: Include input, logic, and commented output lines.
8 pts - Q8.
Compare SQL Standards with a related concept and state when each is preferable.
Hint: Build a tiny pros/cons table; give a use-case for each side.
5 pts