G10 End of Term 3

Which SQL statement is used to retrieve all columns from the students table?

• SELECT * FROM *;

• SELECT * FROM students;

• GET * FROM students;

• SHOW * FROM students;

Which keyword in SQL is used to filter out duplicate values in a column?

• FILTER

• UNIQUE

• DISTINCT

• SELECT UNIQUE

Which statement retrieves all students older than 18 from the students table?

• SELECT * FROM students WHERE age > 18;

• GET * FROM students WHERE age > 18;

• SELECT ALL FROM students WHERE age > 18;

• SHOW students WHERE age > 18;

Which SQL command is used to update a record in the employees table?

• MODIFY employees SET salary = 5000 WHERE id = 1;

• UPDATE employees SET salary = 5000 WHERE id = 1;

• CHANGE employees SET salary = 5000 WHERE id = 1;

• ALTER employees SET salary = 5000 WHERE id = 1;

What will happen if you run the following query? DELETE FROM students WHERE age < 18;

• All students will be deleted.

• All students younger than 18 will be deleted.

• The age column will be removed from the table.

• The query will result in an error.

Which statement uses the LIKE operator to retrieve all employees whose names start with 'A'?

• SELECT * FROM employees WHERE name LIKE 'A%';

• SELECT * FROM employees WHERE name = 'A%';

• SELECT * FROM employees WHERE name CONTAINS 'A';

• SELECT * FROM employees WHERE name STARTS WITH 'A';

Which statement is used to get the number of rows in the orders table?

• SELECT COUNT(*) FROM orders;

• COUNT * FROM orders;

• GET COUNT FROM orders;

• SELECT TOTAL FROM orders;

What will happen if you execute the TRUNCATE TABLE employees; statement?

• The entire employees table will be deleted.

• All data in the table will be deleted, but the table structure will remain.

• Rows in the table will be deleted based on a specified condition.

• The table will be deleted and recreated.

Which statement is used to get the total salary of all employees?

• SELECT TOTAL(salary) FROM employees;

• SELECT SUM(salary) FROM employees;

• SELECT salary SUM FROM employees;

• SUM(salary) FROM employees;

Which of the following correctly uses GROUP BY?

• A. SELECT id, COUNT(*) FROM employees GROUP BY id;

• B. SELECT id FROM employees GROUP BY name;

• C. SELECT COUNT(*) GROUP BY department FROM employees;

• D. SELECT * FROM employees GROUP department;