923 お客様のコメント
質問 1：
You are creating a report and you open the Field Explorer. The field names are random alphanumeric values. Which database option should you enable to see an alternative to the field names?
A. Show Aliases
B. Show Name
C. Show Description
D. Show Distinguished Name
正解：C
質問 2：
What are three characteristics of a Full Outer Join? (Choose three.)
A. Displays a row for records with matching values in both tables
B. Bidirectional join that displays all records in the linked tables
C. Unidirectional join that displays all records in the linked tables
D. Displays a row for records in the primary table with no matching value in the lookup table
正解：A,B,D
質問 3：
Which two methods can you use to add tables to an existing report? (Choose two.)
A. Select Database Expert from Report menu.
B. Select Database Expert from the Insert Menu.
C. Select Database Expert from the Database menu.
D. Click the Database icon in the Expert Toolbar.
正解：C,D
質問 4：
You want to use conditional formatting to link a dynamic image object, corporate_logo.jpg, to a Crystal report. Which format should you use for referencing the location of the graphic image?
A. "C:\Images\corporate_logo.jpg"
B. C:\Images\corporate_logo.jpg
C. [C:\Images\corporate_logo.jpg]
D. {C:\Images\corporate_logo.jpg}
正解：A
質問 5：
Which scope must you use to declare a variable that is used in two subreports?
A. Local
B. Universal
C. Shared
D. Global
正解：C
質問 6：
You create a Crystal report that shows customer names and locations. You use a linked sub report to display details of the orders placed so far this year by each customer. Each customer's total purchases for last year are calculated and stored in the main report and retrieved by the sub report. The sub report must calculate the percentage increase or decrease in orders received this year as compared to each customer's purchases made last year. Which formula should you use to accomplish this?
A. Shared currencyVar cLYS; (Sum ({Orders.Order Amount}) ?cLYS)/cLYS;
B. Global currencyVar cLYS(Sum ({Orders.Order Amount}) ?cLYS)/cLYS;
C. currencyVar cLYS; (cLYS - Sum ({Orders.Order Amount}))/ Sum ({Orders.Order Amount});
D. Shared currencyVar cLYS(Sum ({Orders.Order Amount}) ?cLYS)/ Sum ({Orders.Order Amount});
正解：A
You are creating a report and you open the Field Explorer. The field names are random alphanumeric values. Which database option should you enable to see an alternative to the field names?
A. Show Aliases
B. Show Name
C. Show Description
D. Show Distinguished Name
正解：C
質問 2：
What are three characteristics of a Full Outer Join? (Choose three.)
A. Displays a row for records with matching values in both tables
B. Bidirectional join that displays all records in the linked tables
C. Unidirectional join that displays all records in the linked tables
D. Displays a row for records in the primary table with no matching value in the lookup table
正解：A,B,D
質問 3：
Which two methods can you use to add tables to an existing report? (Choose two.)
A. Select Database Expert from Report menu.
B. Select Database Expert from the Insert Menu.
C. Select Database Expert from the Database menu.
D. Click the Database icon in the Expert Toolbar.
正解：C,D
質問 4：
You want to use conditional formatting to link a dynamic image object, corporate_logo.jpg, to a Crystal report. Which format should you use for referencing the location of the graphic image?
A. "C:\Images\corporate_logo.jpg"
B. C:\Images\corporate_logo.jpg
C. [C:\Images\corporate_logo.jpg]
D. {C:\Images\corporate_logo.jpg}
正解：A
質問 5：
Which scope must you use to declare a variable that is used in two subreports?
A. Local
B. Universal
C. Shared
D. Global
正解：C
質問 6：
You create a Crystal report that shows customer names and locations. You use a linked sub report to display details of the orders placed so far this year by each customer. Each customer's total purchases for last year are calculated and stored in the main report and retrieved by the sub report. The sub report must calculate the percentage increase or decrease in orders received this year as compared to each customer's purchases made last year. Which formula should you use to accomplish this?
A. Shared currencyVar cLYS; (Sum ({Orders.Order Amount}) ?cLYS)/cLYS;
B. Global currencyVar cLYS(Sum ({Orders.Order Amount}) ?cLYS)/cLYS;
C. currencyVar cLYS; (cLYS - Sum ({Orders.Order Amount}))/ Sum ({Orders.Order Amount});
D. Shared currencyVar cLYS(Sum ({Orders.Order Amount}) ?cLYS)/ Sum ({Orders.Order Amount});
正解：A
荒木** -
頂いた問題が大分本番のテストに出ていました。きちんと暗記して、合格できました。