Check your knowledge

Completed

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

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 is not a valid totals method for a Decimal column in a query?

Sum

Count

Min

Exists

You must answer all questions before checking your work.