Database Management Flashcards
7 cards from real CCS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Database Management flashcards as text
Which type of database backup captures only the data that has changed since the last full backup?
Answer: Differential backup
A differential backup captures all changes made since the last full backup, offering a balance between storage space and restoration speed.
A health information technician runs a report showing all patients admitted with a primary diagnosis in a specific ICD-10 chapter. Which SQL command initiates this retrieval?
Answer: SELECT
The SELECT statement retrieves data from one or more database tables based on specified conditions.
What is the role of a data dictionary in a healthcare information system?
Answer: It defines the structure, format, and meaning of all data elements in the database
A data dictionary is a repository that describes all data elements, their definitions, formats, and relationships within the system.
Which database design technique splits a large table into smaller, more manageable pieces based on a defined rule, such as date ranges?
Answer: Partitioning
Partitioning divides a large table into segments, improving query performance and manageability for large healthcare datasets like encounter histories.
In the context of HIPAA compliance, which database control ensures that access to PHI is logged and traceable to a specific user?
Answer: Audit trail
An audit trail records who accessed or modified PHI, when, and what action was taken, satisfying HIPAA's accountability requirements.
A hospital is merging databases from two facilities after an acquisition. Which process ensures that records for the same patient are linked under one identity?
Answer: Record linkage
Record linkage identifies and connects records that represent the same real-world entity across different databases or systems.
What does referential integrity in a healthcare database prevent?
Answer: Orphan records that reference non-existent parent records
Referential integrity ensures that foreign key values always correspond to an existing primary key, preventing orphaned or invalid records.