[TPLUS]_DB_MD02_Session04

[TPLUS]_DB_MD02_Session04

University

30 Qs

quiz-placeholder

Similar activities

Professional Selling - Unit 2 Exam

Professional Selling - Unit 2 Exam

University

25 Qs

Fiscal Policy Quiz

Fiscal Policy Quiz

University

25 Qs

Horizon Scanning Quiz

Horizon Scanning Quiz

12th Grade - University

25 Qs

UAS_KELAS A

UAS_KELAS A

University

25 Qs

Brain Teaser

Brain Teaser

3rd Grade - University

25 Qs

Latihan Bahasa Indonesia

Latihan Bahasa Indonesia

University

25 Qs

PSY 362 Practice Exam Prep #1

PSY 362 Practice Exam Prep #1

University

25 Qs

r/Nintendo - The Triforce of Trivia!

r/Nintendo - The Triforce of Trivia!

6th Grade - Professional Development

25 Qs

[TPLUS]_DB_MD02_Session04

[TPLUS]_DB_MD02_Session04

Assessment

Quiz

Other

University

Medium

Created by

academy rikkei

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Câu lệnh nào dùng để thêm dữ liệu vào bảng?

ADD

INSERT

UPDATE

APPEND

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Câu lệnh SQL nào để cập nhật cột salary của nhân viên có id = 5?

UPDATE employee SET salary = 1000 WHERE id = 5;

MODIFY employee SET salary = 1000 WHERE id = 5;

CHANGE employee salary = 1000 WHERE id = 5;

SET salary = 1000 IN employee WHERE id = 5;

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Câu lệnh xóa tất cả bản ghi khỏi bảng customers:

REMOVE FROM customers;

DELETE * FROM customers;

DELETE FROM customers;

DROP TABLE customers;

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Lấy tất cả dữ liệu từ bảng students:

SELECT * FROM students;

FETCH * FROM students;

SHOW ALL students;

GET ALL FROM students;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Lấy danh sách tên (name) và tuổi (age) từ bảng users:

SELECT name AND age FROM users;

SELECT (name, age) FROM users;

SHOW name, age FROM users;

SELECT name, age FROM users;

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Lấy dữ liệu không trùng lặp cột city từ bảng customers:

SELECT UNIQUE city FROM customers;

SELECT DISTINCT city FROM customers;

SELECT city FROM customers WHERE UNIQUE;

SELECT city DISTINCT FROM customers;

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Sắp xếp dữ liệu bảng products theo price giảm dần:

ORDER products BY price ASC;

SELECT * FROM products ORDER BY price ASC;

SELECT * FROM products ORDER BY price DESC;

SELECT * ORDER BY price ASC FROM products;

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?