When you code a union with the INTERSECT keyword to combine two result sets, the union
A. excludes rows from the second result set if they also occur in the first result set
B. includes all rows that occur in both result sets if the primary keys are the same
C. includes only rows that occur in both result sets
D. excludes rows from the first result set if they also occur in the second result set
Answer: C. includes only rows that occur in both result sets
You might also like to view...
What is the Memory buffer setting for dynamic memory? Give an example.
What will be an ideal response?
Define an iptables rule that will reject incoming connections on the TELNET port.
What will be an ideal response?
When you click the Show All command, all the hidden objects are selected when they are revealed.
Answer the following statement true (T) or false (F)
When deleting a field from a table, Access will delete the field and corresponding ________
Fill in the blank(s) with correct word