← Lab slides

RDBMS · CSE2132 Lab

Lab End-Term Exam

Thirty-two practical sets on Labs 1–11, split into two batches. Each set has 7 SQL questions (20 marks, 25 minutes) and 3 write-up questions (10 marks). The question sets are released here on the day of the exam. Download the zip of your batch, then work on the set number your instructor gives you. Everything works offline in MySQL Workbench.

Batch 1

Sets 1–15

Batch 2

Sets 16–32

How to attempt your set

  1. Unzip the batch and open only the file for your set number in MySQL Workbench (File → Open SQL Script).
  2. Select the SETUP STARTS … SETUP ENDS block and run it once (Ctrl+Shift+Enter). It builds your database with its data and creates the MySQL user for Q7, so run it as root.
  3. Answer Q1–Q7 under their -- Q n lines, one statement at a time (Ctrl+Enter). You have 25 minutes for the practical.
  4. Write the answers to the write-up questions W1–W3 on the answer sheet, unless your instructor tells you otherwise.
  5. Save your file, then hand it in from the Submission tab. Needs MySQL Server 8.0.16 or newer. If something goes wrong, re-run the SETUP block to get the original data back.

Submit your work

When you have finished your set, upload your files through the Google Form below. Upload both files.

File 1Solution fileYour saved .sql file with your answer under every -- Q n line.
File 2Output fileThe output of your queries: screenshots of the result grids (one per question, including the SELECT on your view and SHOW GRANTS) or a PDF of them.
Open the submission form →
  1. Open the form and sign in with your university Google account if it asks.
  2. Enter your name, registration number and set number exactly as your instructor assigned it.
  3. Attach the solution file and the output file, then press Submit.

Submit before the time your instructor announces. Only the solution and output files for your own set are needed - do not upload the whole zip.