Database Chapter 6 and 7

What does the following SQL command do? insert into Customer_T values (001,'John Smith','231 West St','Boston','MA','02115');

Adds a new record to the Customer_T

Which of the following is the wildcard operator in SQL statements? a. application longevity b. cross-system communication c. reduced training cost d. all of the above

all of the above

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

distinct

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

*

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 each driver who made deliveries to state = 'MA' as well as the number of deliveries that each driver has made to that state

In which of the following situations would one have to use an outer join in order to obtain the desired results?

A report is desired that lists all customers, the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero).

What does the following SQL statement do? Update Product_T Set Unit_Price = 775 Where Product_ID = 7

Changes the unit price of Product 7 to 775

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

DCL

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

DML

What does the following SQL statement do? Select * From Customer Where Cust_Type = "Best"

Selects all the fields from the Customer table for each row with a customer labeled "Best"

What result will the following SQL statement produce? Select Avg(standard_price) as average from Product_V;

The average Standard_price of all products in Product_V

What results will be produced by the following SQL query? Select sum(standard_price) as Total_Price from Product_V where Product_Type = 'WOOD';

The total price of all products that are of type wood

he ________ clause is used to combine the output from multiple queries into a single result table.

UNION

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

Where

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

alter table

A join operation:

causes two tables with a common domain to be combined into a single table or view.

Which of the following counts ONLY rows that contain a value?

count

The most commonly used form of join operation is the:

natural join

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

outer join

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

schema

A type of join where a table is joined to itself is called a(n):

self-join