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 model organizes data into a hierarchy of parent-child relationships, resembling a tree structure?
Answer: Hierarchical model
The hierarchical model organizes data in a tree structure where each child record has only one parent, historically used in early hospital information systems.
A coding manager wants to combine data from two queries where each returns patient lists, keeping only patients that appear in both results. Which SQL set operator should be used?
Answer: INTERSECT
INTERSECT returns only the rows that appear in both result sets, identifying patients common to both query conditions.
In a healthcare database, what is the purpose of a stored procedure?
Answer: To precompile and store a set of SQL statements for repeated execution
A stored procedure is a precompiled collection of SQL statements saved in the database and executed as a unit, improving performance and consistency.
Which database concept describes the ability of a system to recover from a hardware failure and continue functioning with minimal data loss?
Answer: Fault tolerance
Fault tolerance refers to a system's ability to continue operating correctly even when one or more components fail.
A hospital's HIM department uses a report that automatically refreshes its data whenever the underlying table is updated. What database object provides this functionality?
Answer: Trigger
A trigger is a database object that automatically executes a defined action (such as refreshing a report or enforcing a rule) in response to data changes.
What is data deduplication in the context of health information management?
Answer: Identifying and removing redundant copies of data
Data deduplication identifies and eliminates redundant data copies, reducing storage requirements and improving database accuracy.
Which term describes the process of converting a database schema from one format to another, such as moving from a legacy system to a modern EHR platform?
Answer: Data migration
Data migration is the process of transferring data between storage types, formats, or systems, often occurring during EHR implementations or system upgrades.