Deck 10: Database Management

Question 1

The HIM professional can play a significant role in the design and implementation of networks for data exchange efforts.

Answer 1

True

Question 2

Databases are a relatively new concept that emerged with the advent of computers.

Answer 2

True

Question 3

Databases are a relatively new concept.

Answer 3

True

Question 4

Under HIPAA, a limited data set refers to a form of data that includes direct identifiers, along with other data such as city, state, zip code, dates of service, date of birth, or date of death.

Question 5

Concurrency controls refers to the ability of a database to resolve a conflict between two simultaneous uses of the same portion of the same database.

Question 6

HIPAA has mandated certain data set requirements.

Question 7

Database management programs have the ability to allow access to multiple users.

Question 8

Database design is a function of the information system's life cycle, and it typically occurs toward the end of the life cycle.

Question 9

Data Dictionary refers to the process of linking terminology between two different schemes-a target and a source-for a given purpose.

Question 10

The total number of databases is unknown because new databases can be created at any time.

Question 11

End users interact with a database through graphical user interfaces, not query languages.

Question 12

National Health Information Infrastructure (NHII) is also referred to as a National Health Information Network (NHIN).

Question 13

Traceability can be broken down into four elements which are general information, description, logical characteristics, and physical characteristics.

Question 14

Many consider RHIOS to be health care clearinghouses subject to the HIPAA Privacy and Security Rules.

Question 15

Data standards only benefit many people within the health care community.

Question 16

Data warehousing and data mining techniques have been used in health care for some time, and they are now being adopted by the commercial industry.

Question 17

The ORYX Initiative is a minimum data set applicable to the accreditation process.

Question 18

The creation of regional networks to exchange patient data is primarily limited to action being taken at the federal level.

Question 19

A data set is a collection of related data items for each patient.

Question 20

Data warehouses and data mining are related in that data warehouses are a good source of data to be mined.

Question 21

Which refers to the process of linking terminology between two different schemes, a target and a source, for a given purpose?

A) database management
B) data dictionary
C) data mapping

Question 22

The RHIO (regional health information organization) is a collaborative effort to accomplish what?

A) interoperability
B) development of limited data sets
C) national identifiers
D) online analytical processing applications

Question 23

Two patients are scheduled for the same time slot when using the computer scheduling system. This demonstrates a problem in which of the following areas?

A) concurrency control
B) access control
C) scheduling control
D) integrity control

Question 24

Virtually every personal computer in use today utilizes GUIs.

Question 25

HIPAA has mandated unique identifiers for which of the following groups?

A) health care employers
B) health care providers
C) patients
D) a and b
E) a, b, and c

Question 26

Which model focuses on semantic objects, which are collections of attributes and identifiers that sufficiently describe a distinct entity?

A) SOM
B) E-R model
C) DDM model

Question 27

Database management is central to which of the following areas?

A) practice of health information management
B) statistics
C) research
D) all of the above

Question 28

What year were databases developed?

A) 1960
B) 1970
C) 1980
D) 1985

Question 29

A method of displaying text and graphics on a computer screen is which of the following?

A) structured query language (SQL)
B) object query language (OQL)
C) graphical user interface (GUI)

Question 30

OASIS is an examples of what?

A) a data set
B) a data element
C) a minimum data set
D) a and c
E) a and b

Question 31

When patients are categorized according to personal characteristics, services received, facilities used, and sources of payment, it is called what?

A) a data set
B) a data element
C) a minimum data set

Question 32

Uniform Discharge Data Set is used to collect data in an outpatient setting.

Question 33

A database server is a tool to process and organize large amounts of data into information.

Question 34

MDS requires a patient assessment within how many days of admission?

A) 5
B) 10
C) 14
D) 21

Question 35

Information on a patient such as admission date, date of birth, and principal diagnosis would be an example of what?

A) a data set
B) a data element
C) a minimum data element

Question 36

As a result of increases in the power of computer storage, databases continue to grow in storage capacity.

Question 37

Information is best defined by which of the following?

A) knowledge resulting from the processing of data
B) structured storage or collection of data
C) standardized definitions of each data element
D) ability to manage a database

Question 38

The data collected are used primarily to assess the outcomes of treatment.

Question 39

The relation model where data are stored in one or more relations or tables containing attributes emerged in the early

A) 1960s.
B) 1970s.
C) 1980s.
D) 1990s.

Question 40

Which of the following users have access to the knowledge stored by The National Health Information Infrastructure (NHII)?

A) all health care professionals
B) providers only
C) consumers
D) patients
E) all the above

Question 41

The three control functions used in databases are ____________________, ____________________, and ____________________.

Question 42

Match the terms with their descriptors.
uniform uses of common terms and common methods for sharing data

A)data model
B)concurrency control
C)access control
D)integrity control
E)data standards
F)information system
G)interface
H)EDI (electronic data interchange)
I)Health Level Seven (HL7)
J)ASC X12

Question 43

Match the terms with their descriptors.
refers to the ability of the database management system to check all entered data against specified constraints or rules and determine if there is an inconsistency

A)data model
B)concurrency control
C)access control
D)integrity control
E)data standards
F)information system
G)interface
H)EDI (electronic data interchange)
I)Health Level Seven (HL7)
J)ASC X12

Question 44

A(n) ____________________ data set is an agreed upon and accepted set of terms and uniform definitions constituting a core of data.

Question 45

The proper management of databases can assist in ensuring _________ and the _________ of research studies.

A) statistical validity, correct design
B) concurrency control, access control
C) data model, data standards

Question 46

Uniform uses of common terms and common methods for sharing data are called

