Note AcademyNote Academy
Start

Data Definition Language (DDL) and Data Manipulation Language (DML)

8.3

What the syllabus asks of you

  • Show understanding that the DBMS carries out all creation / modification of the database structure using its Data Definition Language (DDL)
  • Show understanding that the DBMS carries out all queries and maintenance of data using its DML
  • Show understanding that the industry standard for both DDL and DML is Structured Query Language (SQL)
  • Understand given SQL (DDL) statements and be able to write simple SQL (DDL) statements using a sub-set of statements
  • Write an SQL script to query or modify data (DML) which are stored in (at most two) database tables

Read the notes first

Chapter 8: Data definition language (DDL) and data manipulation language (DML)

Open the notes →

Drill this topic

All 10 questions on Data Definition Language (DDL) and Data Manipulation Language (DML), untimed — answer on paper, then mark yourself against the mark scheme.

Start drill →

Make a worksheet

Choose the years and how many questions, then print it with the answers on separate pages.

Make a worksheet →

10 questions

These are structured questions, answered in working rather than by picking an option, so they are not listed here one by one. The drill above puts each in front of you with its mark scheme to check against.