Comprehensive Questions
(Frequently Tested) with
Verified Answers Graded A+
There are different components to a data warehouse. Which layer would the informaticist
expect to include various databases in which users and applications interact?
A. data analysis
B. data mining
C. data reports
D. data sources - Answer: D. Data sources
Page 124. The data source layer is where the data is stored to allow users to access it and use it
to run analyses, reports and mining activities.
The nurse needs to retrieve information from a database concerning pressure wounds. The
nurse would complete which operation to find the appropriate information.
A. Establish integrity constraints
B. Manipulation of data
C. Attribute search
D. Query - Answer: D. Query
,Page 121. A query is an operation that is used to directly retrieve and update data from a
database table.
What are the three primary types of relational database systems?
A. Proprietary, closed source and embedded
B. Flat, relational and entity-relationship
C. Open source, relational and embedded
D. Proprietary, open source and embedded - Answer: D. Proprietary, open source and
embedded
Page 120. There are three primary relational database systems: proprietary, open source and
embedded.
Typically, large healthcare facilities need to customize their databases. Because of this, they
tend to use which type of relational databases.
a. Closed source
b. Flat database model
c. Proprietary
d.Embedded - Answer: c. Proprietary
Page 121. Large healthcare enterprises tend to use proprietary relational databases due to their
needs for customization and support.
It is time for the hospital to verify competencies of their clinical staff. Which type of relational
database would the facility use to complete this task?
a.Virtual dashboard
b. National Quality Forum (NQF)
,c. Learning management system (LMS)
d. Clinical dashboard - Answer: c. Learning management system (LMS)
Page 128. LMS are databases that provide educational services for users
When using a relational database, the nurse knows that these rules protect the validity of the
data.
A. Integrity
B. Security
C. Entity
D. HIPPA . - Answer: A. Integrity
Page 124. Relational databases allow the enforcement of integrity rules, which protect the
validity of the data
After teaching a class on databases in the hospital setting, the nurse informaticist overhears
participants discussing the information. Which statement made by a participant, shows that the
information was correctly understood?
a. "Databases make it difficult for users to locate data."
b. "Databases can store large amounts of data efficiently."
c. "Databases take up large amounts of storage space."
d. "Databases are only used for accounting and billing purposes." - Answer: b. "Databases can
store large amounts of data efficiently."
Page 119. The only true answer is that databases can store large amounts of data efficiently. All
other answers are false.
, A nurse practitioner group is looking for the best database for their practice. They would like the
data to be linked together and would also like to be able to utilize mobile applications. Which
type of database would be best for this practice?
a. Proprietary relational database
b. Flat database
c. Open source relational database
d. Embedded relational database - Answer: d. Embedded relational database
Page 120-121. Embedded relational databases are packaged as part of other software or
applications - for example a mobile application to store phone numbers. More HCPs are using
this type of database due to the popularity of mobile applications.
A data warehouse consists of which of the following components? Select all that apply.
A. Data sources
B. Decision support systems
C. Data forms
D. Primary keys
E.Database management system - Answer: A. Data sourcesand B. Decision support systems
Page 125, figure 7-6
The reporting capacity of the Collaborative Alliance for Nursing Outcomes (CALNOC) system
allows those hospitals who are members to create their own _________________, which
contains selected performance measures to meet their needs for projects such as performance
initiatives.
a. Electronic health records