BLIS QUIZ 1

What is the purpose of a Database Management System (DBMS)?

• To develop mobile applications

• To design websites

• To create and manage databases

• To analyze data

What is the difference between data and information?

• Data and information are the same

• Data is raw facts, while information is processed data

• Data and information are not related

• Data is processed facts, while information is raw data

What is the primary key in a database table used for?

• To display data in a table

• To store multiple values

• To create relationships between tables

• To uniquely identify each record

What is the purpose of database normalization?

• To increase data redundancy

• To complicate data storage

• To organize data into multiple related tables and minimize data redundancy

• To slow down data retrieval

What is the first step in the normalization process?

• Ensuring the table is in First Normal Form (1NF)

• Ensuring the table is in Second Normal Form (2NF)

• Ensuring the table is in Third Normal Form (3NF)

• Ensuring the table is in Fourth Normal Form (4NF)

What is the criteria for a table to be in First Normal Form (1NF)?

• Each column must be single value and not contain multiple values

• Each column must contain multiple values

• The order of data saved in the table matters

• Each column must have a unique name

What is the purpose of a primary key in a database table?

• To create relationships between tables

• To display data in a table

• To store multiple values

• To uniquely identify each record

What is the difference between a one-to-many relationship and a many-to-many relationship?

• One-to-many: a record in table A can have more than one matching record in table B. Many-to-many: two or more one-to-many relationships

• One-to-many: a record in table A can have more than one matching record in table B. Many-to-many: a record in table B can have more than one matching record in table A

• One-to-many: a record in table A can have only one matching record in table B. Many-to-many: a record in table A can have more than one matching record in table B

• One-to-many: a record in table A can have only one matching record in table B. Many-to-many: two or more tables are not related

What is the purpose of a foreign key in a database table?

• To create relationships between tables

• To display data in a table

• To store multiple values

• To reference the primary key of another table

What is the main goal of database normalization?

• To complicate data storage

• To increase data redundancy

• To slow down data retrieval

• To reduce data redundancy and improve data integrity