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

More than 4.4billion prescriptions were dispensed within the United States in 2016.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

The human body produces and destroys 15 million blood cells every second.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

Did you know?

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

For a complete list of videos, visit our video library