Crystal Reports and Dashboard Beginner Quiz

Posted on: | By: – Comments Off

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Infostore[/bg_collapse]
 
2
Location where Crystal Report files reside in Server is called ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : FileStore[/bg_collapse]
 
3
Location where report objects are stored is called ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Input FileStore[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Encapsulated Page Format[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Business View[/bg_collapse]
 
6
What is the File Extension used for Crystal reports ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : .RPT[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Record Explorer[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All the above[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All the above[/bg_collapse]



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both A & B[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Can Grow property[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Select Expert[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both B & C[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both B & C[/bg_collapse]
 
15
Which of the following is not a Scope of variable is Crystal reports ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Temporary[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Global variables can be used to share values between reports[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Section Underlay[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Alert[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A sub report can be created inside another sub report[/bg_collapse]



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both A & B[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : On Demand Sub Report[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : None of the above[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both A & B[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Data tab can be used to create virtual tables[/bg_collapse]
 
25
Tool used to Filter records is Crystal Reports is called

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Select Expert[/bg_collapse]
 
26
CrystalReports processes reports in how many passes ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : 3 Passes[/bg_collapse]
 
27
Which of the following is not a evaluation time function in Crystal Reports ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : AfterReadingRecords[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Unlinked Sub reports[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Alerts[/bg_collapse]



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Used to Manage Multiple report Projects[/bg_collapse]
 
31
BO Dashboard is a tool for

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Data Visualization[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Line chart[/bg_collapse]
 
33
XY chart is also called as

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Scatter plot chart[/bg_collapse]
 
34
Dashboard visual model is compiled to which file format?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : SWF[/bg_collapse]
 
35
Saved dashboard file will have following extension

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : XLF[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Dynamic visibility[/bg_collapse]
 
37
Dynamic visibilty option is available in which tab of property window

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : behaviour[/bg_collapse]
 
38
Templates can be added to the existing charts in Dashboard

  1. No
  2. yes

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : No[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Themes[/bg_collapse]



40
A circular chart divided into one or more slices

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Pie chart[/bg_collapse]
 
41
The component used for displaying the charts in a slide show format

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : panel container[/bg_collapse]
 
42
For highlighting the values at a particular threshold, we must use___________

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Alerts[/bg_collapse]
 
43
dashboards are oraganized in __________ tool

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Dashboard Builder[/bg_collapse]
 
44
which tab in not available in the homepage of Dashboard design

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : explorer[/bg_collapse]
 
45
Data Visualization is the key feature of which BO tool

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Dashboard Builder[/bg_collapse]
 


Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz