BitWithBite
SQL Worksheet
🗃 Procedures, Functions & Transactions
SCORE___ / 20
NameClassDate
After this worksheet you can
Wrap logic in stored proceduresUse transactionsCOMMIT vs ROLLBACKACID basics📚 Quick Recap
The final lesson. Stored procedures and functions let you encapsulate SQL logic on the server. Transactions ensure multi-step operations either fully succeed or fully roll back. Triggers automate actions on data changes.
🧠 Section A · Concept Check ● BEGINNER 4 × 1 = 4
1A stored procedure is:
2Start a transaction with:
3Undo an unfinished transaction with:
4The A in ACID is:
🧮 Section B · Problem Solving ● INTERMEDIATE 2 + 3×3 = 11
5Make changes permanent with .
6A transaction is all-or-.
7Sketch a money-transfer transaction.
8When does ROLLBACK save you?
9Procedure vs function in one line?
🚀 Section C · Challenge ● CHALLENGE 5
10Name the four ACID properties.
💭 Reflection — the most useful thing I learned:
A ___/4 B ___/11 C ___/5 Total ___/20
Teacher's Signature
Parent's Signature
✂ answer key — fold or cut before handing out
1-A 2-A 3-A 4-A | 5 COMMIT 6 nothing 7 = START TRANSACTION; UPDATE a SET bal=bal-100...; UPDATE b SET bal=bal+100...; COMMIT; 8 = If any step fails midway - nothing is applied 9 = Function returns a value in queries; procedure performs actions when CALLed | 10 = Atomicity, Consistency, Isolation, Durability