What is a flat file database?

What is a flat file database?

  • a database that stores records in a single file with no hierarchical structure
  • a database that requires SQL to store, manipulate, and retrieve data
  • a database that is used to store large amounts of complex data
  • a database that stores data in a sheet using a hierarchical tabular format of columns and rows

Explanation: A flat file database stores records in a single file with no hierarchical structure. A relational database requires a SQL to store, manipulate, and retrieve data and is used to store large amounts of complex data. A spreadsheet application stores data in a sheet using a tabular format of columns and rows.

Related exam: Module 6.3.2 Quiz - Introduction to Relational Databases and SQL