Question 1

A constraint that has a data field (column) of unique values that is shared with other databases is referred to as what?

Accepted Answer

A)  Unique 
B)  Foreign-key 
C)  Set-membership 
D)  Range 
A)  Unique 
B)  Foreign-key 
C)  Set-membership 
D)  Range

Question 2

Which of the following is an example of a foreign-key constraint?

Accepted Answer

A)  Patient's zip code 
B)  Date of discharge 
C)  Physician ID number 
D)  All of the above 
A)  Patient's zip code 
B)  Date of discharge 
C)  Physician ID number 
D)  All of the above

Question 3

The data set that the information is mapped from is called the __________.

Accepted Answer

A)  synonymy 
B)  target 
C)  source 
D)  reference 
A)  synonymy 
B)  target 
C)  source 
D)  reference

Question 4

A constraint that has limits as to a possible range is called what?

Accepted Answer

A)  Unique 
B)  Mandatory 
C)  Set-membership 
D)  Range 
A)  Unique 
B)  Mandatory 
C)  Set-membership 
D)  Range

Question 5

What measures the quality characteristic of whether data is correct, valid, and free from errors?

Accepted Answer

A)  Completeness 
B)  Accuracy 
C)  Consistency 
D)  Both b and c 
A)  Completeness 
B)  Accuracy 
C)  Consistency 
D)  Both b and c

Question 6

The process of figuring out which items are similar is called __________.

Accepted Answer

A)  synonymy 
B)  data mapping 
C)  harmonization 
D)  enhancement 
A)  synonymy 
B)  data mapping 
C)  harmonization 
D)  enhancement

Question 7

Which of the following is NOT an example question aimed to assess the data accuracy?

Accepted Answer

A)  Are the patients who carry delivery codes always women? 
B)  Are all the columns and databases filled in? 
C)  Are men the only patients who undergo prostatectomies? 
D)  Are you treating patients who have birth dates before 1900? 
A)  Are the patients who carry delivery codes always women? 
B)  Are all the columns and databases filled in? 
C)  Are men the only patients who undergo prostatectomies? 
D)  Are you treating patients who have birth dates before 1900?

Question 8

If a medical coder adds information by checking against a validated database, then this is called data ______.

Accepted Answer

A)  scrubbing 
B)  enhancement 
C)  constraints 
D)  harmonization 
A)  scrubbing 
B)  enhancement 
C)  constraints 
D)  harmonization

Question 9

A __________ is a "list of details that describe each field in a database."

Accepted Answer

A)  Data dictionary 
B)  Patient index 
C)  Key index 
D)  Membership constraint 
A)  Data dictionary 
B)  Patient index 
C)  Key index 
D)  Membership constraint

Question 10

Which of the following questions is used to address the issue of consistency?

Accepted Answer

A)  Are men undergoing hysterectomies? 
B)  Are all the columns and databases filled in? 
C)  Are the data the same across different databases? 
D)  Are you treating patients who have birth dates before 1900? 
A)  Are men undergoing hysterectomies? 
B)  Are all the columns and databases filled in? 
C)  Are the data the same across different databases? 
D)  Are you treating patients who have birth dates before 1900?

A constraint that has a data field (column) of unique values that is shared with other databases is referred to as what?

Which of the following is an example of a foreign-key constraint?

The data set that the information is mapped from is called the __________.

A constraint that has limits as to a possible range is called what?

What measures the quality characteristic of whether data is correct, valid, and free from errors?

The process of figuring out which items are similar is called __________.

Which of the following is NOT an example question aimed to assess the data accuracy?

If a medical coder adds information by checking against a validated database, then this is called data ______.

A __________ is a "list of details that describe each field in a database."

Which of the following questions is used to address the issue of consistency?

Introduction to Statistical Terms and Concepts in Health Data Management

Basic Math Concepts, Central Tendency, and Dispersion

Data Presentation

Administrative Data

Clinical Facility Data

Public Health Data

Departmental Data

Financial Data

Predicting Data

Filters

Exam 9: Scrubbing and Mapping Data

A constraint that has a data field (column) of unique values that is shared with other databases is referred to as what?

Which of the following is an example of a foreign-key constraint?

The data set that the information is mapped from is called the __________.

A constraint that has limits as to a possible range is called what?

What measures the quality characteristic of whether data is correct, valid, and free from errors?

The process of figuring out which items are similar is called __________.

Which of the following is NOT an example question aimed to assess the data accuracy?

If a medical coder adds information by checking against a validated database, then this is called data ______.

A __________ is a "list of details that describe each field in a database."

Which of the following questions is used to address the issue of consistency?

Introduction to Statistical Terms and Concepts in Health Data Management

Basic Math Concepts, Central Tendency, and Dispersion

Data Presentation

Administrative Data

Clinical Facility Data

Public Health Data

Departmental Data

Financial Data

Predicting Data

Filters