Match the following terms to their definition
I. INNER JOIN
II. OUTER JOIN
III. FULL JOIN
IV. Union query
V. SQL subquery
A. Returns only the rows that actually match
B. Returns all rows from both tables
C. Usually added in the WHERE clause
D. Returns all rows from at least one of the tables
E. Combines two SQL SELECT statements
A, D, B, E, C
You might also like to view...
In the ________ method, the mouse is used to move a selected cell or a range of cells to a new location
Fill in the blank(s) with the appropriate word(s).
Which statement is false?
a) Using bit fields can be an effective space saving technique. b) Using bit fields always results in faster executing machine language. c) The decision to use bit fields is one of many examples of the kinds of space-time tradeoffs that occur in computer science. d) An unnamed bit field with a non-zero width is used as padding in a struct of bit fields.