14. A consistent and well-designed database is _____________________. A. One in which all tables have foreign keys B. One in which all tables are de-normalized C. One in which all data integrity constraints are satisfied D. One in which all SQL statements only query one table at a time

15. The ____ contains business data extracted from the operational database and from external data sources. A. Data warehouse B. Data visualization tool C. Data dictionary D. ETL tool

16. The ________________ command is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another. A. SELECT ONLY V_CODE FROM PRODUCT; B. SELECT UNIQUE V_CODE FROM PRODUCT; C. SELECT DIFFERENT V_CODE FROM PRODUCT; D. SELECT DISTINCT V_CODE FROM PRODUCT;

17. All transactions must display _____________________. A. atomicity, serializability, and durability B. durability, atomicity, consistency, and isolation C. serializability, durability, and isolation D. durability and isolation

18. The ANSI has defined standards that govern SQL database transactions. Transaction support is provided by two SQL statements: ____________________ and ROLLBACK. A. RETRIEVE B. ASSIGN C. UPDATE D. COMMIT

19. Joe is working on the Course table and needs to know which courses have prerequisite. To find the information he would ____________. A. create a new query B. create a new table C. create a new form D. create a new constraint

Use the following tables (with partial data shown) for a car rental database to answer questions 20-25:

CUSTOMER In table CUSTOMER, CID is the primary key (Customer ID). RENTALS In the table RENTALS, RTN provides the rental number (the primary key), CID is the customer's unique id, PICKUP is the city where the car was picked up, and Return is the city where the car was returned. RENTCOST RENTCOST shows the base cost of renting a given MAKE for one day. CITYADJ If the return city of table RENTALS is the one listed in table CITYADJ, the cost of the rental is multiplied by FACTOR and by DAYS shown in table RENTLENGTH below. RENTLENGTH RENTLENGTH shows the number of days for the rental number (RTN) shown in table RENTALS. In a database used in reality, this table would be merged with the RENTALS table. 20. SELECT DISTINCT CID, CNAME FROM CUSTOMER WHERE CID IN (SELECT CID FROM RENTALS WHERE MAKE IN ('FORD', 'TOYOTA')) The CNAMEs shown by the execution of this query are: A. BLACK B. BLACK, JONES C. BLACK, JONES, MARTIN D. BLACK, JONES, MARTIN, VERNON

21. SELECT DISTINCT CUSTOMER.CID, CNAME FROM CUSTOMER, RENTALS, RENTCOST WHERE CUSTOMER.CID = RENTALS.CID AND RENTALS.MAKE = RENTCOST.MAKE AND NOT EXISTS (SELECT * FROM RENTALS R, RENTCOST C WHERE R.MAKE = C.MAKE AND RENTALS.CID = R.CID AND RENTCOST.COST <> C.COST) The meaning of this query is: A. List all customers with more than one car make rented B. List all customers with one or more rentals for which the cost of each car make rented is the same C. List all customers who have only rented one make D. None of the above 22. SELECT MAKE FROM RENTALS, CUSTOMER WHERE RENTALS.CID = CUSTOMER.CID AND RESID_CITY = 'HEMET' GROUP BY MAKE HAVING COUNT (DISTINCT RENTALS.CID) = (SELECT COUNT(*) FROM CUSTOMER WHERE RESID_CITY = 'HEMET') The execution of this query produces the following number of rows: A. 0 B. 1 C. 2 D. 3 23. SELECT MAKE FROM RENTALS, CUSTOMER WHERE RENTALS.CID = CUSTOMER.CID AND RESID_CITY = 'HEMET' GROUP BY MAKE HAVING COUNT (DISTINCT RENTALS.CID) = (SELECT COUNT(*) FROM CUSTOMER WHERE RESID_CITY = 'HEMET') The meaning of this query is the following: A. List all makes of cars rented to customers residing in Hemet B. List all makes of cars rented to at least one customer residing in Hemet C. List all makes of cars rented to all customers residing in Hemet D. None of the above 24. SELECT CID, CNAME FROM CUSTOMER WHERE 0 = (SELECT COUNT(*) FROM RENTALS WHERE CUSTOMER.CID = RENTALS.CID) What is the interpretation of this query? A. List the customers who do not have rentals B. List the customers who have one rental C. List the customers who have 0 or more rentals D. List the customers who have 1 or more rentals 25. SELECT CNAME, DATE_OUT, RTN FROM CUSTOMER, RENTALS WHERE CUSTOMER.CID = RENTALS.CID AND BIRTHPLACE IN ('ERIE', 'CARY') AND EXISTS (SELECT * FROM RENTCOST WHERE COST < 40 AND RENTALS.MAKE= RENTCOST.MAKE) The CNAMEs shown by the execution of this query are: A. SIMON B. GREEN, BLACK, SIMON C. GREEN D. GREEN, SIMON