Cambridge AS & A Level Computer Science
8.3Data Definition Language (DDL) and Data Manipulation Language (DML)
Data Definition Language (DDL) and Data Manipulation Language (DML) in Cambridge AS & A Level Computer Science: what the syllabus expects you to know, the learning objectives and how to practise.
Subtopic45 practice questions2 lessons
Learning objectives
What the syllabus expects you to be able to do.
- 8.3.1Explain that a DBMS uses DDL to create and modify structure and DML for queries and maintenance, with SQL as the industry standard.
- 8.3.2Read and write SQL DDL statements (CREATE DATABASE, CREATE TABLE, ALTER TABLE, keys, data types).
- 8.3.3Write SQL DML queries and maintenance statements on at most two tables.
Lessons
- Full access
SQL data definition language
45 min
- Full access
SQL data manipulation language
55 min
Join to read every lesson, or see what Full access includes.
Sample question
A sample question on this topic. Answer it, check it, then read the worked answer.
Turn Data Definition Language (DDL) and Data Manipulation Language (DML) into a strength.
Practise with instant marking, see your mastery grow and get a study plan built around your exam date.