D427 Sublanguages

Question 1

Data Definition Language

Answer 1

Concerned with database schemas and describes how data should be stored in the database

Question 2

Data Definition Language commands

Answer 2

ALTER, CREATE, DROP, TRUNCATE

Question 3

Data manipulation language (DML)

Answer 3

modifies data in a database

Question 4

data manipulation language commands

Answer 4

DELETE, EXPLAIN, INSERT, REPLACE, UPDATE

Question 5

Data Query Language

Answer 5

for querying the database

Question 6

Data Query Language commands

Answer 6

SELECT

Question 7

Data Control Language

Answer 7

concerned with rights, permissions, and other controls of the database system

Question 8

data control language commands

Answer 8

GRANT, REVOKE

Question 9

Transaction Control Language

Answer 9

Deals with transactions within a database

Question 10

Transaction Control Language commands

Answer 10

SET TRANSACTION, SAVEPOINT, ROLLBACK, COMMIT