MGT 4058 Chapter 6

To get all the customers from Hawaii sorted together, which of the following would be used? A. ORDER BY B. HAVING C. GROUP BY D. SORT

A

What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_deliveries from deliveries group by driver_no having count(*) > 2; A. A listing of all drivers who made more than 2 deliveries B. A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries C. A listing of the number of deliveries greater than 2 D. A listing of all drivers

B

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. A listing of all drivers who made deliveries to state = 'MA', sorted by driver number B. 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 C. An error message will be generated D. A count of all of the deliveries made to state = 'MA' by all drivers

B

What will result from the following SQL Select statement? Select min(Product_Description) from Product_V; A. The first product description alphabetically in Product_V will be shown B. An error message will be generated. C. SELECT @ will be displayed. D. The minimum value of Product_Description will be displayed.

A

What does the following SQL command do? insert into Customer_T values (001,'John Smith','231 West St','Boston','MA','02115'); A. Updates the Customer_T table B. Adds a new record to the Customer_T table C. Creates the Customer_T table D. Deletes the Customer_T table

B

What does the following SQL statement do? Delete from Customer_T where state = 'HI'; A. Deletes all records from the Customer_T table B. Doesn't delete anything because of a syntax error C. Deletes all records from customer_t where the state is equal to HI D. Removes the Customer_T table from the database

C

What result set will the following query return? Select Item_No from Order_V where quantity > 10; A. The Item_No of all orders that had 10 or more items B. The Order_Id of all orders that had more than 10 items C. The Item_No of all orders that had more than 10 items D. The Order_Id of all orders that had more than one item

C

Multiple values returned from an SQL query that includes an aggregate function are called: A. agates. B. scalar aggregates. C. summations. D. vector aggregates.

D

The benefits of a standardized relational language include: A. application turnover. B. increased training costs. C. confusing the SQL programmers. D. cross-system communication.

D

What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2)); A. Alters the Customer_T table to be a Type 2 Varchar B. Alters the Customer_T table by adding a 2-byte field called "Varchar" C. Alters the Customer_T table to accept Type 2 Varchars D. Alters the Customer_T table, and adds a field called "Type"

D

A single value returned from an SQL query that includes an aggregate function is called a(n): A. scalar aggregate. B. agate. C. summation. D. vector aggregate.

A

The first part of an SQL query to be read is the ________ statement. A. FROM B. WHERE C. ORDER BY D. SELECT

A

Which of the following is a wildcard operator in SQL statements? A. * B. & C. < > D. =

A

Requiring a CustomerID to exist in a Primary table before it can exist in a foreign table is an example of: A. Ethical Integrity. B. Referential Integrity. C. the Hoffer Principle. D. Referential Referring.

B

Which of the following is true of the order in which SQL statements are evaluated? A. The GROUP BY clause is processed before the WHERE clause. B. The SELECT clause is processed before the ORDER BY clause. C. The SELECT clause is always processed first. D. The SELECT clause is always processed last.

B

The SQL command ________ defines a logical table from one or more tables or views. A. create relationship B. alter table C. create view D. create table

C

The command for creating a database is: A. create authorization. B. create table. C. create schema. D. create view.

C

Which of the following can produce scalar and vector aggregates? A. ORDER BY B. SORT C. GROUP BY D. HAVING

C

INSERT INTO is an example of ________ code. A. DCL B. DDL C. TIO D. DML

D

What does the following SQL statement do? Update Product_T Set Unit_Price = 775 Where Product_ID = 7 A. Changes the length of the Unit_Price field to 775 B. Updates the Product_T table to have a unit price of 775 C. Changes the price of a unit called Product_T to 7 D. Changes the unit price of Product 7 to 775

D