最新的SAP C_BOCR_08免費考試真題

問題1

How can you change a field's position?

A. Select the Location option in the Format menu.

B. Select the Size and Position option in the Report menu.

C. Right-click the field and choose the Size and Position option.

D. Right-click the field and choose the Location option.

正確答案: C

問題2

Which formula calculates the difference in weeks between two date values?

A. DateDiff ("w", #10/7/1999#, #10/31/1999#)

B. DateDiff ("ww", #10/7/1999#, #10/31/1999#)

C. DateDiff ("yyyy", #10/7/1999#, #10/31/1999#)

D. DateDiff ("weeks", #10/7/1999#, #10/31/1999#)

正確答案: A

問題3

Which two are advantages of using an ODBC connection to access data? (Choose two.)

A. Data retrieval and sorting work is offloaded to the client to save server resources.

B. You can use nonstandard SQL to provide advanced features.

C. It is a universal database connector.

D. It translates application data queries into commands that the database understands.

正確答案: C,D

問題4

In a new Crystal report you must create a formula to split the string "Up Down Sideways" into an array with three elements then display the third element of the array. Which formula meets the requirement?

A. Split("Up Down Sideways", " ")(3)

B. Split("Up Down Sideways", ", ")[3]

C. Split("Up Down Sideways", ", ")(3)

D. Split("Up Down Sideways", " ")[3]

正確答案: D

問題5

Which two checks can you perform with the Dependency Checker? (Choose two.)

A. Compile SQL expressions

B. Check Subreport Links

C. Traverse Table Hierarchy

D. Verify Database

正確答案: A,D

問題6

You create the following formula: Dim x as number Dim y as string Dim z as boolean Formula = "Hello" x = 5 y= "Goodbye" z = true Which value does it return?

A. "Hello"

B. True

C. 5

D. "Goodbye"

正確答案: A

問題7

Which three are valid join types in Crystal Reports when using a native connection to a PC-type database? (Choose three.)

A. Inner

B. Right Outer

C. Full Outer

D. Union

E. Left Outer

正確答案: A,B,E

問題8

Which formula can you use in a record selection to include all dates 30 days from the date the report is refreshed?

A. {Orders.Order Date} in NextMonth

B. {Orders.Order Date} in Prev30Days

C. {Orders.Order Date} in Next30Days

D. {Orders.Order Date} in NextPeriod

正確答案: C

問題9

You create the following formula in a new Crystal report: Local NumberVar Array b; Redim b[10]; Local NumberVar i; For i := 1 To 10 Do ( b[i] := 7 * i ); What is the correct value of b[2]?

A. 70

B. 7

C. 14

D. 140

正確答案: C

問題10

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.

正確答案: B

問題11

What two settings should you select to enable server-side grouping on a Crystal report? (Choose two.)

A. Use Indexes or Server for Speed

B. Perform Grouping on Server

C. Always Sort Remotely

D. Perform Query Asynchronously

正確答案: A,B

問題12

You create the following formula: {Customer.FirstName} + " " + {Customer.LastName} Which function will force the earliest evaluation time?

A. WhilePrintingRecords

B. EvaluateAfter

C. WhileReadingRecords

D. BeforeReadingRecords

正確答案: C

問題13

In Crystal Reports you select multiple report objects at the same time. Which two menu options become available when you right-click one of the selected objects? (Choose two.)

A. Delete

B. Insert

C. Move

D. Cut

E. Copy

正確答案: D,E

問題14

You must create a report based on a Business View. How can you do this?

A. Select the required Business View from the Repository list in the Database Expert Repository.

B. Select the Report Wizard from the Previous Connections list in the Database Expert.

C. Select the required Business View from the Create New Connection list in the Database Expert.

D. Select the Report Wizard from the Current Connections list in the Database Expert.

正確答案: A

最新的SAP Certified Application Associate - Crystal Reports 2008 - C_BOCR_08免費考試真題

聯系我們

站內鏈接

最新更新