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

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

For a complete list of videos, visit our video library