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...

The ping utility can help you determine how fast the CPU is operating on the target computer.

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

Computer Science & Information Technology

You can enter formulas by a combination of typing and clicking selected cells

Indicate whether the statement is true or false

Computer Science & Information Technology

You have a number of Cisco routers and switches that you wish to secure using IPsec. You want IPsec authentication to use digital certificates. You already have a PKI in place using Certificate Services on Windows Server 2016. What should you install to secure your devices?

A. NDES role service B. Smart Card reader C. OCSP D. Online Responder

Computer Science & Information Technology

A(n) ________ is where you go when you click a hyperlink.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology