Data Definition Language Flashcards

1
Q

What is the purpose of Data Definition language (DDL) ?

A

Creating and changing data structures.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the purpose of Data Manipulation language (DML) ?

A

Changing and assessing the data itself

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the purpose of Data Control language (DCL) ?

A

Allowing Users access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the purpose of Transaction Control language (TCL) ?

A

Controlling transactions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

State 4 DML Operations

A
  1. SELECT
  2. INSERT
  3. DELETE
  4. UPDATE
How well did you know this?
1
Not at all
2
3
4
5
Perfectly