Know-IT-All Chapter Quiz: i5/OS and Microsoft Office Integration Handbook, Third Edition

Think you know all there is about retrieving iSeries data with Microsoft Query? We challenge you to test your skills by taking our latest quiz. Share the results with us and get a chance to win a copy of i5/OS and Microsoft Office Integration Handbook, Third Edition written by Chris Peters and Brian Singleton and published by MC Press.

Think you know all there is about retrieving iSeries data with Microsoft Query? We challenge you to test your skills by taking our latest quiz. Share the results with us and get a chance to win a copy of i5/OS and Microsoft Office Integration Handbook, Third Edition written by Chris Peters and Brian Singleton and published by MC Press.

All answers to this quiz are found in the free excerpt. Good luck!

  1. The ____________________ is the easiest method for creating a query within Microsoft Query.
    Your answer:

    See book excerpt, page 40, for answer

  2. The first step in creating a new query is _____________________________.
    Your answer:

    See book excerpt, page 41, for answer

  3. The Query Wizard lets you filter query data. True or False?
    Your answer:

    See book excerpt, pages 43-44, for answer

  4. When doing a manual query, if your query doesn't automatically execute after you add fields to your query, you should ____________________________.
    Your answer:

    See book excerpt, page 46, for answer


  5. The quickest way to create a sort is to select a column and ______________________.
    Your answer:

    See book excerpt, page 48, for answer

  6. Query allows you to update iSeries database data. True or False?
    Your answer:

    See book excerpt, page 49, for answer

  7. To speed up the creation of queries, you can _______________________.
    Your answer:

    See book excerpt, page 51, for answer

  8. The _______________________ is a method of dividing data into logical, nonrepeating units.
    Your answer:

    See book excerpt, page 53, for answer

  9. Using Query, the simplest way to specify a join is to ____________________.
    Your answer:

    See book excerpt, page 54, for answer

  10. If you need to sort a large amount of data, consider adding a ___________ to the iSeries table that requires sorting.
    Your answer:

    See book excerpt, page 59, for answer




This was last published in November 2005

Dig Deeper on Physical connections to iSeries

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close