Epic Crystal Reporting/Clarity/SQL Exam Questions And Correct Answers New Update

Epic Crystal Reporting/Clarity/SQL Exam Questions And Correct Answers New Update 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) This section will show up at the bottom of every page - Answer -Page Footer (PF) What are the 5 report sections for Crystal reports? - Answer -1. Report Header (RH) 2. Page Header (PH) 3. Details (D) 4. Report Footer (RF) 5. Page Footer (PF) What is the purpose of the field explorer in Crystal Reports? - Answer -It is used to insert, modify, or delete fields on the Design or Preview tabs