Database & SQL Quiz

What is a database?

• A physical storage device

• An organized collection of data stored in a structured manner

• A programming language

• A web development framework

Which of the following is a relational database?

• MongoDB

• Redis

• MySQL

• Cassandra

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

• To store duplicate records

• To uniquely identify each record in a table

• To link multiple databases together

• To delete tables

What does SQL stand for?

• Structured Query Logic

• Systematic Query Language

• Structured Query Language

• Sequential Query Language

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

• INSERT

• UPDATE

• DELETE

• SELECT

What is the purpose of the WHERE clause in SQL?

• To filter records based on conditions

• To sort data in a table

• To delete a table

• To create a new table

Which SQL keyword is used to remove duplicate values from a query result?

• UNIQUE

• DISTINCT

• DELETE

• FILTER

What will ORDER BY age DESC do in an SQL query?

• Sort data in ascending order based on age

• Sort data in descending order based on age

• Remove duplicate age values

• Count the number of rows

What is the purpose of the JOIN statement in SQL?

• To merge two tables based on a common column

• To delete records from a table

• To update records in a table

• To create a new table

Which SQL command is used to add new data into a table?

• INSERT

• SELECT

• DELETE

• UPDATE