Given the Person and Location tables provided at the start of the chapter, what is the SQL statement needed to return a query that lists all of the states that any person resides in?
What will be an ideal response?
```
SELECT state FROM Location WHERE locationId = Person.locationID;
```
You might also like to view...
If you activate the ____________________ button (the link icon) between the W and H text boxes, any change you make to one will automatically be made to the other.
Fill in the blank(s) with the appropriate word(s).
What is the IEEE standard for PoE?
A) IEEE 802.1Q B) IEEE 802.1D C) IEEE 802.11 D) IEEE 802.3af
The Field Properties pane displays information for how many fields at the same time?
A. Only the selected field. B. However many are visible in the window. C. All of the fields in that particular table. D. All of the fields in the entire database.
Which of the following statements about graphs is false?
A. A graph is a collection of nodes and a collection of segments connecting pairs of nodes. B. Graphs are a directed tree structure. C. A path is a sequence of vertices in which each vertex is adjacent to the next one. D. Graphs may be directed or undirected. E. The degree of a vertex is the number of lines incident to it.