Microsoft SQL Essentials Lec1

What is a Database?

• A collection of random data

• A collection of related data

• A collection of images

• A collection of unrelated data

What is a Database Management System (DBMS)?

• A software package to facilitate the creation of file-based systems

• A software package to facilitate the creation and maintenance of a computerized database

• A software package to manage emails

• A software package to create websites

What does a Primary Key ensure in a database?

• Values in a column can be NULL

• Values in a column cannot be NULL

• Values in a column can be duplicated

• Values in a column are not unique

What is SQL used for?

• Only for creating databases

• Only for reading data

• Interacting with DBMS, managing Databases

• Only for deleting data

What does a Foreign Key do in a database?

• Ensures values in a column are unique

• Provides a link between data in two tables

• Allows NULL values in a column

• Deletes data from a table

What is a Data Type in SQL?

• A way to store only numeric values

• A way to store only date and time values

• A way to determine the type of data that can be stored in a database column

• A way to store only text values

What is a Schema in a database?

• A group of related objects in a database

• A group of random objects

• A group of images

• A group of unrelated objects

What does a CHECK constraint do in a database?

• Allows NULL values in a column

• Deletes all data in a table

• Ensures data must satisfy an expression

• Allows any type of data in a column

What is the purpose of Entity-Relationship Diagram (ERD)?

• To create websites

• To manage emails

• To store images in a database

• To identify information required by the business

What is the purpose of a One-to-many relationship in a database?

• A single record in table A can be related to only one record in table B

• A single record in table A can be related to one or more records in table B, and vice versa

• A single record in table A can be related to one or more records in table B