Latham Works in the Logistics Department for a Large City

question 37

Multiple Choice

Latham works in the logistics department for a large city bus system.  As routes are changed,Latham accesses the internal database to ensure all records are accurate.  The Bus Route System database includes a one-to-many relationship between the Bus Number and the Bus Routes with Bus ID as the common field.  This allows the two tables to be joined to create a query based on data from both tables:  Bus Number and Bus Routes.
-Latham often has to look up bus routes based on specific bus stops.To speed up the search process in this large database,he might want to create a(n) ____ for the Bus Stop field in the Bus Routes table.

• A)update query
• B)outer join
• C)index
• D)self-join

---

Definitions:

Palatine

Pertaining to the palate, especially referring to bones or structures associated with the roof of the mouth.

Larynx

The voice box located in the throat, which contains the vocal cords and is involved in breathing, producing sound, and protecting the trachea against food aspiration.

Adam's Apple

The prominent protrusion in the neck, formed by the thyroid cartilage of the larynx, more prominent in males.

Cricoid

The cricoid is a cartilage ring located in the larynx (voice box) at the top of the trachea; it plays a key role in keeping the airway open for respiration.