Case-Based Critical Thinking QuestionsCase 9-2Latham 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.
A join that relates records from the Bus Number table with the Bus Routes table based on the same Bus ID is an example of a(n) ____ join.

A. inner
B. outer
C. self
D. common


Answer: A

Computer Science & Information Technology

You might also like to view...

?Which of the following is NOT a popular vendor of firewall software?

A. ?Red Hat B. ?Check Point C. ?Kaspersky D. ?Total Defense 

Computer Science & Information Technology

The Graham-Leach-Bliley Act is a critical piece of legislation that affects the executive management of publicly traded corporations and public accounting firms. _________________________

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Technically speaking, cookies are not considered spyware.

a. true b. false

Computer Science & Information Technology

?For the border-style property, the horizontal and vertical offset measurements must be specified.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology