Database Concepts Review Quiz

What is a database schema?

• A) A type of database software

• B) A definition of how data is organized in tables within a database

• C) A programming language for databases

• D) A security protocol for databases

What is a primary key?

• A) A field that contains duplicate identifiers

• B) A combination of columns that corresponds to a foreign key

• C) A field that contains unique identifiers for each record within the table

• D) A type of database schema

What is a foreign key?

• A) A field that contains unique identifiers for each record within the table

• B) A combination of columns in a table that corresponds to the primary key in another table

• C) A type of database schema

• D) A programming language for databases

What type of database relationship is described as a relationship where a record in one table can be related to multiple records in the second table, but a record in the second table can only be related to one record in the first table?

• One to Many

• One to One

• Many to Many

• None of the above

Which database relationship type involves a record in one table being related to a single record in the second table and vice versa?

• One to Many

• One to One

• Many to Many

• None of the above

In which type of database relationship can multiple records in one table be related to multiple records in another table?

• One to Many

• One to One

• Many to Many

• None of the above

Using the tables provided, which of the following is an example of a One to Many relationship?

• Gross Income (One) to Gross Income Country (Many)

• Movie Actor (Many) to Movie (Many)

• Loan (One) to Movie (One)

• None of the above

What is a Flat File Database?

• A database that stores information in rows and columns without relationships.

• A database that uses multiple tables with relationships.

• A database that is only used for large-scale data storage.

• A database that requires a specific skillset to use.

What is an example of a Flat File Database?

• CSV file

• SQL database

• NoSQL database

• XML file

Which of the following is a challenge of Flat File Databases?

• Difficult to make changes to the record structure.

• Data is stored in interrelated tables.

• Increased security and data accuracy.

• Ideal for large data storage.