A) data model.
B) data standards.
C) information systems.
D) data quality.

Question 47

____________________ ____________________refers to a description of the logical and physical characteristics of an operational database.

Question 48

Match the terms with their descriptors.
refers to the ability of a database to resolve the conflict of two simultaneous uses of the same portion of the same database

A)data model
B)concurrency control
C)access control
D)integrity control
E)data standards
F)information system
G)interface
H)EDI (electronic data interchange)
I)Health Level Seven (HL7)
J)ASC X12

Question 49

A subset of a data warehouse is called

A) data mart.
B) data warehouse.
C) clinical data repository.
D) data mining.

Question 50

__________ refers to a description of the logical and physical characteristics of an operational database.

A) Data
B) Data design
C) Data dictionary
D) Databases

Question 51

The HIPAA ____________________ ____________________ provisions establish data standards for data exchange performed electronically.

Question 52

Match the terms with their descriptors.
hardware or software necessary to connect the components of an information system together or connect one information system to another

A)data model
B)concurrency control
C)access control
D)integrity control
E)data standards
F)information system
G)interface
H)EDI (electronic data interchange)
I)Health Level Seven (HL7)
J)ASC X12

Question 53

A set of connecting and communicating computers, devices, and software that support the delivery of patient care and the day-to-day business of health care is called

A) information systems.
B) data standards.
C) interface.
D) electronic data interchange.

Question 54

Match the terms with their descriptors.
representation of exactly what a database should exemplify to the end user

A)data model
B)concurrency control
C)access control
D)integrity control
E)data standards
F)information system
G)interface
H)EDI (electronic data interchange)
I)Health Level Seven (HL7)
J)ASC X12

Question 55

The four elements of entity relationship are all of the following EXCEPT

A) models.
B) entities.
C) relationships.
D) identifiers.

Question 56

A representation of exactly what a database should exemplify to the end user is called

A) data model.
B) data standards.
C) information systems.
D) data quality.

Question 57

The two major messaging standards development organizations for health information are

A) Electronic Data Interchange (EDI).
B) Health Level Seven (HL7).
C) Accredited Standards Committee (ASC) X12.
D) a and b, not c
E) b and c, not a

Question 58

The electronic storage of data and information for individual patient medical records is called

A) data mart.
B) data warehouse.
C) clinical data repository.
D) data mining.

Question 59

________ is a language used by nonprogrammers to retrieve information contained in relational databases.

A) Object query language
B) Graphical user interface
C) Structured query language

Question 60

Match the terms with their descriptors.
involves the level of permission granted to a particular user

A)data model
B)concurrency control
C)access control
D)integrity control
E)data standards
F)information system
G)interface
H)EDI (electronic data interchange)
I)Health Level Seven (HL7)
J)ASC X12

Question 61

Match the terms with their descriptors.
an ANSI-accredited SDO that develops specifications for communication between software applications

A)data model
B)concurrency control
C)access control
D)integrity control
E)data standards
F)information system
G)interface
H)EDI (electronic data interchange)
I)Health Level Seven (HL7)
J)ASC X12

Question 62

Match the term to its descriptor.
a subset of a data warehouse

A)clinical data repository
B)data warehouses
C)online analytical processing (OLAP) applications
D)data mart
E)data mining

Question 63

How did the development of database management programs in the 1960s revolutionize the practical nature of computers in the work environment?

Question 64

Match the terms with their descriptors.
an ANSI-accredited SDO that develops specifications that allow different health care software applications within an organization to communicate with one another

A)data model
B)concurrency control
C)access control
D)integrity control
E)data standards
F)information system
G)interface
H)EDI (electronic data interchange)
I)Health Level Seven (HL7)
J)ASC X12

Question 65

Match the term to its descriptor.
allows an end user to access data housed in the data warehouse and to combine the results into a single question-and-reporting interface

A)clinical data repository
B)data warehouses
C)online analytical processing (OLAP) applications
D)data mart
E)data mining

Question 66

What is the difference in focus between HL7 and X12?

Question 67

What is a data design specification and what purpose does it serve?

Question 68

Match the terms with their descriptors.
set of connecting and communicating computers, devices, and software that support the delivery of patient care and the day-to-day business of health care

A)data model
B)concurrency control
C)access control
D)integrity control
E)data standards
F)information system
G)interface
H)EDI (electronic data interchange)
I)Health Level Seven (HL7)
J)ASC X12

Question 69

Match the term to its descriptor.
very large databases that store both historical and current information from a variety of sources and are optimized for fast query answering

A)clinical data repository
B)data warehouses
C)online analytical processing (OLAP) applications
D)data mart
E)data mining

Question 70

What are the two types of data modeling systems currently in use?

Question 71

Match the terms with their descriptors.
method of electronic mail messaging conveyed between computers without manual intervention

A)data model
B)concurrency control
C)access control
D)integrity control
E)data standards
F)information system
G)interface
H)EDI (electronic data interchange)
I)Health Level Seven (HL7)
J)ASC X12

Question 72

Why has the Uniform Hospital Discharge Data Set (UHDDS) become a standard for reporting across all patient categories to both the state and private sectors?

Question 73

Match the term to its descriptor.
the electronic storage of data and information for individual patient medical records

A)clinical data repository
B)data warehouses
C)online analytical processing (OLAP) applications
D)data mart
E)data mining

Question 74

Match the term to its descriptor.
process of finding unknown dependencies in large data sets through automated means

A)clinical data repository
B)data warehouses
C)online analytical processing (OLAP) applications
D)data mart
E)data mining