ICT AssessmentVersion en ligne Easy but not Easy par ANN SOKHEANG 1 _____ INTO students (id, name, age) VALUES (101, 'John', 15); a SELECT b INSERT c UPDATE d DELETE e IDK 2 _____ students SET age = 16 WHERE id = 101; a SELECT b UPDATE c INSERT d DELETE 3 _____ FROM students WHERE age < 10; a DELETE b SELECT c INSERT d UPDATE 4 Which SQL clause is used to combine rows from two or more tables based on a related column? a ON b LEFT JOIN c RIGHT JOIN d INNER JOIN 5 What type of JOIN returns all records from the left table and matching records from the right table? a ON b LEFT JOIN c RIGHT JOIN d INNER JOIN 6 SELECT name FROM students WHERE id = (_____ id FROM enrollments WHERE course = 'Math'); a INSERT b UPDATE c SELECT d DELETE 7 SELECT name FROM employees WHERE salary > (_____ AVG(salary) FROM employees); a SELECT b UPDATE c INSERT d DELETE 8 SELECT name FROM students WHERE age > (_____ age FROM students WHERE name = 'John'); a SELECT b UPDATE c DELETE d INSERT 9 Which SQL clause is used to filter records based on a condition? a FROM b AS c WHERE d ON 10 What did you learn after my lecture? Written answer
Créer jeu