nerdexam
SAP

C_BOCR_11 · Question #287

You create a Crystal report with the following record selection formula: {Customer.Region} in ["BC","CA"] and DateTimeToDate ({Orders.Order Date}) > Date (2004,01,01) and {Orders.Employee ID} = 6…

The correct answer is C. WHERE (`Customer`.`Region`='BC' OR `Customer`.`Region`='CA') AND `Orders`.`Employee ID`=6. See the full explanation below for the reasoning.

Question

You create a Crystal report with the following record selection formula:

{Customer.Region} in ["BC","CA"] and DateTimeToDate ({Orders.Order Date}) > Date (2004,01,01) and {Orders.Employee ID} = 6 Which clause will be displayed when you select "Show SQL Query? from the Database menu?

Options

  • AWHERE (Customer.Region='BC' OR Customer.Region='CA')
  • BWHERE (Customer.Region in ['BC', 'CA']) AND Orders.Employee ID=6
  • CWHERE (Customer.Region='BC' OR Customer.Region='CA') AND Orders.Employee ID=6
  • DWHERE (Customer.Region in ['BC'] OR Customer.Region in ['CA']) AND Orders.`Order

How the community answered

(33 responses)
  • A
    6% (2)
  • B
    9% (3)
  • C
    82% (27)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C_BOCR_11 Practice