Grade 10 bilin- Databases

What is a database?

• A database is a physical storage device for computers.

• A database is a programming language for data manipulation.

• A database is an organized collection of data that can be easily accessed, managed, and updated.

• A database is a type of software used for web development.

Name one example of a database.

• PostgreSQL

• MySQL

• OracleDB

• SQLite

Why is it important to organize information in a database?

• To reduce the amount of data stored in the database.

• To ensure that all data is stored in a single file.

• It is important to organize information in a database to ensure efficient data retrieval, management, and integrity.

• To make the database look more visually appealing.

What does reducing data redundancy mean?

• It means increasing the amount of data stored in a database.

• It refers to the process of backing up data regularly.

• It involves creating multiple copies of the same data for security.

• It means minimizing the duplication of data in a database.

How does a database ensure data integrity?

• Data integrity is ensured by using random data generation.

• Data integrity is maintained by ignoring user input.

• Data integrity is guaranteed through regular data deletion.

• Data integrity is ensured by using constraints, transactions, and validation rules.

What is the purpose of tables in a database?

• To perform calculations on data.

• To organize and store data in a structured format.

• To manage user permissions in a database.

• To create visual representations of data.

What are fields in a database table?

• Fields are the primary keys that uniquely identify records in a table.

• Fields are the rows in a database table that contain the data.

• Fields are the columns in a database table that define the attributes of the data.

• Fields are the indexes that improve the speed of data retrieval in a database.

What do records represent in a database?

• Records are the columns in a database table.

• Records represent individual entries in a database table.

• Records are the primary keys in a database.

• Records represent the relationships between tables in a database.

Give an example of a field in a student records table.

• student_id

• course_code

• enrollment_date

• student_name

Why is data security important in databases?

• Data security is irrelevant for non-sensitive data.

• Data security is only necessary for large corporations.

• Data security can be ignored if backups are available.

• Data security is important to protect sensitive information and ensure data integrity, confidentiality, and availability.