Database Concepts Quiz: Hierarchical & File Access

Which database model originated in the 1960s and relies on a tree structure for organizing data?

• A) Relational databases

• B) Hierarchical databases

• C) NoSQL databases

• D) Graph databases

In a hierarchical database, what does each parent branch represent?

• A) "Many" side of a relationship

• B) "One" side of a relationship

• C) Both "one" and "many" sides of a relationship

• D) Neither "one" nor "many" sides of a relationship

What is a primary limitation of hierarchical databases?

• A) Lack of support for one-to-many relationships

• B) Inability to enforce a strict hierarchy

• C) Difficulty in representing complex relationships beyond one-to-many

• D) Unsuitability for working with ordered data

Which database management system played a significant role in early database management, including banking and inventory management?

• A) Hierarchical databases

• B) Relational databases

• C) NoSQL databases

• D) Graph databases

What led to the decline of hierarchical databases?

• A) Introduction of NoSQL databases

• B) Emergence of more versatile database models like Relational databases

• C) Lack of support for file systems

• D) Inability to handle one-to-many relationships

Which file access method involves reading data serially from start to finish?

• A) Sequential access

• B) Direct file access

• C) Indexed Sequential Access

• D) Random access

In direct file access, what is used to determine the storage address for records?

• A) Sorting algorithms

• B) Index files

• C) Hashing algorithms

• D) Sequential scanning

Which database access method combines sequential and direct access methods?

• A) Sequential access

• B) Indexed Sequential Access

• C) Direct file access

• D) Random access