Bluekey Technical Test Level 3

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Shreyashah03
S
Shreyashah03
Community Contributor
Quizzes Created: 5 | Total Attempts: 3,223
| Attempts: 147
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/20 Questions

    A subreport that gets its parameter values from fields in the main report is a

    • Unlinked subreport
    • Linked subreport
Please wait...
About This Quiz

The 'BLUEKEY TECHNICAL TEST LEVEL 3' assesses knowledge in creating and managing reports using Crystal Reports. It covers topics from basic control setup to advanced data sharing and subreport management, crucial for developers and IT professionals.

Bluekey Technical Test Level 3 - Quiz

Quiz Preview

  • 2. 

    The _______ pane in the Standard Report Creation Wizard allows database tables to be added to a report.

    • Available Data Sources

    • Available Field Sources

    • Available Group Sources

    • Available Select Sources

    Correct Answer
    A. Available Data Sources
    Explanation
    The "Available Data Sources" pane in the Standard Report Creation Wizard allows users to add database tables to a report. This pane provides a list of available data sources that can be selected and added to the report, allowing users to access and analyze data from different tables in their database. By choosing the appropriate data sources, users can include the necessary information in their report and generate meaningful insights.

    Rate this question:

  • 3. 

    What page in the Standard Report Creation Wizard allows you to choose the field on which to sort a report?

    • Data

    • Fields

    • Grouping

    • Select

    Correct Answer
    A. Grouping
    Explanation
    The Grouping page in the Standard Report Creation Wizard allows you to choose the field on which to sort a report. This page allows you to group and organize the data in the report based on specific fields. By selecting the desired field on this page, you can sort the report based on that field, providing a clear and organized presentation of the data.

    Rate this question:

  • 4. 

    Which methods can be used to share data between a report and a subreport?

    • Selection Formulas

    • Global variables

    • Shared variables

    • Stored procedures

    Correct Answer
    A. Shared variables
    Explanation
    Shared variables can be used to share data between a report and a subreport. Shared variables are variables that can be accessed and modified by multiple sections or subreports within a report. The value assigned to a shared variable in one section or subreport can be accessed and used in another section or subreport. This allows for the sharing of data between different components of a report, enabling the subreport to access and display data from the main report.

    Rate this question:

  • 5. 

     The Add Command is supported for which of the following database types?

    • Oracle

    • DB2

    • Informix

    • Sybase

    Correct Answer
    A. Oracle
    Explanation
    The Add Command is supported for the Oracle database type.

    Rate this question:

  • 6. 

    If Convert Other NULL Values to Default is checked, then

    • NULL string formulas will return blank.

    • NULL numeric database fields will display as zero.

    • NULL string database fields will display as blank.

    Correct Answer
    A. NULL string formulas will return blank.
    Explanation
    If the "Convert Other NULL Values to Default" option is selected, it means that any NULL string formulas will be converted to blank. This means that if there is a formula that results in a NULL string value, it will be displayed as blank.

    Rate this question:

  • 7. 

    What do you need to add to a project in order to create and display a simple report using Crystal Reports?

    • CrystalReportSource control

    • CrystalReportViewer control

    • CrystalReportSource and CrystalReportViewer controls

    • CrystalReportViewer control and a reference to CrystalReports

    Correct Answer
    A. CrystalReportSource and CrystalReportViewer controls
    Explanation
    To create and display a simple report using Crystal Reports, you need to add both the CrystalReportSource and CrystalReportViewer controls to the project. The CrystalReportSource control is responsible for providing the report data to the CrystalReportViewer control, which then displays the report on the screen. Additionally, you may also need to add a reference to CrystalReports in order to access the necessary functionality and features of Crystal Reports.

    Rate this question:

  • 8. 

    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}

    • Zero

    • $1.50

    • NULL

    • An error

    • 1

    Correct Answer
    A. NULL
    Explanation
    The result of the formula is NULL because any arithmetic operation involving a NULL value will yield a NULL result. In this case, since the Quantity is NULL, multiplying it by the Price will result in a NULL value.

    Rate this question:

  • 9. 

    The Current Connections folder lists

    • Data sources used in the active report file

    • Data sources used in all open report files

    • Connected data sources for the active report file

    • Connected data sources for all open report files

    • All connected data sources

    Correct Answer
    A. All connected data sources
    Explanation
    The Current Connections folder in this context refers to a feature or section in a software or application that displays information about the connected data sources. The correct answer states that it lists all connected data sources, indicating that it provides a comprehensive view of all the data sources that are currently connected to the active report file or all open report files. This means that it includes data sources used in the active report file, data sources used in all open report files, and any other connected data sources.

    Rate this question:

  • 10. 

    What page in the Standard Report Creation Wizard allows you to select the fields that will display on the detail lines of the report

    • Data

    • Fields

    • Group

    • Select

    Correct Answer
    A. Fields
    Explanation
    The page in the Standard Report Creation Wizard that allows you to select the fields that will display on the detail lines of the report is "Fields". This page provides the option to choose the specific data fields that you want to include in the report's detail lines, allowing you to customize the information displayed and tailor it to your needs.

    Rate this question:

  • 11. 

    What page in the Standard Report Creation Wizard allows database fields from related tables to be linked?

    • Data

    • Fields

    • Link

    • Select

    Correct Answer
    A. Link
    Explanation
    The Link page in the Standard Report Creation Wizard allows database fields from related tables to be linked. This page allows the user to establish relationships between tables by selecting the appropriate fields to link. This is important in order to retrieve data from multiple tables and create meaningful reports that include data from related tables.

    Rate this question:

  • 12. 

    To fill a dataset for a report, what do you need to include at the top of the file?

    • Imports CrystalDecisions.CrystalReports

    • CrystalDecisions.CrystalReports.Engine

    • Exports CrystalDecisions.CrystalReports.Engine

    • Imports CrystalDecisions.CrystalReports.Engine

    Correct Answer
    A. Imports CrystalDecisions.CrystalReports.Engine
    Explanation
    To fill a dataset for a report, you need to include the "Imports CrystalDecisions.CrystalReports.Engine" statement at the top of the file. This statement allows you to access and use the functionality provided by the Crystal Reports Engine, which is necessary for filling the dataset with the required data. The other statements mentioned in the options are either incorrect or not relevant to the task of filling a dataset for a report.

    Rate this question:

  • 13. 

    Which utility can be used to test ODBC connections and run queries?

    • SQLCon32

    • ODBC Trace

    • Dependency Walker

    • Modules

    Correct Answer
    A. SQLCon32
    Explanation
    SQLCon32 is a utility that can be used to test ODBC connections and run queries. It is specifically designed for this purpose and provides a user-friendly interface to connect to ODBC data sources, test the connection, and execute SQL queries. It allows users to validate the ODBC configuration, troubleshoot any connection issues, and verify the correctness of SQL statements. SQLCon32 is a commonly used tool by database administrators and developers to ensure the smooth functioning of ODBC connections and query execution.

    Rate this question:

  • 14. 

    You begin creating a report by adding a new _______ control to a project

    • CrystalReportSource

    • ReportDesigner

    • CrystalReportViewer

    • ReportForm

    Correct Answer
    A. CrystalReportSource
    Explanation
    To begin creating a report, you need to add a new CrystalReportSource control to your project. This control acts as a source for the Crystal Reports functionality and allows you to connect to data sources, define report layouts, and generate reports. By adding the CrystalReportSource control, you can then proceed to design and view the report using other tools and controls such as ReportDesigner or CrystalReportViewer. The ReportForm option is not a valid control for creating reports.

    Rate this question:

  • 15. 

    A shared variable must be declared in the main report before it is used in a subreport.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    A shared variable does not need to be declared in the main report before it is used in a subreport. Shared variables are used to pass values between the main report and subreport, and they can be declared and used in either the main report or the subreport, as long as they have the same name and data type. Therefore, the answer is false.

    Rate this question:

  • 16. 

    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?

    • 75

    • 50

    • NULL

    • An error

    • Zero

    Correct Answer
    A. 75
    Explanation
    The average will be 75 because when calculating the average, the NULL value is not included in the calculation. Therefore, the average is calculated by adding the two non-NULL values (100 and 50) and dividing the sum by the number of non-NULL values, which is 2. This results in an average of 75.

    Rate this question:

  • 17. 

    Which of the following cannot be used in a record selection formula that is passed to the server?

    • %Discount

    • @Discount

    • ?Discount

    • IsNull

    Correct Answer
    A. @Discount
    Explanation
    The "@" symbol is used to refer to a variable in a record selection formula. Therefore, "@Discount" can be used in a record selection formula that is passed to the server.

    Rate this question:

  • 18. 

    On-demand subreports are or can be

    • Cannot open in their own preview tab

    • Parameters

    • Executed when the user does not click the hyperlink

    • Opened in-place in the report

    Correct Answer
    A. Opened in-place in the report
    Explanation
    On-demand subreports are opened in-place in the report, meaning that they are displayed within the main report itself rather than in a separate preview tab. This allows for a seamless integration of the subreport within the main report, providing relevant information to the user without the need to navigate away from the main report. Additionally, on-demand subreports are executed automatically when the main report is run, even if the user does not click on the hyperlink associated with the subreport.

    Rate this question:

  • 19. 

    What do you need to setup to assist in the selection of a report and to allow it to display on a second form?

    • Array

    • Viewer

    • Enum

    • Provider

    Correct Answer
    A. Enum
    Explanation
    To assist in the selection of a report and allow it to display on a second form, an enum (enumeration) needs to be set up. An enum is a data type that consists of a set of named values, making it easier to define and work with a set of related constants. In this case, the enum can be used to define and store the available reports, allowing the user to select one from a list. The selected report can then be passed to the second form for display.

    Rate this question:

  • 20. 

    OLE DB is similar to ODBC except that

    • No database layer is required.

    • An OLE DB provider is required instead of an ODBC driver.

    • Crystal Reports does not supply OLE DB providers.

    • Crystal Reports does not supply ODBC drivers.

    • OLE DB only works against Microsoft databases.

    Correct Answer
    A. Crystal Reports does not supply ODBC drivers.
    Explanation
    The correct answer is Crystal Reports does not supply ODBC drivers. This means that Crystal Reports does not provide the necessary drivers to connect to databases using the ODBC protocol. Instead, Crystal Reports requires the use of OLE DB providers to establish connections with databases. OLE DB is a data access technology that provides a consistent interface for accessing different types of data sources, including Microsoft databases.

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 20, 2016
    Quiz Created by
    Shreyashah03
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.