Database Fundamentals - Lec1 Quiz

What is a Database?

• A collection of structured data.

• A collection of random data.

• A collection of related data.

• A collection of unrelated data.

What is a Database Management System (DBMS)?

• A software package/system to handle a database.

• A hardware device used to store data.

• A type of data model.

• A programming language for databases.

What does a Primary Key ensure in a database?

• Values in a column must be unique.

• Values in a column can be duplicated.

• Values in a column cannot be NULL.

• Values in a column can be NULL.

What is SQL used for?

• Designing websites.

• Interacting with DBMS for various operations like Create, Read, Update, and Delete.

• Only for creating databases.

• Only for reading data.

What is a Data Type in a database?

• A type of computer hardware.

• A type of data that can be stored in a database column.

• A type of software application.

• A type of database table.

What does a Foreign Key do in a database?

• Stores date-time data.

• Ensures values in a column cannot be NULL.

• Provides a link between data in two tables.

• Ensures values in a column are unique.

What is a Schema in a database?

• A type of database constraint.

• A type of database query language.

• A group of related objects in a database.

• A group of unrelated objects.

What does a CHECK constraint do in a database?

• Ensures data must match a condition expression.

• Ensures values in a column are unique.

• Ensures data is stored in a specific format.

• Ensures values in a column cannot be NULL.

What is an Entity in Entity-Relationship Modeling?

• A database table.

• A database query.

• A database column

• A database constraint.

What type of relationship exists when a single record in table A is related to one or more records in table B, but a single record in table B can be related to only one record in table A?

• One-to-One

• One-to-Many

• Many-to-Many

• Many-to-One