105.3 SQL Data Management

Question 1

DELETE is for ?

DROP is for ? and ?

Answer 1

rows

tables and databases

Question 2

EXCLUSIVE is not a JOIN query type. (T/F)

Answer 2

True

Question 3

CREATE is for database objects only, not queries. (T/F)

Answer 3

True

Question 4

MAKE, EDIT, and ADD are not SQL commands. (T/F)

Answer 4

True

Question 5

Data manipulation commands are ?, ?, and ?

Answer 5

INSERT, UPDATE, and DELETE

e.g. INSERT ROW, UPDATE ROW, DELETE ROW

Question 6

Full path to MariaDB config file.

Answer 6

/etc/my.cnf