Database Terminology Quiz

What is an entity in a database?

• A physical object

• A concept

• Both a physical object and a concept

• None of the above

What is an attribute in a database?

• A property

• A quality

• A characteristic

• All of the above

What does a record represent in a database?

• A category heading

• A collection of data for a set of fields

• A unique identifier

• None of the above

What is a primary key in a database?

• A field that uniquely identifies each record in a table

• A field that appears as the primary key in another table

• A field that contains a unique value for every record in a table

• All of the above

What is a composite key in a database?

• A field that uniquely identifies each record in a table

• A field that appears as the primary key in another table

• A field made up of more than one field

• None of the above

What is a foreign key in a database?

• A field that uniquely identifies each record in a table

• A field that appears as the primary key in another table

• A field used to join tables

• All of the above

What are the benefits of using databases?

• Reducing duplicated data

• Maintaining data integrity

• Eliminating insertion, update or deletion anomalies

• All of the above

Do databases save space?

• Yes

• No

• It depends on the implementation

• Not mentioned in the text

Why doesn't everyone use a database?

• Databases are time-consuming to set up

• Database design requires expertise in normalization

• Flat files can meet basic needs

• All of the above

What are database applications?

• Software programs that retrieve, manage, distribute and present information

• Software programs that regulate access to data using user accounts and access rights

• Software programs that bridge the gap between raw data and information required by end users

• All of the above