The XML shown in the figure below describes some data from the ...

[ericka1]

The XML shown in the figure below describes some data from the Pine Valley Furniture case study. What results does the following XPath expression return? /furniturecompany/product/finish = Cherry/standardprice
 
  A) all products with a cherry finish.
  B) a description of all products with a cherry finish.
  C) the standard price of products with a cherry finish.
  D) nothing.

Question 2

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) A count of all of the deliveries made to state = 'MA' by all drivers
  D) None of the above

[kaillie]

Answer to Question 1

C

Answer to Question 2

B