Database

What is a database?

• A collection of unstructured data

• A structured collection of data organized for efficient retrieval, manipulation, and management

• A single file containing all data

• A collection of images

What is a flat-file database?

• A database with advanced security features

• A database with no data redundancy

• A simple database model where all data is stored in a single table or file

• A database with multiple tables and relationships

What are the limitations of a flat-file database?

• Data redundancy and limited scalability

• Efficient data organization

• Reduced data redundancy

• Unlimited scalability

What is a relational database?

• A database with limited data integrity

• A database with no security features

• A database with no relationships between tables

• A database that organizes data into tables with rows and columns

How can a relational database overcome the limitations of a flat-file database?

• By increasing data redundancy

• By reducing data redundancy through normalization techniques

• By limiting data organization

• By providing limited security features

What is a data dictionary?

• A tool for data encryption

• A tool for writing SQL queries

• A centralized repository that stores metadata about the data in a database

• A database model with no relationships

What is data modeling?

• The process of storing data in a single file

• The process of data security

• The process of designing a database structure that accurately represents the organization's data requirements

• The process of data redundancy

What is a logical schema?

• A physical model of the database

• A high-level conceptual model that defines the organization of data in a database

• A model with no keys or relationships

• A model with limited data security

What is data security?

• Measures to increase data redundancy

• Measures to reduce data integrity

• Measures to limit data organization

• Measures implemented to protect data from unauthorized access

What is a query processor?

• A tool for data encryption

• A component of the DBMS responsible for executing SQL queries

• A tool for data modeling

• A tool for data redundancy