Database Concepts Quiz

What is an entity in a database?

• An entity in a database is a table that stores data.

• An entity in a database is a software program used to manage data.

• An entity in a database is a file that contains information.

• An entity in a database is a distinct object or concept that is represented in the database.

What is an attribute in a database?

• A characteristic or property of an entity in a database.

• A table in a database

• A query in a database

• A relationship between two entities in a database

What is a primary key in a database?

• A primary key in a database is a unique identifier for each record in a table.

• A primary key in a database is a field that can be duplicated in multiple records.

• A primary key in a database is a random number assigned to each record.

• A primary key in a database is a field that stores the most important data.

What is a relationship in a database?

• A relationship in a database is a connection or association between two or more tables based on common fields.

• A relationship in a database is a connection between a table and a document.

• A relationship in a database is a connection between a table and a spreadsheet.

• A relationship in a database is a connection between a table and a graph.

Which of the following is an example of an entity?

• idea

• animal

• object

• person

Which of the following is an example of a primary key?

• Phone number

• Email address

• Staff ID number

• Date of birth

Which of the following is an example of a relationship?

• Marriage

• Rainbow

• Cooking

• Friendship

What is the purpose of an entity in a database?

• To organize data in the database.

• To represent a real-world object or concept in the database.

• To store data in the database.

• To perform calculations in the database.

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

• To store additional information about each record.

• To sort the records in a table.

• To uniquely identify each record in a table.

• To establish relationships between tables.