SQL Chapter 3

___ joins return all rows from one table along with all rows from the other table. ___ conditions should always be included.

Cross, WHERE

You can use the ___ statement to remove one or more rows in a table or view.

DELETE

You can remove an entire table using the ___ table statement.

DROP

What commands are used to delete data from a database?

Delete, truncate table, drop table

Is is recommended that you specify JOIN statements in the ___ clause.

FROM

What command is used to add data to a table?

INSERT

The ___ clause allows you to combine data from multiple table sources.

JOIN

___ ___ does not allow deletion of tables unless all of the related tables are deleted using a cascading delete.

Referential integrity

What command is used to display records from a table?

SELECT

You can use the ___ table statement to delete all the rows from a particular table while still leaving the table structure in place for future use.

Truncate

The ___ clause allows you to combine the results of two or more queries into a resulting single set that includes all the rows belonging to the query in that ___ (same term.)

UNION

What command is used to change data in a table?

UPDATE