Difficulty: Easy
Correct Answer: Flat file
Explanation:
Introduction / Context: Early information systems often used simple files that stored records with identical structures. Understanding this term helps contrast traditional file processing with relational databases, where tables are managed by a DBMS and accompanied by metadata, constraints, and query capabilities.
Given Data / Assumptions:
Concept / Approach: A flat file stores data in a plain, uniform structure—examples include CSV files or fixed-length record files. All records follow the same layout, which applications must know. In contrast, a database is a managed collection with schemas, indexes, and transactions; a table is a database object within a DBMS, not just a raw file on disk.
Step-by-Step Solution:
Identify the defining trait: identical record format for all entries.Map that trait to the standard term “flat file.”Exclude “database” and “table,” which imply DBMS context.Choose “Flat file.”Verification / Alternative check: Texts on file organization categorize sequential, indexed-sequential, and direct access files—flat files typically underpin these structures when each record shares the same layout.
Why Other Options Are Wrong: Database: broader system, not a single uniform file.
Table: DBMS construct, although similar visually, carries DBMS semantics. Data structure: overly generic; could be any organization of data in memory or storage.Common Pitfalls: Equating a CSV table with a database table; a flat file lacks constraints, indexes, and transactional guarantees.
Final Answer: Flat file
Discussion & Comments