SQL Basics

What is DML?

• Database Management Language

• Data Manipulation Language

• Data Management Language

A DML statement is executed when you...

• Add new records to a table

• Modify existing rows in a table

• Remove existing rows from a table

• All of the above

What kind of statement is this?
INSERT INTO users VALUES (20, 'Mary', 'Ann', 12, 90000);

• insert clause

• implicit insert statement

• addition statement

What kind of statement is this?
INSERT INTO users (age, first_name, middle_name, member, points) VALUES (20, 'Mary', 'Ann', 12, 90000);

• explicit clause

• explicit insert statement

• explicit addition statement

What is a JOIN operation that creates an implicit join clause for you based on the common columns in the two tables being joined?

• a join statement

• a natural join

• an outer join

• a join function

What is a field (or collection of fields) in one table, that refers to the primary key in another table?

• a natural key

• a foreign key

• a primary key

• a joined key

Where should the ORDER BY clause go in a statement?

• at the beginning

• at the end

DML Statements should be run on:

• Any Field

• The Name Field

• The Unique ID

What does DDL stand for?

• Defining Data Language

• Data Definition Language

• Data Deletion Lines

When using a DELETE statement, what happens if you do not include a WHERE clause?

• You will get an error message.

• All data will be deleted from the table.

• The entire table will be deleted or dropped.