Basic SQL Quiz

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Sequential Query Language

• Standard Query Language

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

• INSERT

• SELECT

• UPDATE

• DELETE

How do you select all columns from a table named 'students'?

• SELECT * FROM students;

• SELECT columns FROM students;

• SELECT all FROM students;

• SELECT students;

Which SQL statement is used to insert a new record into a table?

• INSERT INTO

• ADD NEW

• ADD RECORD

• INSERT RECORD

How do you delete a record from the table 'students' where the 'id' is 5?

• DELETE FROM students WHERE id=5;

• REMOVE FROM students WHERE id=5;

• DELETE id 5 FROM students;

• REMOVE id 5 FROM students;

What is the correct SQL statement to update the 'name' to 'John' in the table 'students' where the 'id' is 3?

• UPDATE students SET name='John' WHERE id=3;

• MODIFY students SET name='John' WHERE id=3;

• UPDATE students CHANGE name TO 'John' WHERE id=3;

• SET students UPDATE name='John' WHERE id=3;

What does the 'WHERE' clause do in SQL?

• Limits the number of rows returned

• Specifies the condition for selecting rows

• Determines the order of the rows

• Changes the values in the columns

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

• ORDER BY

• SORT BY

• ARRANGE BY

• GROUP BY

How do you select all records from the 'students' table where the 'age' is greater than 15?

• SELECT * FROM students WHERE age > 15;

• SELECT * FROM students WHERE age = 15;

• SELECT * FROM students WHERE age < 15;

• SELECT * FROM students WHERE age != 15;

Which SQL function is used to calculate the total number of rows in a table?

• COUNT()

• SUM()

• TOTAL()

• NUMBER()