Match the following keywords to their uses:
I. JOIN clause
II. DISTINCT keyword
III. Cross join query
IV. UNION keyword
V. ON keyword
A. Used to combine one or more queries in a table
B. Returns only a single instance of any duplicate values in query results
C. Defines the join type for a query
D. Used to specify which field is common to two tables
E. Every possible combination of records between two related tables will be returned in the query results
C, B, E, A, D
Computer Science & Information Technology
You might also like to view...
You can find options used to open, save, and print a document in ________
A) Page Break Preview B) Backstage view C) Read Mode D) Print Layout
Computer Science & Information Technology
White space refers to blank areas of a worksheet that do not contain data or documentation, regardless of the actual color
Indicate whether the statement is true or false
Computer Science & Information Technology