Midterm Examination on Database Fundamentals

Which type of database system is often used in mainframe applications?

• Hierarchical databases

• Network databases

• Relational databases

• Object-oriented databases

What type of database stores data in a structured table format with rows and columns?

• Document database

• Relational database

• Graph database

• NoSQL database

Which type of database system is best suited for storing unstructured data?

• Relational database

• Hierarchical database

• NoSQL database

• Network database

What is an advantage of relational databases?

• Simple structure for complex relationships

• Efficient data retrieval for structured data

• High performance for real-time analytics

• Does not require predefined schemas

What does a hierarchical database use to organize data?

• Tables and relationships

• Nodes and edges

• Parent-child tree structure

• Documents and collections

A graph database is best suited for which type of data?

• Social networks and relationships

• Financial transactions

• Inventory management

• Customer orders

Which database model provides the best flexibility for handling complex relationships?

• Relational database

• Graph database

• Hierarchical database

• Document database

How does a document database store information?

• In tables with rows and columns

• As key-value pairs

• As structured documents in JSON or XML

• As interconnected nodes and edges

What is a key characteristic of NoSQL databases?

• Schema-less design

• Strict data consistency

• Requires normalization

• Uses only SQL for queries

Why might an organization choose a network database?

• To manage hierarchical relationships

• To model complex, many-to-many relationships

• To simplify table-based queries

• To improve transaction speed