Banner

 

XML

Files

Exercises

Using customerpayments.xml, answer the following questions using XPath.

  1. List all customers.
  2. Who is the last customer in the file?
  3. Select all customers in Sweden.
  4. List the payments of more than USD 50,000.
  5. Select the first payments by Toys4GrownUps.com.
  6. What was the payment date for check DP677013?
  7. Who paid with check DP677013?
  8. What payments were received on 2003-12-04
  9. Who made payments on 2003-12-04?
  10. List the numbers of all checks from customers in Denmark.

Using customerpayments.xml, answer the following questions using XQuery.

  1. List all customers.
  2. Who is the last customer in the file?
  3. Select all customers in Sweden sorted by customer name.
  4. List the payments of more than USD 50,000.
  5. Select the first payments by Toys4GrownUps.com.
  6. What was the payment date for check DP677013?
  7. Who paid with check DP677013?
  8. What payments were received on 2003-12-04
  9. Who made payments on 2003-12-04?
  10. List the numbers of all checks from customers in Denmark.

 

This page is part of the promotional and support material for Data Management (sixth edition) by Richard T. Watson
For questions and comments please contact the author

Date revised: 19-Oct-2016