Exam Questions
32 sets · 251 questions — organized by topic.
- Q1.
Explain What is MySQL? and illustrate with a short MySQL program.
Hint: Aim for a definition + runnable snippet + sample output.
5 pts - Q2.
Write a MySQL program that demonstrates History of MySQL in practice.
Hint: Include input, logic, and commented output lines.
8 pts - Q3.
Compare Features of MySQL 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 Advantages of MySQL, 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 Applications of MySQL scale for 1 million users?
Hint: Think about time/space complexity, caching, batching.
5 pts - Q6.
Explain MySQL vs SQL and illustrate with a short MySQL program.
Hint: Aim for a definition + runnable snippet + sample output.
5 pts - Q7.
Write a MySQL program that demonstrates DBMS vs RDBMS in practice.
Hint: Include input, logic, and commented output lines.
8 pts - Q8.
Compare MySQL Architecture 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