Database Basics

What is a database?

• A collection of files on a computer

• A collection of related data organized in a structured way

• A software application used to create spreadsheets

• A type of computer hardware

Which of the following is a primary key in a database table?

• A field that must contain unique values for each record

• A field that can contain duplicate values

• A field that is optional for each record

• A field that contains only numeric values

Which of the following is a valid data type in most database systems?

• String

• Boolean

• Float

• All of them

In a relational database, what is a foreign key?

• A key that is used for encryption

• A key that uniquely identifies each record in a table

• A key that establishes a link between two tables by referencing the primary key of another table

• A key that is only used for indexing purposes

Which of the following is not a commonly used data type in a database?

• Integer

• Float

• String

• Loop

Which data type is typically used to store whole numbers in a database?

• Decimal

• Date

• Char

• Integer

Which data type is suitable for storing currency values with decimal precision?

• Char

• Decimal

• Date

• Boolean

In a database, what data type is used to store true or false values?

• Date

• Boolean

• Integer

• Varchar

In a database for a social media platform, which of the following could be a primary key for the "User Accounts" table?

• User Profile Picture

• User Email Address

• User ID

• User Bio

In a database for a university, which of the following could be a primary key for the "Courses" table?

• Course Name

• Course Code

• Course Instructor

• Course Schedule