Certified Supply Chain Professional (CSCP) Practice Exam

What defines hierarchical databases?

1. Information stored in multiple unrelated tables

2. Higher level folders (parents) and subfolders (children)

3. Simple flat file structures

4. Entirely relational linking

The correct answer is: Higher level folders (parents) and subfolders (children)

Hierarchical databases are characterized by their tree-like structure where data is organized into records that have a parent-child relationship. This means that information is stored in higher level folders, which serve as parents, and subfolders that act as children. This setup allows for the organization of data in a way that reflects natural relationships, akin to a family tree, where each child can have multiple siblings but only one parent node. In this structure, each parent can have multiple children, but the relationships are strictly defined, enabling efficient access to data through traversal of the hierarchy. This method is particularly useful for scenarios with a clear and consistent hierarchy, such as organizational charts or file systems. The other options do not accurately describe hierarchical databases. Unrelated tables are a feature of relational databases, simple flat file structures lack the complexities of a hierarchical approach, and entirely relational linking describes the nature of relational databases rather than hierarchical ones. Understanding the characteristics of hierarchical databases is vital for grasping their advantages in specific applications involving well-defined relationships among data.