Understanding Databases Fundamentals

Database normalization is the process of organizing data to reduce redundancy.

• Database normalization is only applicable to relational databases.

• Database normalization is the process of deleting data from a database.

• Database normalization increases data redundancy.

• Database normalization is the process of organizing data to reduce redundancy.

SQL stands for Structured Query Language.

• Structured Query Code

• Structured Query Protocol

• Structured Query System

• Structured Query Language

A primary key can contain duplicate values in a table.

• False

• A primary key can be null

• True

• A primary key can contain multiple values

Data integrity constraints ensure the accuracy and consistency of data in a database.

• Data integrity constraints ensure the accuracy and consistency of data in a database.

• Data integrity constraints are only relevant for large databases.

• Data integrity constraints allow for data duplication.

• Data integrity constraints are not necessary for data accuracy.

Relational databases use tables to store data in a structured format.

• Relational databases store data in files.

• Relational databases use graphs to store data.

• Relational databases do not use tables for data storage.

• Relational databases use tables to store data in a structured format.

NoSQL databases are designed to handle unstructured data.

• NoSQL databases are only for structured data.

• NoSQL databases require a fixed schema.

• NoSQL databases cannot handle large volumes of data.

• True

A foreign key is a field in one table that uniquely identifies a row of another table.

• A foreign key is a unique identifier for a table.

• A foreign key is a field in one table that uniquely identifies a row of another table.

• A foreign key is a field that can contain duplicate values.

• A foreign key is a field that links two tables without any constraints.

Database security practices are only necessary for large organizations.

• False

• Database security is optional for all organizations.

• Only small businesses need database security.

• Only tech companies require database security.

Normalization can lead to improved database performance.

• Normalization is only relevant for large databases.

• Normalization has no effect on database performance.

• Normalization decreases database performance.

• True

SQL queries can only be used to retrieve data, not to modify it.

• SQL is only for creating databases.

• SQL cannot be used to delete records.

• False

• SQL can only be used for data analysis.