Database Concepts Quiz

What is the key difference between data and information?

• Data is processed information

• Information is raw data

• Data has meaning, while information does not

• Data and information are the same

Which of the following best describes a flat file system?

• 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?

• Data redundancy

• Lack of concurrency

• High security

• Difficult data retrieval

What does a DBMS help with?

• Data redundancy

• Data security

• Efficient data management

• All of the above

Which is NOT a type of DBMS?

• Hierarchical

• Network

• Distributed

• Sequential

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

• Conceptual level

• Internal level

• External level

• Application level

Which data model uses a tree-like structure?

• Network model

• Hierarchical model

• Relational model

• Object-oriented model

Schemas define the ______ of a database.

• Structure

• Transactions

• Queries

• Reports

Which statement about schema evolution is true?

• 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