SQL and Database Quiz

What is a Database?

• An organized collection of structured information stored electronically

• A programming language for data analysis

• A type of software for managing files

• A collection of unstructured information

What does DBMS stand for?

• Data Base Management Service

• Database Model System

• Data Base Management Software

• Database Management System

What is a Relational Database?

• A database that only stores images

• A type of database that stores data in tables with rows and columns

• A database that uses NoSQL technology

• A database that stores data in files

What is the purpose of a Query?

• To delete data from a database

• To request information from a database

• To create a new database

• To update existing records

What does the SELECT statement do?

• It creates a new table

• It retrieves data from a database

• It updates data in a database

• It deletes data from a database

What is the function of the WHERE clause?

• To group records by a specific field

• To join two tables together

• To filter records based on specific conditions

• To sort results in ascending order

What does the COUNT function do?

• Calculates the average value of a column

• Finds the smallest value in a column

• Returns the total sum of a numeric column

• Returns the number of rows in a dataset

What is a Primary Key?

• A method for sorting data

• A key that links two tables together

• A unique identifier for each record in a table

• A type of database function

What are ACID properties?

• A programming language for databases

• A method for data retrieval

• A set of properties that ensure reliable database transactions

• A type of database model

What is Normalization?

• The process of deleting unnecessary data

• The process of creating new databases

• The process of organizing data to reduce redundancy

• The process of combining tables