87. Database - Relational Database Concepts Quiz

What is a field in a database table?

• A set of related fields

• A single type of data

• A field used to uniquely identify any record

• A complete set of related records

What is a record in a database table?

• A single type of data

• A set of related fields

• A complete set of related records

• A field used to uniquely identify any record

What is a table in a database?

• A single type of data

• A set of related fields

• A field used to uniquely identify any record

• A complete set of related records

What is a primary key in a database table?

• A single type of data

• A set of related fields

• A complete set of related records

• A field used to uniquely identify any record

What is a foreign key in a database table?

• A field used to uniquely identify any record

• A complete set of related records

• A set of related fields

• A single type of data

What is the primary key for the world table?

• Name

• Area

• Population

• Continent

What is the primary key for the continents table?

• Population

• Continent

• Name

• Area

What is the relationship where one entry in one table has a single entry in the other table and vice versa?

• One-to-one

• One-to-many

• Many-to-many

• None of the above

What is the relationship where a single row in one table relates to many entries in the other?

• One-to-many

• None of the above

• One-to-one

• Many-to-many

What process is used to break a many-to-many relationship apart in a relational database?

• Aggregation

• Optimization

• Validation

• Normalization