QUIZ [GFORM] Flashcards

1
Q

DDL – consists of the SQL commands that can be used to define the database schema

A

Data Definition Language

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

List of DDL commands

A
  • CREATE
  • DROP
  • ALTER
  • TRUNCATE
  • COMMENT
  • RENAME
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

DML - commands that deal with the manipulation of data present in the database

A

Data Manipulation Language

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

List of DML commands:

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

DCL - mainly deal with the rights, permissions, and other controls of the database system

A

Data Control Language

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

List of DCL commands:

A
  • GRANT
  • REVOKE
How well did you know this?
1
Not at all
2
3
4
5
Perfectly