Author Question: The XML shown in the figure below describes some data from the Pine Valley Furniture case study. ... (Read 30 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?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

Asthma-like symptoms were first recorded about 3,500 years ago in Egypt. The first manuscript specifically written about asthma was in the year 1190, describing a condition characterized by sudden breathlessness. The treatments listed in this manuscript include chicken soup, herbs, and sexual abstinence.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

For a complete list of videos, visit our video library