Database Concepts Flashcard

Front

What is the key difference between data and information?

Back

Data is processed information.

Front

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

Back

Simple text-based storage without relations

Front

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

Back

High security

Front

What does a DBMS help with?

Back

Data redundancy, Data security, Efficient data management

Front

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

Back

Sequential

Front

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

Back

Internal level

Front

Which data model uses a tree-like structure?

Back

Hierarchical model

Front

Schemas define the ______ of a database.

Back

Structure

Front

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

Back

Schema changes affect data structure

Front

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

Back

Data independence