SQL Basics Quiz for Students

What is the purpose of the PRIMARY KEY in an SQL table?

• To store the first column of data

• To ensure no duplicate values and identify each record uniquely

• To allow NULL values in the table

• To link two tables together

Which SQL command is used to create a new database?

• CREATE DATABASE

• INSERT DATABASE

• ADD DATABASE

• MAKE DATABASE

What does the FOREIGN KEY constraint do?

• It creates a unique identifier for each record

• It links data from two tables based on a common field

• It allows duplicate values in the table

• It updates multiple tables at once

Which of the following is NOT a valid SQL data type?

• varchar

• int

• float

• string

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

• DROP TABLE

• DELETE TABLE

• REMOVE TABLE

• CLEAR TABLE

Which SQL clause is used to filter records?

• WHERE

• FILTER

• SELECT

• ORDER BY

What is the function of the SQL command SELECT?

• To delete records from a table

• To update records in a table

• To retrieve data from a database

• To insert new records into a table

What is the purpose of the SQL command GROUP BY?

• To group rows that have the same values in specified columns into summary rows

• To sort the result set in ascending or descending order

• To filter records based on a condition

• To join two or more tables

What does the SQL command INSERT INTO do?

• It deletes records from a table

• It updates existing records in a table

• It adds new records to a table

• It creates a new table

Which SQL keyword is used to sort the result-set?

• SORT BY

• ORDER BY

• ARRANGE BY

• ORGANISE BY