Search Header Logo

[TPLUS]_DB_MD02_Session04

Authored by haibt@rikkei.edu.vn rikkei

Other

University

Used 1+ times

[TPLUS]_DB_MD02_Session04
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

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;

Access all questions and much more by creating a free account

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

Already have an account?