Module 7 questions quiz#1 Flashcards
1
Q
A
2
Q
Explain the difference between a regular subquery and a correlated subquery.
A
regular, or uncorrelated subquery, executes before the outer query. correlated subquery relies in part on the outer query,
3
Q
What MS Access and SQL Server function should you use to calculate the number of days between your birth date and the current date?
A
DATEDIFF
4
Q
It is a compound operation that involves repeating the join operation, typically accumulating more records each time, until a repetition makes no change to the results.
A
Recursive join
5
Q
returns the number of items in a group
A
COUNT aggregate function
6
Q
returns the sum of all the values.
A
SUM aggregate function
7
Q
What three join types are included in the outer join classification?
A
LEFT JOIN , RIGHT JOIN , and FULL JOIN
