Search Header Logo

СУБД MySQL. Манипулирование данными

Authored by Наталья Лаптинская

Computers

University

Used 4+ times

СУБД MySQL. Манипулирование данными
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

26 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Дана таблица employees с полями id (INT, PK), name (VARCHAR), salary (DECIMAL). Напишите SQL-запрос для добавления нового сотрудника с именем "John Doe" и зарплатой 50000.

INSERT INTO employees VALUES ('John Doe', 50000);

INSERT INTO employees (name, salary) VALUES ('John Doe', 50000);

ADD INTO employees (name, salary) VALUES ('John Doe', 50000);

INSERT employees (name, salary) VALUES ('John Doe', 50000);

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Какой запрос удалит все записи из таблицы orders?

DELETE FROM orders;

DROP TABLE orders;

DELETE orders;

REMOVE FROM orders;

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Дана таблица products с полями product_id (INT, PK), name (VARCHAR), price (DECIMAL). Напишите запрос для обновления цены продукта с product_id = 5 до 99.99.

UPDATE products WHERE product_id = 5 SET price = 99.99;

MODIFY products SET price = 99.99 WHERE product_id = 5;

UPDATE products SET price = 99.99 WHERE product_id = 5;

CHANGE products price = 99.99 WHERE product_id = 5;

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Какой запрос добавит сразу две записи в таблицу clients с полями client_id (INT, PK), name (VARCHAR)?

INSERT INTO clients (name) VALUES ('Alice'), ('Bob');

INSERT INTO clients VALUES ('Alice', 'Bob');

INSERT INTO clients (name) VALUES ('Alice'; 'Bob');

ADD clients (name) VALUES ('Alice', 'Bob');

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Дана таблица books с полями book_id (INT, PK), title (VARCHAR), stock (INT). Напишите запрос для уменьшения значения stock на 1 для книги с book_id = 10.

UPDATE books SET stock -= 1 WHERE book_id = 10;

UPDATE books SET stock = stock - 1 WHERE book_id = 10;

MODIFY books SET stock = stock - 1 WHERE book_id = 10;

UPDATE books WHERE book_id = 10 stock = stock - 1;

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Какой запрос удалит записи из таблицы logs с log_date раньше 2023-01-01?

DELETE FROM logs WHERE log_date < '2023-01-01';

REMOVE logs WHERE log_date < '2023-01-01';

DELETE logs WHERE log_date < 2023-01-01;

DROP logs WHERE log_date < '2023-01-01';

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Дана таблица users с полями user_id (INT, PK), email (VARCHAR), status (VARCHAR). Напишите запрос для изменения статуса на 'active' для пользователя с user_id = 3.

MODIFY users status = 'active' WHERE user_id = 3;

UPDATE users WHERE user_id = 3 SET status = 'active';

UPDATE users SET status = 'active' WHERE user_id = 3;

CHANGE users SET status = 'active' WHERE user_id = 3;

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?