Bluekey Technical Test Level 3

20 Questions | Total Attempts: 138

SettingsSettingsSettings
Please wait...
Bluekey Technical Test Level 3

.


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

Back to Top Back to top