C-BOCR-08 by SAP Actual Free Exam Questions And Answers

Question 1

Which two export options can you use to display the correct Page N of M values in an exported file? (Choose two.)

A. Acrobat Format (PDF)

B. Report Definition

C. Rich Text Format

D. XML

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

Which three methods can you use to remove a database link in the Database Expert? (Choose three.)

A. Select a link, click Delete Link.

B. Right-click each link, click Delete Link.

C. Drag the Link outside the Links pane.

D. On the Links tab, click Clear Links.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 3

Which procedure should you use to determine whether Crystal Reports is the source of incorrect report results?

A. Copy and run the query in the Query Checker.

B. From the report menu, check the Performance Information and Click OK.

C. Copy the query from Crystal Reports and run it in the database query tool.

D. From the report menu, select Refresh Report Data and Click OK.

Discussion 0

Correct Answer: C Vote an answer

Question 4

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 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.

B. 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.

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. 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.

Discussion 0

Correct Answer: B Vote an answer

Question 5

You referenced the wrong field while creating a barcode. How must you correct the barcode?

A. Right click the barcode and modify the field properties.

B. Delete the barcode and recreate it.

C. Edit the field properties for the barcode in the Custom Function tool.

D. Click on the Barcode Generation Wizard and modify the field properties.

Discussion 0

Correct Answer: B Vote an answer

Question 6

How must you register multiple XML export formats in Crystal Reports 2008?

A. Add XML export formats using the Define XML Exporting Formats dialog.

B. Configure XML export formats using the Manage XML dialog.

C. Add XML export formats using the Manage XML Exporting Formats dialog.

D. Configure XML export formats using the Define XML dialog.

Discussion 0

Correct Answer: C Vote an answer

Question 7

Sales Managers use a weekly sales report that includes the following columns: Sales Person, Weekly Sales and Quota. The Sales Managers would like the ability to retrieve additional non-sales related information on their personnel by clicking on a hyperlink. Which type of report should you create?

A. On-Demand subreport based on manager ID

B. Unlinked subreport based on employee ID

C. Linked On-Demand subreport based on employee ID

D. Unlinked subreport based on manager ID

Discussion 0

Correct Answer: C Vote an answer

Question 8

You create an If-Then-Else formula for a Crystal report. When you close the Formula Editor, you receive the error message "A string is required here." Which two formulas could return such an error? (Choose two.)

A. IF {Orders.Order Amount} > 5000 THEN "High Order" ELSE 0

B. IF {Customer.Country} > "Canada" THEN {Orders.Order Amount} ELSE {Orders.Order Amount}
*1.20 + "CDN."

C. IF {Orders.Order Amount} > 5000 THEN "High Order" ELSE {Orders.Order Date}

D. IF {Orders.Order Amount} > 5000 THEN "High Order" ELSE {Orders.Order Amount} > 3000 then "OK"

Discussion 0

Correct Answer: A,C Vote an answer

Question 9

Which three If-Then-Else control structure formulas in Crystal syntax will generate an error? (Choose three.)

A. If {Orders.Order Amount} < 100 Then formula = "Under $100" ElseIf {Orders.Order Amount} in 100 to 200 Then formula = "Between $100 and $200" EndIf

B. If {Orders.order Amount} < 1000 Then "Low" Else "High"

C. If {Orders.Order Amount} < 200 ThenUnder $200 ElseIf {Orders.Order Amount} in 200 to 300 Then Between $200 and $300

D. If {Orders.Order Amount} < 100 Then"Under $100"ElseIs {Orders.Order Amount} in 100 to 200 Then "Between $100 and $200"

Discussion 0

Correct Answer: A,C,D Vote an answer

SAP Certified Application Associate - Crystal Reports 2008 - C-BOCR-08 Exam Practice Test

Contact Us

Useful Links

Latest Updated