Database Basics Quiz

What is a table in a database?

• A table in a database is a type of furniture used for dining

• A table in a database is a group of people sitting together for a discussion

• A table in a database is a chart showing data in a visual format

• A table in a database is a collection of related data organized in rows and columns.

What is a record in a database?

• A record in a database is a collection of fields or attributes that are related to a single entity or item.

• A record in a database is a physical object used to play music

• A record in a database is a written account of an event

• A record in a database is a type of music album

What are data types in a database?

• Data types in a database refer to the specific categories of data, such as text, numbers, dates, and binary data, that can be stored and manipulated within the database.

• Data types in a database refer to the specific shapes of data, such as circles, squares, and triangles, that can be stored and manipulated within the database.

• Data types in a database refer to the specific flavors of data, such as chocolate, vanilla, and strawberry, that can be stored and manipulated within the database.

• Data types in a database refer to the specific colors of data, such as red, blue, and green, that can be stored and manipulated within the database.

What is a primary key in a database?

• A primary key in a database is used for sorting records in a table.

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

• A primary key in a database is a field that can have duplicate values within a table.

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

Which of the following is an example of a data type in a database?

• Float

• Boolean

• Array

• VARCHAR

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

• The purpose of a primary key in a database is to uniquely identify each record in a table.

• To store backup data in the database

• To organize data alphabetically in the database

• To limit the number of records in the database

What is the main function of a table in a database?

• The main function of a table in a database is to store and organize data in a structured format.

• To send emails

• To display advertisements

• To play music

Which of the following is an example of a record in a database?

• A recipe for chocolate chip cookies.

• A map of the city's public transportation system.

• A list of upcoming concerts at a local venue.

• A customer's purchase history in an online store.

What is the role of data types in a database?

• Data types in a database are used for entertainment purposes only

• The role of data types in a database is to define the type of data that can be stored in a particular column or field, ensuring data integrity and efficient storage and retrieval of data.

• Data types in a database have no role

• Data types in a database only determine the color of the text

Why is it important to have a primary key in a database?

• It is not important to have a primary key in a database

• A primary key is only necessary for small databases

• Having a primary key in a database causes data duplication

• It is important to have a primary key in a database because it uniquely identifies each record in the table, ensuring data integrity and providing a reference for relationships between different tables.