Grade 12 DatabaseDesignConcepts

What is a common misconception about databases?

• Databases always require a computer
• Databases are less organized than spreadsheets
• Normalization is unnecessary for databases
• A primary key can be duplicated

What does RDBMS stand for in database terminology?

• Relational Database Management System
• Random Data Backup System
• Remote Database Management System
• Reliable Data Management Software

What is a primary key in a database table?

• A field that is optional for each record.
• A field that stores large amounts of data.
• A field that must be unique for every record.
• A field that can be duplicated across records.

How does normalization benefit a database?

• It allows for easier data encryption.
• It simplifies user access control.
• It helps to make databases work properly.
• It increases data redundancy.

If a database is not normalized, what issue might arise?

• Data integrity will improve
• Data retrieval will be faster
• Data anomalies may occur
• Data will be more secure

Why is data integrity important in a database?

• It allows for faster data retrieval.
• It makes data more accessible to users.
• It ensures data is always correct.
• It reduces the size of the database.

What can data redundancy lead to in a database?

• Increased efficiency
• Anomalies
• Improved data integrity
• Better data security

Which of the following statements about data independence is true?

• It allows applications to remain unaffected by changes in the database.
• It requires constant updates to applications.
• It is not necessary for database management.
• It makes data retrieval slower.

What is the role of access control in database security?

• To increase data redundancy
• To prevent unauthorized access
• To simplify data retrieval
• To ensure data is always correct

What is the purpose of data encryption in databases?

• To simplify data retrieval
• To ensure data is always correct
• To prevent unauthorized access
• To increase data redundancy