![[Quizz đầu giờ] Session 5](https://cf.quizizz.com/img/wayground/activity/activity-square.jpg?w=200&h=200)
[Quizz đầu giờ] Session 5
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Medium
Quốc Trần
Used 5+ times
FREE Resource
Enhance your content in a minute
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu lệnh SQL nào dưới đây dùng để thay đổi tên của một nhân viên có ID = 1 trong bảng Employees?
UPDATE Employees SET name = 'Michael' WHERE id = 1
UPDATE Employees SET name = 'Michael' WHERE employee_id = 1
CHANGE Employees SET name = 'Michael' WHERE id = 1
MODIFY Employees SET name = 'Michael' WHERE id = 1
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu lệnh SQL nào dùng để thay đổi cả tên và vị trí của một nhân viên có ID = 1 trong bảng Employees?
UPDATE Employees SET name = 'John', position = 'Manager' WHERE id = 1
CHANGE Employees SET name = 'John', position = 'Manager' WHERE id = 1
MODIFY Employees SET name = 'John', position = 'Manager' WHERE id = 1
UPDATE Employees SET name = 'John' AND position = 'Manager' WHERE id = 1
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu lệnh SQL nào sẽ xóa tất cả các bản ghi trong bảng Employees có tên là 'John'?
DELETE FROM Employees WHERE name = 'John'
REMOVE FROM Employees WHERE name = 'John'
DELETE * FROM Employees WHERE name = 'John'
REMOVE * FROM Employees WHERE name = 'John'
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu lệnh SQL nào dưới đây sử dụng LEFT JOIN để lấy tất cả bản ghi từ bảng Students và các bản ghi khớp từ bảng Courses?
SELECT Students.name, Courses.course_name FROM Students LEFT JOIN Courses ON Students.course_id = Courses.course_id;
SELECT Students.name, Courses.course_name FROM Students RIGHT JOIN Courses ON Students.course_id = Courses.course_id;
SELECT Students.name, Courses.course_name FROM Students INNER JOIN Courses ON Students.course_id = Courses.course_id;
SELECT Students.name, Courses.course_name FROM Students OUTER JOIN Courses ON Students.course_id = Courses.course_id;
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu lệnh SQL nào sau đây sẽ thay đổi tên của nhân viên có ID = 2 và vị trí của nhân viên đó thành 'Developer'?
UPDATE Employees SET name = 'Alice', position = 'Developer' WHERE id = 2
MODIFY Employees SET name = 'Alice', position = 'Developer' WHERE id = 2
CHANGE Employees SET name = 'Alice', position = 'Developer' WHERE id = 2
UPDATE Employees SET name = 'Alice' AND position = 'Developer' WHERE id = 2
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu lệnh SQL nào dưới đây sử dụng INNER JOIN để kết hợp các bảng Students và Courses dựa trên cột chung course_id?
SELECT Students.name, Courses.course_name FROM Students INNER JOIN Courses ON Students.course_id = Courses.course_id;
SELECT Students.name, Courses.course_name FROM Students LEFT JOIN Courses ON Students.course_id = Courses.course_id;
SELECT Students.name, Courses.course_name FROM Students RIGHT JOIN Courses ON Students.course_id = Courses.course_id;
SELECT Students.name, Courses.course_name FROM Students OUTER JOIN Courses ON Students.course_id = Courses.course_id;
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Câu lệnh SQL nào dưới đây sẽ bỏ qua 5 bản ghi đầu tiên và lấy 10 bản ghi tiếp theo từ bảng Employees?
SELECT * FROM Employees LIMIT 10 OFFSET 5;
SELECT * FROM Employees LIMIT 5 OFFSET 10;
SELECT * FROM Employees OFFSET 5 LIMIT 10;
SELECT * FROM Employees OFFSET 10 LIMIT 5;
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
TN +2 -LESSON1 FUNCTIONS
Quiz
•
12th Grade
10 questions
Women in Tech by Sisters of Code
Quiz
•
9th - 12th Grade
14 questions
Microsoft Excel Advanced Features
Quiz
•
1st Grade - University
11 questions
Technology Morning Tea Quiz
Quiz
•
KG - Professional Dev...
15 questions
عمارة الحاسب
Quiz
•
5th - 12th Grade
10 questions
ASJ Quiz Kelas XII
Quiz
•
12th Grade
10 questions
Visual Basic 2010
Quiz
•
8th Grade - University
12 questions
1.2.4. Types of Programming Language
Quiz
•
12th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
15 questions
Christmas Song Emoji Pictionary
Quiz
•
7th - 12th Grade
20 questions
Christmas Movies
Quiz
•
1st - 12th Grade
55 questions
CHS Holiday Trivia
Quiz
•
12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
29 questions
christmas facts
Lesson
•
5th - 12th Grade
20 questions
Christmas Trivia
Quiz
•
5th - 12th Grade
20 questions
Stages of Meiosis
Quiz
•
9th - 12th Grade
