Chapter 6

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.

True

False

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

True

False

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

It would work just fine

You must specify the fields to insert if you are only inserting some of the fields

There is no table keyword

None of these

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

Select

From

Where

Group by

Indexes are created in most RDBMSs to:

Provide a quicker way to store data

Decrease the amount of disk space utilized

Provide rapid random and sequential access to base-table data

Increase the cost of implementation

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

True

False

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

True

False

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

Create table

Alter table

Create view

Create relationship

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

True

False

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

The minimum value of Product-description will be displayed

An error message will be generated

The first product description alphabetically in product_v will be shown

None of these

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

A listing of all drivers who made deliveries to state='MA', sorted by driver number

A listing of each driver who made deliveries to state='MA' as well as the number of deliveries that each driver has made to that state

A count of all of the deliveries made to state='MA' by all drivers

None of these

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

True

False

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)

True

False

Chapter 6

More Quizzes