ReviewQuiz ITE 206L

What is a Database Management System?

• Software used for managing data in databases

• Hardware used for storing data

• Protocol for transferring data between servers

• Language used for querying databases

What is the primary function of a database?

• Store and retrieve data

• Play music

• Send emails

• Run video games

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

• Uniquely identify each record

• Sort data alphabetically

• Encrypt sensitive information

• Display data in a table format

Which SQL command is used to retrieve data from a database?

• INSERT INTO

• WHERE

• UPDATE

• SELECT

What does the SQL command "INSERT INTO" do?

• Deletes data from a table

• Updates existing data in a table

• Adds new data to a table

• Retrieves data from a table

What is a foreign key in SQL?

• A key used for encryption

• A key that uniquely identifies each record in a table

• A key that references the primary key of another table

• A key used for sorting records in a table

Which SQL command is used to remove a table from the database?

• DELETE TABLE

• DROP TABLE

• REMOVE TABLE

• TRUNCATE TABLE

What is normalization in the context of databases?

• A process to optimize database performance

• A process to organize data into tables efficiently

• A process to remove duplicate data from a database

• A process to ensure data integrity and minimize redundancy

What is the first step in normalizing a database table?

• Removing redundant data

• Identifying all the entities

• Ensuring data integrity

• Organizing data into tables

What does the SQL keyword "GROUP BY" do?

• Sorts the result set in ascending order

• Groups rows that have the same values into summary rows

• Filters rows based on a specified condition

• Joins two or more tables based on a related column