SQL Data Manipulation Commands Quiz

What command is used to add new rows to a table?

• UPDATE

• SELECT

• INSERT INTO

• DELETE

Which SQL command retrieves values from a table?

• SELECT

• INSERT

• UPDATE

• DELETE

What does the DISTINCT operator do in a SELECT statement?

• Retrieves values in order

• Retrieves values with conditions

• Retrieves unique values

• Retrieves all values

Which SQL clause is used to filter records based on a condition?

• ORDER BY

• WHERE

• DISTINCT

• LIKE

What is the purpose of the IS NULL operator in SQL?

• To sort records

• To retrieve all records

• To check if a field is not empty

• To check if a field is empty

How would you select all students in sections IT101, IT102, and IT103?

• SELECT * FROM Students WHERE Section BETWEEN 'IT101' AND 'IT103'

• SELECT * FROM Students WHERE Section LIKE 'IT10%'

• SELECT * FROM Students WHERE Section IN ('IT101', 'IT102', 'IT103')

• SELECT * FROM Students WHERE Section = 'IT101' OR Section = 'IT102' OR Section = 'IT103'

What SQL command would you use to modify existing records?

• SELECT

• UPDATE

• DELETE

• INSERT

Which SQL command removes records from a table?

• INSERT

• UPDATE

• SELECT

• DELETE

What is the correct syntax to sort results in descending order?

• ORDER BY column IN DESC

• ORDER BY column

• ORDER BY column DESC

• ORDER BY column ASC

If you want to select students aged between 13 and 15, which SQL command would you use?

• SELECT * FROM Students WHERE Age LIKE '1%'

• SELECT * FROM Students WHERE Age >= 13 AND Age <= 15

• SELECT * FROM Students WHERE Age BETWEEN 13 AND 15

• SELECT * FROM Students WHERE Age IN (13, 14, 15)