Mastering Basic SQL Commands

Which SQL statement is used to update the `age` of a student named 'Alice' in the `students` table to 16?

• UPDATE students SET age = 16 WHERE name = 'Alice'

• UPDATE students age = 16 WHERE name = 'Alice'

• SET age = 16 WHERE name = 'Alice' IN students

• MODIFY students SET age = 16 WHERE name = 'Alice'

How do you delete a record from the `students` table where the `name` is 'Bob'?

• DELETE FROM students WHERE name = 'Bob'

• REMOVE FROM students WHERE name = 'Bob'

• DELETE students WHERE name = 'Bob'

• DELETE FROM students name = 'Bob'

What is the correct syntax to update the `grade` to 'A' for all students in the `students` table who are 15 years old?

• UPDATE students SET grade = 'A' WHERE age = 15

• UPDATE students grade = 'A' WHERE age = 15

• SET grade = 'A' WHERE age = 15 IN students

• MODIFY students SET grade = 'A' WHERE age = 15

What will happen if you try to delete a record from the `students` table without a WHERE clause?

• It will delete all records from the table.

• It will delete the first record from the table.

• It will return an error.

• It will delete no records.

Which of the following statements will correctly update the `name` of a student with `id` 3 to 'David'?

• UPDATE students SET name = 'David' WHERE id = 3

• UPDATE students name = 'David' WHERE id = 3

• SET name = 'David' WHERE id = 3 IN students

• MODIFY students SET name = 'David' WHERE id = 3

How do you delete all students who have a NULL value in the `age` column?

• DELETE FROM students WHERE age IS NULL

• DELETE FROM students WHERE age = NULL

• DELETE FROM students WHERE age EQUALS NULL

• DELETE FROM students WHERE age NULL

What is the result of the following SQL statement? `SELECT * FROM students WHERE age IS NOT NULL;`

• It returns all rows with non-NULL `age` values.

• It returns all rows with NULL `age` values.

• It returns an error.

• It returns all rows.

How do you update the `age` of all students to 17 in the `students` table?

• UPDATE students SET age = 17

• UPDATE students age = 17

• SET age = 17 IN students

• MODIFY students SET age = 17

Which SQL statement will delete a student with `id` 5 from the `students` table?

• DELETE FROM students WHERE id = 5

• REMOVE FROM students WHERE id = 5

• DELETE students WHERE id = 5

• DELETE FROM students id = 5

What is the correct SQL statement to find all students with the name 'John' in the `students` table?

• SELECT * FROM students WHERE name = 'John'

• SEARCH * FROM students WHERE name = 'John'

• FIND * FROM students WHERE name = 'John'

• SELECT * FROM students name = 'John'