Understanding Flat Files vs. Relational Databases

What is the primary characteristic of a flat file database?

• A) It consists of multiple related tables.

• B) It utilizes complex data relationships.

• C) It stores data in a single table.

• D) It offers advanced querying capabilities.

Which of the following is a disadvantage of flat files compared to relational databases?

• A) Quick processing speed

• B) Controlled access to data

• C) Redundancy and inconsistency

• D) Flexibility for scalability

Relational databases offer controlled access with permissions applied at which level?

• A) Field

• B) Record

• C) Table

• D) Database

What is one advantage of flat files over relational databases?

• A) Efficient data management

• B) Advanced querying capabilities

• C) Simple setup process

• D) Ability to handle complex data relationships

In a relational database, what is used to reduce redundancy?

• A) Separate tables

• B) Redundant data

• C) Single table structure

• D) Flat file format

Which database type is more suitable for scenarios where processing speed is critical?

• A) Relational databases

• B) Flat files

• C) Both have similar processing speeds

• D) None of the above

What is a potential disadvantage of relational databases in terms of processing speed?

• A) Slower processing with large datasets

• B) Quick processing with complex queries

• C) Similar processing speed to flat files

• D) None, relational databases are always faster

Which database type offers advanced querying capabilities?

• A) Flat files

• B) Relational databases

• C) Both have similar querying capabilities

• D) None of the above

What factor contributes to the flexibility of relational databases?

• A) Simple setup process

• B) Ability to handle redundancy

• C) Controlled access with table-level permissions

• D) Ease of adding new columns