Epic Crystal Reporting/Clarity/SQL Exam Questions And Correct Answers (GRADED A)
7 views 0 purchase
Course
Clarity CLR 110
Institution
Clarity CLR 110
What is a relational database? - ANSWER A relational database contains related tables, and these tables can be linked together based on the relationship between the fields in two or more tables
Each table in a relational database contains _______ _______ and contains a _______ of intersecting ro...
Epic Crystal Reporting/Clarity/SQL 2024-2025
Exam Questions And Correct Answers
(GRADED A)
What is a relational database? - ANSWER A relational database contains related tables, and these tables
can be linked together based on the relationship between the fields in two or more tables
Each table in a relational database contains _______ _______ and contains a _______ of intersecting
rows and columns of data - ANSWER one concept; series
SAP BusinessObject has created _______________ to report with relational databases. - ANSWER Crystal
___________ is a relational database used to store and report on your organization's Epic data. -
ANSWER Clarity
We use _________ to report off of _________ - ANSWER Crystal; Clarity
What is another name for a row? - ANSWER Record
What is Clarity's primary purpose? - ANSWER To store an organization's Epic data purely for reporting
purposes
Does EPIC offer its own tools for creating reports off of Clarity? - ANSWER No. That's why we use Crystal
Reports
A department in CLARITY_DEP is represented as one ____________. - ANSWER Row
True/False: In the PATIENT table, different pieces of information pertaining to one patient are stored in
different columns - ANSWER True
,Describe a "row" and a synonym for it - ANSWER A row contains a complete unit of related information,
and they are often called "records"
Describe a database - ANSWER A container of data that provides information for a report and can also be
called data sources
What are the three different methods for creating a new report within Crystal Reporting? - ANSWER 1.
Report Wizard
2. Blank Report Option
3. Base a report off of a pre-exsiting report (My Recent Reports)
What is the first step when creating a new report? - ANSWER To specify the data source
We access the Clarity Database through an ______ layer - ANSWER ODBC
What does ODBC stand for? - ANSWER Open Database Connectivity
What is an ODBC? - ANSWER An interface that allows Crystal the ability to retrieve data in database
management systems
Do views hold data? - ANSWER No. Views are created simply to simplify reporting on certain types of
information. They don't hold data, but run queries against other Clarity tables and present the results in
a form that can be used as a table
In Crystal Reports, the term "field" is used to refer to what? - ANSWER Refers to anything you can drag
onto your report. This includes database columns, formulas, text, as well as special functions
What area will you spend most of your time in when creating a Crystal Report? - ANSWER The Design Tab
This section only shows up on the top of the first page of a report - ANSWER Report Header (RH)
, This section with show up on the top of every single page - ANSWER Page Header (PH)
This section will be repeated for every row of data returned on your report and will contain the bulk of
the report data - ANSWER Details (D)
This section will only show up on the bottom of the last page of the report - ANSWER Report Footer (RF)
_________ __________ the main area of the Preview tab. This is where your results are displayed
(Crystal) - ANSWER Standard View
What is the shortcut for to access the Design tab in Crystal? - ANSWER CTRL+D
What is the shortcut for to access the Preview tab in Crystal? - ANSWER CTRL+R
_________ _________ will contain information such as report author, report title, and comments
(Crystal) - ANSWER Summary Information
By unchecking _________________ it will ensure you are only saving the report definition. - ANSWER
Save Data with Report
Columns from Clarity tables in the report will show up in the Field Explorer under ________ ________ -
ANSWER Database Fields
Where should you primarily complete your report layout and design in Crystal? - ANSWER Design Tab
What is the purpose of the Database Expert? - ANSWER It is used to connect Crystal Reports to your
Clarity database
This contains database fields accessible for your report (Crystal) - ANSWER Report Fields
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller shantelleG. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
