Check your knowledge

1.

What property do you need to set, and to what value, to specify that a row in the parent data item is skipped if it contains no child rows?

Set SqlJoinType to LeftOuterJoin

Set SqlJoinType to RightOuterJoin

Set SqlJoinType to InnerJoin

Set SqlJoinType to CrossJoin

2.

How do you specify that a query should only return the year from a date column?

Set the Method property to Year.

Set the Method property to Date.

Set the Method property to Month.

Set the Method property to Day.

3.

Which isn't a valid totals method for a Decimal column in a query?

Sum

Count

Min

Exists

Answer the following questions to see what you've learned.