Databases

What is a flat file database?

• A database with multiple tables

• A database with a single table

• A database with no tables

• A database with hierarchical tables

What does a table in a database hold?

• A collection of records for a particular theme

• A single record for multiple themes

• A collection of themes for a single record

• A single theme for multiple records

What is the naming convention for a table in a database?

• It begins with a lowercase tbl followed by the name of the table.

• It begins with an uppercase TBL followed by the name of the table.

• It begins with a lowercase table followed by the name of the table.

• It begins with an uppercase TABLE followed by the name of the table.

What genre is the track "Us" categorized under?

• Pop

• Rock

• RnB

• Jazz

What does a table in a database contain?

• A collection of records

• A single record

• A collection of tables

• A single data point

What does each record in a database table represent?

• A collection of tables

• Data for one object, person, or place

• A collection of records

• A single data point

In the given example, what does each record represent?

• A single song track

• A collection of albums

• A single artist

• A music genre

What is a field in a database table?

• A row in the table

• A category for each piece of data

• A type of database

• A database software

How many fields does the table in the image have?

• Two

• Three

• Four

• Five

Which of the following is NOT a field in the table shown?

• TrackID

• Title

• Artist

• Album