Online Access Free C_BOCR_08 Exam Questions

You must summarize the sales amounts for all customers with less than $1000 per sale. How would you evaluate this in the Running Total Expert?

• A.On change of field
• B.For each record
• C.Use a formula
• D.On change of group

You must use a formula in a new Crystal report that creates an account number for each customer. The account number consists of the first five alphabetical characters from the Customer Name field and the first five numeric characters from the Phone field. All records contain at least five characters of the correct type in each field. Which process would you use to create the account number?

• A.Create a formula with two While Do loops. The first extracts the first five alphabetical characters from the Customer Name field and the second extracts the first five numerical characters from the Phone field and concatenates them to the five alphabetical characters. The last line displays the ten-character result.
• B.Use If-Then-Else statements to return every possible result for each field. Create formulas to extract the required characters from the Customer Name and Phone fields and assign the results to global variables. Use a third formula to concatenate the results and display the account number.
• C.Use nested If-Then-Else statements to return every possible result for each field. Create a formula to extract the required characters from the If-Then-Else results then display the concatenated data.
• D.Create a formula that uses a SELECT statement that is processed on the database server that concatenates the first five alphabetical characters from the Customer Name field with the first five numerical characters from the Phone field. The last line displays the ten-character result.

You need a report that shows all customers and allows the report reader to view either a report listing all days in the month to date or to view only the customers with daily sales greater than $5000. You decide to use report alerts to accomplish this. Which formula properly sets the alert condition?

• A.Sum ({Orders.Order Amount}, {Orders.Order Date}, "daily") > 5000
• B.Sum ({Orders.Order Date}, {Orders.Order Amount}, "daily") > 5000}
• C.IF Sum ({Orders.Order Amount}, {Orders.Order Date}, "daily") > 5000 THEN crCondition = "Enabled"
• D.IF Sum ({Orders.Order Amount}, {Orders.Order Date}, "daily") > 5000 THEN AlertMessage = "Enabled"

Which method can you use to correct a problem in a WHERE clause?

• A.Edit the Table links from the Report Menu.
• B.Edit the record selection formula from the Report Menu.
• C.Edit the SQL command in the Report Expert.
• D.Edit the Show SQL statement from the Database Menu.

Which two database characteristics can cause differences in the results of a query between a Crystal report and a third-party SQL tool? (Choose two.)

• A.The database handles empty strings differently than Crystal Reports.
• B.The database uses a different SQL dialect than Crystal Reports.
• C.The database driver handles the SQL syntax differently than Crystal Reports.
• D.The database uses different data types than Crystal Reports for some fields.