Database chp 6 - test
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
Which of the following is the wildcard operator in SQL statements?
*
Which of the following is a purpose of the SQL standard?
all of these
The command for creating a database is:
create schema.
Multiple values returned from an SQL query that includes an aggregate function are called:
vector aggregates
What will be returned when the following SQL query is executed? select driver_no count(*) as num_delv from delv group by driver_no having count (*)>2;
A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries
What will be returned when the following SQL query is executed? select driver_no, count(*) as num)delv from delv group by driver_no;
A listing of each driver as well as the number of deliveries that he or she has made
What will be returned when the following SQL query is executed? select driver_no, count(*) as num)delv 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
What does the following SQL command do?
Adds a new record to the Customer_T
The benefits of a standardized relational language include:
All of these
What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2));
Alters the Customer_T table, and adds a field called "Type"
Which of the following is a technique for optimizing the internal performance of the relational data model?
Clustering data
Which of the following counts ONLY rows that contain a value?
Count
______ is a set of commands used to update and query a database.
DML
What does the following SQL statement do? Delete from Customer_T where state = 'HI';
Deletes all records from customer_t where the state is equal to HI
Which of the following can produce scalar and vector aggregates?
Group By
Which of the following finds all groups meeting stated conditions?
Having
To get all the customers from Hawaii sorted together, which of the following would be used?
Order By
Which of the following will produce the minimum of all standard prices?
Select min(standard_price) from Product_V;
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 set is returned from the following query? select customer_name, telephone from customers where city in ('Boston', New york','denver');
The Customer_Name and telephone of all customers living in either Boston, New York or Denver
What result set will the following query return? select item_no, decription from item where weight>100 and weight <200;
The Item_No and description for all items weighing between 101 and 199
What result set will the following query return? select item_no from order_v where quanitity >10;
The Item_No of all orders that had more than 10 items
Which of the following is true of the order in which SQL statements are evaluated?
The SELECT clause is processed before the ORDER BY clause.
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 will be returned when the following SQL query is executed? select min (product_desc) from product_v;
The first product description alphabetically in Product_V will be shown.
In an SQL statement, which of the following parts states the conditions for row selection?
Where
Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work?
You must specify the fields to insert if you are only inserting some of the fields.
The SQL command ________ adds one or more new columns to a table.
alter table
What does the following SQL statement do? Update Product_T Set Unit_Price = 775Where Product_ID = 7
changes the unit price of Product 7 to 775
The SQL command ________ defines a logical table from one or more tables or views
create view
________ is a set of commands used to control a database, which includes security
dcl
To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command.
distinct
Any create command may be reversed by using a ________ command
drop
A ________ view is materialized when referenced.
dynamic
Which of the following questions is answered by the SQL statement? Select Count (Product_Description) from Product_T;
how many products have product descriptions in the Product Table?
The first in a series of steps to follow when creating a table is to
identify each attribute and its characteristics.
DDL is typically used during which phases of the development process?
physical design
Indexes are created in most RDBMSs to:
provide rapid random and sequential access to base-table data.
A single value returned from an SQL query that includes an aggregate function is called a(n):
scalar aggregate.
The ________ is the structure that contains descriptions of objects such as tables and views created by users.
schema