Crystal Reports and Dashboard Beginner Quiz

Crystal Reports and Dashboard Beginner Quiz




1
Database used to store information about users, folders, reports in Crystal Reports Enterprise is called ?

  1. DataStore
  2. Infostore
  3. MetaStora
  4. ObjectStore

Answer : Infostore

 
2
Location where Crystal Report files reside in Server is called ?

  1. MetaStore
  2. ReportStore
  3. FileStore
  4. ObjectStore

Answer : FileStore

 
3
Location where report objects are stored is called ?

  1. Input FileStore
  2. Output FileStore
  3. Report Templates
  4. Output Directory

Answer : Input FileStore

 
4
The report pages retrieved by Page Server are saved in which Format ?

  1. Encapsulated Page Format
  2. Encrypted Page Format
  3. Enhanced Page Format
  4. None of the above

Answer : Encapsulated Page Format

 
5
The metadata layer that abstracts complexity of data source in Crystal Reports is called ?

  1. Business Model
  2. Business View
  3. Query Views
  4. Report Views

Answer : Business View

 
6
What is the File Extension used for Crystal reports ?

  1. .BQY
  2. .REP
  3. .RPT
  4. .CRT

Answer : .RPT

 
7
Which of the following is not one of the explorers available in Crystal Reports ?

  1. Report Explorer
  2. Record Explorer
  3. Repository Explorer
  4. Field Explorer

Answer : Record Explorer

 
8
Which of the following is not a object type saved in Crystal Reports repository ?

  1. Bitmaps
  2. SQL Commands
  3. Custom functions
  4. All the above

Answer : All the above

 
9
Crystal Reports can be exported to the following text formats.

  1. Tab Separated Text (TTX)
  2. Comma Separated Values (CSV)
  3. Reich Text Format (RTF)
  4. All the above

Answer : All the above




10
Which of the following is true regarding SAP Crystal reports 2013 & Crystal Reports for Enterprise 4.1

  1. Crystal Reports can connect to BO Universe (.UNV)
  2. Crystal Reports For Enterprise can connect to new BO Semantic Layer (.UNX)
  3. Crystal Reports for Enterprise connects to both .UNV & .UNX files
  4. Both A & B

Answer : Both A & B

 
11
Which property prevents truncation of text objects by allowing the text box to expand vertically to fit all text

  1. Expand property
  2. Can Grow property
  3. Auto Size property
  4. Auto width property

Answer : Can Grow property

 
12
Tool used to select records to be displayed in Crystal reports is called ?

  1. Data Expert
  2. Select Expert
  3. Record Expert
  4. Column Expert

Answer : Select Expert

 
13
Group Tree is used to __________

  1. Display cascading prompts in a tree structure
  2. Display group headings in a tree structure with the ability to expand group to view other group levels
  3. Simplify navigation through a large report with multiple groups
  4. Both B & C

Answer : Both B & C

 
14
Add Command in Database Expert is used to _____________________

  1. Pass command line arguments to Crystal reports
  2. Create Virtual table based on a SQL Query in Crystal Reports
  3. Create a SQL command object which can be used as data source for Crystal Reports
  4. Both B & C

Answer : Both B & C

 
15
Which of the following is not a Scope of variable is Crystal reports ?

  1. Global
  2. Temporary
  3. Local
  4. Shared

Answer : Temporary

 
16
Which of the following is Not True with respect to variables in Crystal Reports ?

  1. Scope of variable is Global by default
  2. Shared variables are used to share values between main report and sub report
  3. Global variables can be used to share values between reports
  4. Local variables can only be accessed within the formula in which they are declared

Answer : Global variables can be used to share values between reports

 
17
To display one section on top of another, following feature in Crystal reports can be used.

  1. Section Overlay
  2. Section Underlay
  3. Section Overwrite
  4. Section Background

Answer : Section Underlay

 
18
To display a customized message when a condition is satisfied by data in a report, following feature can be used

  1. Conditional Formating
  2. Conditional Highlighting
  3. Alert
  4. None of the above

Answer : Alert

 
19
Which of the following is not true with respect to Sub Reports in Crystal Reports ?

  1. Sub-reports cannot stand on their own and need to be embedded in a main report
  2. A Sub report can be saved as a main report
  3. A sub report can be created inside another sub report
  4. A sub report can be placed in any report section

Answer : A sub report can be created inside another sub report




20
A sub-report can be used in which of the following cases ?

  1. Combine un-related reports within a main report
  2. Combine related reports within a main report
  3. Both A & B
  4. Neither A nor B

