nerdexam
CompTIA

FC0-U61 · Question #891

Which of the following is a characteristic of both a database and a flat file?

The correct answer is B. Persistence. Both databases and flat files share the characteristic of persistence, meaning the data stored in them remains available even after the application that created it closes.

Database Fundamentals

Question

Which of the following is a characteristic of both a database and a flat file?

Options

  • AConcurrent users
  • BPersistence
  • CQueries
  • DData definition

How the community answered

(54 responses)
  • A
    2% (1)
  • B
    91% (49)
  • C
    6% (3)
  • D
    2% (1)

Why each option

Both databases and flat files share the characteristic of persistence, meaning the data stored in them remains available even after the application that created it closes.

AConcurrent users

Concurrent users are typically supported by database management systems with concurrency control mechanisms, which flat files generally lack.

BPersistenceCorrect

Persistence refers to the ability of data to outlive the process that created it; both flat files and databases store data on non-volatile storage, making it persistent.

CQueries

While simple queries can be performed on flat files (e.g., searching text), complex querying capabilities with indexing and relational joins are characteristics of databases, not flat files.

DData definition

Data definition (schema) is a structured characteristic of databases, often enforced through a DBMS, whereas flat files have a less formal or unenforced structure.

Concept tested: Characteristics of data storage, persistence

Source: https://www.techtarget.com/searchdatamanagement/definition/data-persistence

Topics

#data storage#persistence#flat files#databases

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice