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?