CCDM Database Management 3 — Questions and Answers
Question 1: What is the function of a user acceptance testing (UAT) plan in clinical database setup?
- To train end users on how to enter data
- To verify that the database meets user requirements before go-live (Correct answer)
- To document adverse events reported during the trial
- To establish data archiving procedures
Correct answer: To verify that the database meets user requirements before go-live
UAT verifies that the clinical database functions according to the specified user requirements and is fit for purpose before it is deployed for live data collection.
Question 2: In clinical data management, what does 'soft coding' of adverse events mean?
- Assigning temporary codes that must be confirmed by a medical coder (Correct answer)
- Using a standardized coding dictionary like MedDRA to assign terms
- Allowing sites to enter free-text descriptions without coding
- Applying automated codes that bypass medical review
Correct answer: Assigning temporary codes that must be confirmed by a medical coder
Soft coding assigns preliminary or tentative codes to adverse events that are subject to review and confirmation by a qualified medical coder before being finalized.
Question 3: Which action must be taken before unblinding the database in a double-blind clinical trial?
- Completing all database reconciliation and locking the database (Correct answer)
- Completing enrollment of all planned subjects
- Submitting all CRFs to the sponsor
- Obtaining IRB approval for data analysis
Correct answer: Completing all database reconciliation and locking the database
The database must be fully cleaned, reconciled, and locked before unblinding to prevent bias in data cleaning that could occur if treatment assignments were known.
Question 4: What is the role of a Data Safety Monitoring Board (DSMB) in relation to the clinical trial database?
- To manage day-to-day data entry operations
- To conduct periodic reviews of accumulating data to monitor participant safety (Correct answer)
- To perform final database lock and archiving
- To write the database validation specifications
Correct answer: To conduct periodic reviews of accumulating data to monitor participant safety
A DSMB periodically reviews accumulating unblinded data to monitor participant safety and trial integrity, potentially recommending early termination if needed.
Question 5: What does 'database migration' refer to in a clinical trial context?
- Moving the database from one physical server to another within the same facility
- Transferring clinical data from one system to another, often with format changes (Correct answer)
- Backing up the database to an offsite location
- Deleting obsolete records from the production database
Correct answer: Transferring clinical data from one system to another, often with format changes
Database migration involves transferring clinical data from one system or format to another, requiring validation to ensure data integrity is maintained throughout the process.
Question 6: Which programming language is most commonly used for querying relational clinical trial databases?
- Python
- Java
- SQL (Correct answer)
- R
Correct answer: SQL
SQL (Structured Query Language) is the standard language used to query, retrieve, and manipulate data in relational databases used in clinical trials.
Question 7: What is the purpose of an edit check specification document in clinical database management?
- To describe how data will be archived after trial completion
- To document all programmatic validation rules applied to the database (Correct answer)
- To outline the statistical analysis plan for efficacy endpoints
- To define access control roles for database users
Correct answer: To document all programmatic validation rules applied to the database
An edit check specification document describes all the validation rules and logical checks that will be programmed into the database to detect data errors or inconsistencies.
CCDM Database Management 3
What is the function of a user acceptance testing (UAT) plan in clinical database setup?