Lecture 1 - SQL Introduction

Question 1

What does ACID stand for?

Answer 1

Atomic, Consistent, Isolated, Durable

Question 2

What does SQL stand for?

Answer 2

Structured Query Language

Question 3

What does DML stand for?

Answer 3

Data Manipulation Language

• These statements let you get data out and put data in.
• You can change existing data

Question 4

What does DDL stand for?

Answer 4

Data Definition Language

• Allows you to create and destroy tables
• Used to set up connections between tables
• You can create rules to prevent users doing dumb things

Question 5

What does DCL stand for?

Answer 5

Data Control Language

• You can set permissions so that different users have different levels of access

Question 6

What does TCL stand for?

Answer 6

Transaction Control Language

• You can specify what happens when conflicts occur
• What should happen if you change the data while I am reading it