This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 6. What result set will the following query return? select item_no, description from item where weight > 100 and weight < 200; c. the item_no and description for all items weighing between 101 and 199 7. What will be returned when the following SQL statement is executed? select driver_no, count(*) as num_deliveries from deliveries group by driver_no; b. a listing of each driver as well as the number of deliveries that he or she has made 8. One major advantage of the outer join is that: b. information is not lost. 9. The HAVING clause acts as a secondary WHERE clause. 10. Catalog and schema are very powerful database objects because they are stored in the database and controlled by the DBMS.-10 pts: triggers and routines, page 312...
View Full Document
- Spring '09
- following SQL statement, Randall Hall