CCDM Database Management 2 — Questions and Answers
Question 1: Which database validation check ensures that a date entered falls within the allowable study window for a visit?
- Range check (Correct answer)
- Format check
- Consistency check
- Derivation check
Correct answer: Range check
A range check validates that a value, such as a visit date, falls within a predefined acceptable range.
Question 2: What is the purpose of a data lock in clinical trial database management?
- To encrypt sensitive patient data
- To prevent further changes to the database after clean data is confirmed (Correct answer)
- To restrict access to authorized users only
- To back up the database to a secure server
Correct answer: To prevent further changes to the database after clean data is confirmed
A database lock prevents modifications to data after the data cleaning process is complete and data quality is confirmed, preserving data integrity for analysis.
Question 3: In a relational database used for clinical trials, what does a foreign key enforce?
- Uniqueness of records within a table
- Referential integrity between two tables (Correct answer)
- Encryption of sensitive fields
- Audit trail logging of all changes
Correct answer: Referential integrity between two tables
A foreign key enforces referential integrity by ensuring that a value in one table corresponds to a valid entry in another related table.
Question 4: Which type of database design is most commonly used in clinical data management systems for structured trial data?
- Hierarchical database
- Relational database (Correct answer)
- Object-oriented database
- Graph database
Correct answer: Relational database
Relational databases are most commonly used in clinical data management because they organize data into tables with defined relationships, supporting complex queries and data integrity.
Question 5: What is a data dictionary in the context of clinical trial database management?
- A glossary of medical terms used in the protocol
- A document describing the structure, content, and format of the database (Correct answer)
- A list of approved coding terms for adverse events
- A file containing encrypted patient identifiers
Correct answer: A document describing the structure, content, and format of the database
A data dictionary documents the structure, content, format, and validation rules for each field in the clinical trial database.
Question 6: When performing database reconciliation between two sources (e.g., EDC and safety database), what is the primary goal?
- To identify and resolve discrepancies between the two datasets (Correct answer)
- To migrate data from one system to another
- To archive older versions of the database
- To generate audit trail reports
Correct answer: To identify and resolve discrepancies between the two datasets
Database reconciliation aims to identify and resolve any discrepancies between two data sources to ensure consistency and accuracy.
Question 7: Which 21 CFR Part 11 requirement directly applies to clinical trial databases in the US?
- Mandating paper-based backup for all electronic records
- Ensuring electronic records and electronic signatures are trustworthy and equivalent to paper (Correct answer)
- Requiring all data to be entered within 24 hours of collection
- Prohibiting the use of third-party EDC vendors
Correct answer: Ensuring electronic records and electronic signatures are trustworthy and equivalent to paper
21 CFR Part 11 establishes criteria under which electronic records and electronic signatures are considered trustworthy and legally equivalent to paper records.
CCDM Database Management 2
Which database validation check ensures that a date entered falls within the allowable study window for a visit?