Modern Database Management - Chapter 6

alter table

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

create view

The SQL command ________ defines a logical table from one or more tables or views.

Order By

To get all the customers from Hawaii sorted together, which of the following would be used?

DCL

________ is a set of commands used to control a database, which includes security.

DML

________ is a set of commands used to update and query a database.

drop

Any create command may be reversed by using a ________ command.

vector aggregates.

Multiple values returned from an SQL query that includes an aggregate function are called:

dynamic

A ________ view is materialized when referenced.

scalar aggregate.

A single value returned from an SQL query that includes an aggregate function is called a(n):

all of the above.

A view may not be updated directly if it contains:

Physical design

DDL is typically used during which phases of the development process?

Where

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

provide rapid random and sequential access to base-table data.

Indexes are created in most RDBMSs to:

schema

The ________ is the structure that contains descriptions of objects such as tables and views created by users.

all of the above.

The benefits of a standardized relational language include:

create schema.

The command for creating a database is:

identify each attribute and its characteristics.

The first in a series of steps to follow when creating a table is to:

distinct

To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command.

Group By

Which of the following can produce scalar and vector aggregates?

Having

Which of the following finds all groups meeting stated conditions?

All of the above

Which of the following is a purpose of the SQL standard?

Clustering data

Which of the following is a technique for optimizing the internal performance of the relational data model?

*

Which of the following is the wildcard operator in SQL statements?

The SELECT clause is processed before the ORDER BY clause.

Which of the following is true of the order in which SQL statements are evaluated?

Select min(standard_price) from Product_V;

Which of the following will produce the minimum of all standard prices?