Answer : Both A & B

 
21
A sub-report in which data is not retrieved from the database unless the user clicks on the hyperlink is called ?

  1. Un-related sub report
  2. On Demand Sub Report
  3. Hyperlink Sub report
  4. Regular Sub-report

Answer : On Demand Sub Report

 
22
Which of the following is not one of the Loop control structures in Crystal Reports ?

  1. For Loop
  2. While Loop
  3. Option Loop
  4. None of the above

Answer : None of the above

 
23
Data can be passed between main report and sub report in the following ways

  1. Using Shared Variables
  2. Using Parameters
  3. Using Local Variables
  4. Both A & B

Answer : Both A & B

 
24
Which of the following is not true regarding Database Expert in Crystal Reports ?

  1. Data tab is used to select the tables
  2. Links tab is used to link 2 or more tables together
  3. Links tab appears only when more than one table is selected in data tab
  4. Data tab can be used to create virtual tables

Answer : Data tab can be used to create virtual tables

 
25
Tool used to Filter records is Crystal Reports is called

  1. Filter Expert
  2. Select Expert
  3. Query Expert
  4. Database Expert

Answer : Select Expert

 
26
CrystalReports processes reports in how many passes ?

  1. 4 Passes
  2. 3 Passes
  3. 5 Passes
  4. 1 Pass

Answer : 3 Passes

 
27
Which of the following is not a evaluation time function in Crystal Reports ?

  1. BeforeReadingRecords
  2. AfterReadingRecords
  3. WhileReadingRecords
  4. WhilePrintingRecords

Answer : AfterReadingRecords

 
28
Free standing sub reports where data is not co-ordinated between sub report and main report are called ________________

  1. Unlinked Sub reports
  2. Pass Through Sub reports
  3. Pass-by Sub reports
  4. Regular Sub report

Answer : Unlinked Sub reports

 
29
Custom messages in a Crystal report that appear when certain conditions are met are called _______

  1. Custom Messages
  2. Highlighters
  3. Alerts
  4. Prompts

Answer : Alerts




30
Crystal Reports Workbench is  _______________________

  1. Workspace used to Modify Reports
  2. Used to Manage Multiple report Projects
  3. Workspace used to create and modify Sub Reports
  4. None of the above

Answer : Used to Manage Multiple report Projects

 
31
BO Dashboard is a tool for

  1. Query and Analysis
  2. Data Visualization
  3. Data Mining
  4. A & C

Answer : Data Visualization

 
32
Type of chart useful to visualize data that changes over a period of time

  1. Line chart
  2. Pie chart
  3. radar chart
  4. None of the above

Answer : Line chart

 
33
XY chart is also called as

  1. bubble chart
  2. combination chart
  3. Scatter plot chart
  4. bar chart

Answer : Scatter plot chart

 
34
Dashboard visual model is compiled to which file format?

  1. PDF
  2. SWF
  3. AIR
  4. PPT

Answer : SWF

 
35
Saved dashboard file will have following extension

  1. XLF
  2. XLS
  3. DOC
  4. XLC

Answer : XLF

 
36
Feature that allows you to control when a component is visible based on the contents of a spreadsheet  cell is called

  1. show/ hide option
  2. interactive display
  3. Dynamic visibility
  4. this feature is not available in Dashboard

Answer : Dynamic visibility

 
37
Dynamic visibilty option is available in which tab of property window

  1. general
  2. alert
  3. appearance
  4. behaviour

Answer : behaviour

 
38
Templates can be added to the existing charts in Dashboard

  1. No
  2. yes

Answer : No

 
39
_________provide an easy way to customize your model and maintain a consistent look throughout the model

  1. templates
  2. Themes
  3. components
  4. charts

Answer : Themes




40
A circular chart divided into one or more slices

  1. bubble chart
  2. trend chart
  3. Pie chart
  4. scatter plot chart

Answer : Pie chart

 
41
The component used for displaying the charts in a slide show format

  1. Canvas container
  2. tabset container
  3. panel container
  4. templates

Answer : panel container

 
42
For highlighting the values at a particular threshold, we must use___________

  1. Alerts
  2. scorecards
  3. gauge
  4. theme

Answer : Alerts

 
43
dashboards are oraganized in __________ tool

  1. BO Analyzer
  2. Web Intelligence
  3. BO explorer
  4. Dashboard Builder

Answer : Dashboard Builder

 
44
which tab in not available in the homepage of Dashboard design

  1. component tab
  2. object browser
  3. explorer
  4. query browser

Answer : explorer

 
45
Data Visualization is the key feature of which BO tool

  1. Web intelligence
  2. Data Explorer
  3. Dashboard Builder
  4. Crystal report

Answer : Dashboard Builder