11) The SQL command ________ adds one or more new columns to a table. A) create table B) alter table C) create view D) create relationship 12) What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2)); A) Alters the Customer_T table to accept Type 2 Varchars B) Alters the Customer_T table to be a Type 2 Varchar C) Alters the Customer_T table, and adds a field called “Type” D) Alters the Customer_T table by adding a 2-byte field called “Varchar” 13) What does the following SQL command do? insert into Customer_T values (001,’John Smith’,’231 West St’,’Boston’,’MA’,’02115′); A) Adds a new record to the Customer_T B) Creates the Customer_T table C) Deletes the Customer_T table D) Updates the Customer_T table 14) Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work? insert into store values (‘234 Park Street’) A) It would work just fine. B) You must specify the fields to insert if you are only inserting some of the fields. C) There is no table keyword. D) None of the above. 15) What does the following SQL statement do? Delete from Customer_T where state = ‘HI’; A) Deletes all records from customer_t where the state is equal to HI B) Removes the Customer_T table from the database C) Deletes all records from the Customer_T table D) None of the above 16) What does the following SQL statement do? Update Product_T Set Unit_Price = 775 Where Product_ID = 7 A) Changes the price of a unit called Product_T to 7 B) Changes the unit price of Product 7 to 775 C) Changes the length of the Unit_Price field to 775 D) Updates the Product_T table to have a unit price of 775 17) Which of the following is a technique for optimizing the internal performance of the relational data model? A) Avoiding indexes on secondary keys B) Clustering data C) Not reporting statistics to save machine resources D) Using random index organizations 18) Indexes are created in most RDBMSs to: A) provide a quicker way to store data. B) decrease the amount of disk space utilized. C) provide rapid random and sequential access to base-table data. D) increase the cost of implementation. 19) In an SQL statement, which of the following parts states the conditions for row selection? A) Select B) From C) Where D) Group By 20) What does the following SQL statement do? Select * From Customer Where Cust_Type = “Best” A) Selects all the fields from the Customer table for each row with a customer labeled “Best” B) Selects the “*” field from the Customer table for each row with a customer labeled “Best” C) Selects fields with a “*” in them from the Customer table D