CCDM Database Management 2

Question 1

Which database validation check ensures that a date entered falls within the allowable study window for a visit?

Accepted Answer

Range check

Answer

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?

Accepted Answer

To prevent further changes to the database after clean data is confirmed

Answer

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?

Accepted Answer

Referential integrity between two tables

Answer

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?

Accepted Answer

Relational database

Answer

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?

Accepted Answer

A document describing the structure, content, and format of the database

Answer

A data dictionary documents the structure, content, format, and validation rules for each field in the clinical trial database.

(CCDM) Certified Clinical Data Manager Practice Test

(CCDM) Certified Clinical Data Manager Practice Test

CCDM Database Management 2