Chapter 6

A database is maintained and queried using the data mapping language (DML).

A major benefit of SQL as a standard is reduced training costs.

A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.

Adding the DISTINCT keyword to a query eliminates duplicates.

Expressions are mathematical manipulations of data in a table that may be included as part of the SELECT statement.

Given a table names store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work?

In a SQL statement, which of the following parts states the conditions for row selection?

Indexes are created in most RDBMSs to:

In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved.

The ALTER TABLE command is used to change a table definition.

The DROP command deletes rows from a table individually or in groups.

The HAVING clause and the WHERE clause perform the same operation.

The ORDER BY clause sorts the final results rows in ascending or descending order.

The SQL command ___ adds one or more new columns to a table.

The WHERE clause includes the conditions for row selection within a single table or view and the conditions between tables or views for joining.

What will result from the following SQL Select statement? Select min(Product_Description) from Product_V;

What will be returned when the following SQL statement is executed? Select driver_no, count(*) as num_deliveries from deliveries where state='MA' group by driver_no

When creating tables, it's important to decide which columns will allow null values before the table is created

The following SQL statement will produce different results. Blah blah blah where state='MA' or state='NY' etc vs. Where state in ('MA', 'NY', etc)