Bluekey Technical Test Level 3

20 Questions | By Shreyashah03 | Last updated: Mar 21, 2022 | Total Attempts: 143

Questions

Settings

Create your own Quiz

Questions and Answers

1.

What do you need to add to a project in order to create and display a simple report using Crystal Reports?
- A.
  
  CrystalReportSource control
- B.
  
  CrystalReportViewer control
- C.
  
  CrystalReportSource and CrystalReportViewer controls
- D.
  
  CrystalReportViewer control and a reference to CrystalReports
2.

A subreport that gets its parameter values from fields in the main report is a
- A.
  
  Unlinked subreport
- B.
  
  Linked subreport
3.

On-demand subreports are or can be
- A.
  
  Cannot open in their own preview tab
- B.
  
  Parameters
- C.
  
  Executed when the user does not click the hyperlink
- D.
  
  Opened in-place in the report
4.

Which methods can be used to share data between a report and a subreport?
- A.
  
  Selection Formulas
- B.
  
  Global variables
- C.
  
  Shared variables
- D.
  
  Stored procedures
5.

If Convert Other NULL Values to Default is checked, then
- A.
  
  NULL string formulas will return blank.
- B.
  
  NULL numeric database fields will display as zero.
- C.
  
  NULL string database fields will display as blank.
6.

A shared variable must be declared in the main report before it is used in a subreport.
- A.
  
  True
- B.
  
  False
7.

What is the result of the following formula if Quantity is NULL, Price is $1.50, and all report options are at their defaults? {Quantity}*{Price}
- A.
  
  Zero
- B.
  
  $1.50
- C.
  
  NULL
- D.
  
  An error
- E.
  
  1
8.

There are three records in a report. The values of FieldA are 100, NULL, and 50. You insert a summary on FieldA and choose Average. What will the average be?
- A.
  
  75
- B.
  
  50
- C.
  
  NULL
- D.
  
  An error
- E.
  
  Zero
9.

The Current Connections folder lists
- A.
  
  Data sources used in the active report file
- B.
  
  Data sources used in all open report files
- C.
  
  Connected data sources for the active report file
- D.
  
  Connected data sources for all open report files
- E.
  
  All connected data sources
10.

The Add Command is supported for which of the following database types?
- A.
  
  Oracle
- B.
  
  DB2
- C.
  
  Informix
- D.
  
  Sybase
11.

OLE DB is similar to ODBC except that
- A.
  
  No database layer is required.
- B.
  
  An OLE DB provider is required instead of an ODBC driver.
- C.
  
  Crystal Reports does not supply OLE DB providers.
- D.
  
  Crystal Reports does not supply ODBC drivers.
- E.
  
  OLE DB only works against Microsoft databases.
12.

Which of the following cannot be used in a record selection formula that is passed to the server?
- A.
  
  %Discount
- B.
  
  @Discount
- C.
  
  ?Discount
- D.
  
  IsNull
13.

Which utility can be used to test ODBC connections and run queries?
- A.
  
  SQLCon32
- B.
  
  ODBC Trace
- C.
  
  Dependency Walker
- D.
  
  Modules
14.

You begin creating a report by adding a new _______ control to a project
- A.
  
  CrystalReportSource
- B.
  
  ReportDesigner
- C.
  
  CrystalReportViewer
- D.
  
  ReportForm
15.

The _______ pane in the Standard Report Creation Wizard allows database tables to be added to a report.
- A.
  
  Available Data Sources
- B.
  
  Available Field Sources
- C.
  
  Available Group Sources
- D.
  
  Available Select Sources
16.

What page in the Standard Report Creation Wizard allows you to select the fields that will display on the detail lines of the report
- A.
  
  Data
- B.
  
  Fields
- C.
  
  Group
- D.
  
  Select
17.

What do you need to setup to assist in the selection of a report and to allow it to display on a second form?
- A.
  
  Array
- B.
  
  Viewer
- C.
  
  Enum
- D.
  
  Provider
18.

What page in the Standard Report Creation Wizard allows database fields from related tables to be linked?
- A.
  
  Data
- B.
  
  Fields
- C.
  
  Link
- D.
  
  Select
19.

What page in the Standard Report Creation Wizard allows you to choose the field on which to sort a report?
- A.
  
  Data
- B.
  
  Fields
- C.
  
  Grouping
- D.
  
  Select
20.

To fill a dataset for a report, what do you need to include at the top of the file?
- A.
  
  Imports CrystalDecisions.CrystalReports
- B.
  
  CrystalDecisions.CrystalReports.Engine
- C.
  
  Exports CrystalDecisions.CrystalReports.Engine
- D.
  
  Imports CrystalDecisions.CrystalReports.Engine