Author Question: The XML shown in the figure below describes some data from the Pine Valley Furniture case study. ... (Read 95 times)

ericka1

  • Hero Member
  • *****
  • Posts: 544
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

  • Sr. Member
  • ****
  • Posts: 326
Answer to Question 1

C

Answer to Question 2

B



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Did you know?

There are more bacteria in your mouth than there are people in the world.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

For a complete list of videos, visit our video library