Software Engineering › Key terms › Y12 Programming for the Web › CRUD
CRUD
Code pattern Key terms bank Check Y12 Programming for the Web
Definition
Create, Read, Update, Delete: the four basic database operations (INSERT, SELECT, UPDATE, DELETE).
Example
UPDATE Student SET mark = 80 WHERE id = 3Check this one: From the school notes, not named in the syllabus.
Found in: school notes.
Create, Read, Update, Delete (INSERT, SELECT, UPDATE, DELETE).
Where it is used in the test
Syllabus area: Y12 Programming for the Web.
Question types it can appear in
- Multiple choice: Pick the option that matches the definition or example.
- SQL: Write or read it in the SQL query tool.
- Fill in the blanks: Choose this term to complete a statement or table.
No past question in this bank is linked to this term yet. It can still be tested through the question types above.
Study links
- Flashcard: CRUD in Programming for the Web (Year 12) · study that set
- Memorise: SQL vs ORM
- Key terms bank entry: CRUD
- Notes: Web development system: front end, back end, databases (Programming for the Web (Year 12))
- Notes: Model elements that form a web development system, including client-side (front-end) web… (Programming for the Web (Year 12))
- Notes: Python with sqlite3 and parameterised queries (Python and SQL you must be able to write)
- Notes: SQL: HSC syntax and must-know queries (Python and SQL you must be able to write)
How to use it in an answer
A model sentence
Code pattern: “Create, Read, Update, Delete: the four basic database operations (INSERT, SELECT, UPDATE, DELETE).” Then apply it: UPDATE Student SET mark = 80 WHERE id = 3
In a short answer, give the definition in your own words first, then tie it to the situation in the question. Do not copy the example above unless it fits the scenario.
Technique for the question types
- Multiple choice: Read all four options, rule out wrong ones, pick one; no penalty for guessing so never leave blank.
- SQL: Use SELECT, FROM, WHERE, GROUP BY, ORDER BY in order; put text in quotes; combine conditions with AND or OR; name the right tables.
- Fill in the blanks: Choose the right word from a list; use exact syllabus terms.
Common mistakes
- Check the sources: From the school notes, not named in the syllabus.
- SQL questions (2025 HSC exam Q21): query must run; quotation marks around data being searched; use OR/AND in WHERE; correct GROUP BY and ORDER BY fields.
- Use the term exactly as the syllabus words it, then link it to the scenario in the question; the 2025 feedback repeatedly rewards using the stimulus.
- Answer the command word: outline gives main points only, explain gives a reason or cause, discuss gives both sides.
Related terms
Same group in the syllabus: Shell commands (mkdir, cd, touch, cp, rm, cat, grep) · SQL SELECT · SQL WHERE · SQL ORDER BY · SQL GROUP BY · SQL aggregate functions (COUNT, SUM, AVG) · SQL JOIN · SQL alias (AS) · SQL constraints · Primary key and foreign key · Object-relational mapping (ORM) · Service worker · Web app manifest