Database Concepts Flashcard

What is the key difference between data and information?

Which of the following best describes a flat file system? Options: Hierarchical data storage, Simple text-based storage without relations, Stores data in a relational manner, Uses tables with foreign keys

Which is NOT a disadvantage of a flat file system? Options: Data redundancy, Lack of concurrency, High security, Difficult data retrieval

What does a DBMS help with?

Which is NOT a type of DBMS? Hierarchical, Network, Distributed, Sequential

Which level of DBMS architecture defines how data is stored physically?

Which data model uses a tree-like structure?

Schemas define the ______ of a database.

Which statement about schema evolution is true? Options: Schema cannot be changed after creation, Schema changes affect data structure, Data remains unchanged during schema evolution, Schema evolution is not supported in DBMS

Three-schema architecture improves: Redundancy, Data independence, Data inconsistency, Query speed