Update the 'quantity' column in a table named 'stock' to double the existing values.

UPDATE stock SET quantity = quantity * 2;

ALTER stock MODIFY quantity = quantity * 2;

UPDATE stock SET quantity = quantity + 2;

DELETE FROM stock WHERE quantity = quantity * 2;

Delete all records from a table named 'messages' where the 'timestamp' is older than one year.

DELETE FROM messages WHERE timestamp

DELETE FROM messages WHERE timestamp > NOW() - INTERVAL 1 YEAR;

DELETE * FROM messages WHERE timestamp

DELETE FROM messages WHERE timestamp

Create a table named 'orders' with columns 'order_id' (int), 'customer_id' (int), and 'order_date' (date).

CREATE TABLE orders (order_id INT, customer_id INT, order_date DATE);

CREATE orders (order_id INT, customer_id INT, order_date DATE);

CREATE TABLE orders (order_id VARCHAR, customer_id INT, order_date DATE);

CREATE TABLE order (order_id INT, customer_id INT, order_date DATE);

Alter the table 'students' to add a new column 'grade' (int) to store student grades.

ALTER TABLE students ADD grade INT;

UPDATE students SET grade = INT;

ADD COLUMN grade INT TO students;

Select the 'product_name' and 'unit_price' columns from a table named 'products' where 'category' is 'electronics'.

SELECT product_name, unit_price FROM products WHERE category = 'electronics';

SELECT product_name, category FROM products WHERE category = 'electronics';

SELECT product_name, unit_price FROM products WHERE category = 'appliances';

SELECT product_name, unit_price FROM products WHERE category = 'furniture';

Update the 'status' column in a table named 'tasks' to set all values to 'completed'.

UPDATE tasks SET status = 'completed';

UPDATE tasks SET status = 'cancelled';

UPDATE tasks SET status = 'pending';

UPDATE tasks SET status = 'in progress';

Delete all records from a table named 'logs' where the 'severity' is 'low'.

DELETE FROM logs WHERE severity = 'low';

DROP logs WHERE severity = 'low';

REMOVE FROM logs WHERE severity = 'low';

DELETE * FROM logs WHERE severity = 'low';

How can you update the 'price' column in a table named 'products' to set all values to 50?

UPDATE products SET price = 50;

UPDATE products SET price = '50';

ALTER TABLE products SET price = 50;

Create a SQL query to create a table named 'employees' with columns 'emp_id' (int), 'emp_name' (varchar), and 'emp_salary' (decimal).

CREATE TABLE employees (emp_id INT, emp_name VARCHAR(255), emp_salary DECIMAL(10,2));

CREATE TABLE employees (emp_id INT, emp_name VARCHAR(255), emp_salary VARCHAR);

CREATE TABLE employees (emp_id INT, emp_name DECIMAL, emp_salary VARCHAR(255));

CREATE TABLE employees (emp_id VARCHAR, emp_name INT, emp_salary DECIMAL(10,2));

Write a SQL query to create a table named 'departments' with columns 'dept_id' (int), 'dept_name' (varchar), and 'manager_id' (int).

CREATE TABLE departments (dept_id INT, dept_name VARCHAR(255), manager_id INT);

CREATE TABLE departments (dept_id VARCHAR, dept_name INT, manager_id DECIMAL(10,2));

CREATE TABLE departments (dept_id INT, dept_name DECIMAL, manager_id VARCHAR(255));

CREATE TABLE departments (dept_id DECIMAL, dept_name VARCHAR(255), manager_id INT);

What is the SQL query to update the 'quantity' column in a table named 'inventory' to reduce all values by 10%?

UPDATE inventory SET quantity = quantity * 0.9;

UPDATE inventory SET quantity = quantity - 10%;

ALTER TABLE inventory MODIFY quantity = quantity * 0.9;

UPDATE inventory SET quantity = quantity - 10;

Write a SQL query to select the 'product_name' and 'unit_price' columns from a table named 'products' where 'category' is 'clothing'.

SELECT product_name, unit_price FROM products WHERE category = 'clothing';

SELECT product_name, category FROM products WHERE category = 'clothing';

SELECT product_name, unit_price FROM products WHERE category = 'electronics';

SELECT product_name, unit_price FROM products WHERE category = 'furniture';

Update the 'status' column in a table named 'tasks' to set all values to 'in progress'.

UPDATE tasks SET status = 'in progress';

UPDATE tasks SET status = 'completed';

UPDATE tasks SET status = 'cancelled';

UPDATE tasks SET status = 'pending';

What is the SQL query to update the 'quantity' column in a table named 'inventory' to increase all values by 20%?

UPDATE inventory SET quantity = quantity * 1.2;

UPDATE inventory SET quantity = quantity + 20%;

ALTER TABLE inventory MODIFY quantity = quantity * 1.2;

UPDATE inventory SET quantity = quantity + 20;

Write a SQL query to select the 'title' and 'author' columns from a table named 'books' where 'genre' is 'fiction'.

SELECT title, author FROM books WHERE genre = 'fiction';

SELECT title, author FROM books WHERE genre = 'non-fiction';

SELECT title, author FROM books WHERE genre = 'mystery';

SELECT title, author FROM books WHERE genre = 'thriller';

What is the SQL query to delete all records from a table named 'students' where the 'grade' is below 60?

DELETE FROM students WHERE grade

DELETE * FROM students WHERE grade

REMOVE FROM students WHERE grade

Create a SQL query to add a new column 'email' (varchar) to an existing table named 'users'.

ALTER TABLE users ADD email VARCHAR;

ADD COLUMN email VARCHAR TO users;

UPDATE users SET email = 'New Email';

CREATE NEW COLUMN email IN users;

What is the SQL query to update the 'price' column in a table named 'products' to increase all values by 10%?

UPDATE products SET price = price * 1.1;

UPDATE products SET price = price + 10%;

ALTER TABLE products MODIFY price = price * 1.1;

UPDATE products SET price = price + 10;

How can you delete a column 'phone' (varchar) from an existing table named 'contacts'?

ALTER TABLE contacts DROP COLUMN phone;

DELETE COLUMN phone FROM contacts;

Write a SQL query to select the 'name' and 'age' columns from a table named 'users' where 'gender' is 'female'.

SELECT name, age FROM users WHERE gender = 'female';

SELECT name, age FROM users WHERE gender = 'male';

SELECT name, age FROM users WHERE gender = 'other';

SELECT name, age FROM users WHERE gender = 'unknown';

SQL Query Quiz

Quiz

•

Computers

•

12th Grade

•

Practice Problem

•

Easy

KAREN TAN

Used 3+ times

FREE Resource

SELECT name, salary FROM employees WHERE department = 'Finance';

SELECT name, salary FROM employees WHERE department = 'HR';

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

Apple

Others

Already have an account?

Similar Resources on Wayground

25 questions

Exercise Nettiquette

Quiz

•

12th Grade

28 questions

MAWD 1.01 B

Quiz

•

KG - University

25 questions

Web Design - Unit 2 CodeHS

Quiz

•

12th Grade

25 questions

Bimbel Teori Kejuruan TKJ 03

Quiz

•

12th Grade

25 questions

DMI - Quiz SAS

Quiz

•

12th Grade

25 questions

Basic HTML 2

Quiz

•

7th - 12th Grade

25 questions

TIK SMP

Quiz

•

7th - 12th Grade

25 questions

JavaScript Certification Quiz

Quiz

•

12th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade