SQL Query Quiz

SQL Query Quiz

12th Grade

30 Qs

quiz-placeholder

Similar activities

Kuis PBO 1

Kuis PBO 1

KG - University

25 Qs

Types of Network and Defensive Design

Types of Network and Defensive Design

9th - 12th Grade

25 Qs

soal semester 1 kelas 8

soal semester 1 kelas 8

7th Grade - University

25 Qs

TINHOC25CAUTN

TINHOC25CAUTN

12th Grade

25 Qs

MS Excel Mastery

MS Excel Mastery

12th Grade

25 Qs

UH-IX-1-Informatika-Bab 1

UH-IX-1-Informatika-Bab 1

12th Grade - University

25 Qs

Operating system

Operating system

7th Grade - University

25 Qs

ICT Test 2

ICT Test 2

8th - 12th Grade

25 Qs

SQL Query Quiz

SQL Query Quiz

Assessment

Quiz

Computers

12th Grade

Practice Problem

Easy

Created by

KAREN TAN

Used 3+ 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

1 min • 20 pts

Write a SQL query to select all columns from a table named 'students'.

SELECT columns FROM students;

SELECT * FROM student;

SELECT * FROM table students;

SELECT * FROM students;

2.

MULTIPLE CHOICE QUESTION

1 min • 20 pts

How can you update the 'age' column in a table named 'employees' to set all values to 30?

UPDATE employees SET age = 30

UPDATE employees SET age = '30'

ALTER TABLE employees SET age = 30

SET age = 30 WHERE employees

3.

MULTIPLE CHOICE QUESTION

1 min • 20 pts

What is the SQL query to delete all records from a table named 'orders' where the 'status' is 'cancelled'?

DROP FROM orders WHERE status = 'cancelled';

REMOVE FROM orders WHERE status = 'cancelled';

DELETE FROM orders WHERE status = 'cancelled';

DELETE * FROM orders WHERE status = 'cancelled';

4.

MULTIPLE CHOICE QUESTION

1 min • 20 pts

Create a SQL query to create a table named 'products' with columns 'id' (int), 'name' (varchar), and 'price' (decimal).

CREATE TABLE products (id INT, name VARCHAR(255), price DECIMAL(10,2));

CREATE TABLE products (id INT, name VARCHAR(255), price VARCHAR);

CREATE TABLE products (id INT, name DECIMAL, price VARCHAR(255));

CREATE TABLE products (id VARCHAR, name INT, price DECIMAL(10,2));

5.

MULTIPLE CHOICE QUESTION

1 min • 20 pts

How can you add a new column 'address' (varchar) to an existing table named 'customers'?

CREATE NEW COLUMN address IN customers

ALTER TABLE customers ADD address VARCHAR;

ADD COLUMN address VARCHAR TO customers

UPDATE customers SET address = 'New Address'

6.

MULTIPLE CHOICE QUESTION

1 min • 20 pts

What is the SQL query to drop a table named 'inventory' from the database?

DROP TABLE inventory;

DELETE TABLE inventory;

DROP DATABASE inventory;

REMOVE TABLE inventory;

7.

MULTIPLE CHOICE QUESTION

1 min • 20 pts

Write a SQL query to select the 'name' and 'salary' columns from a table named 'employees' where 'department' is 'IT'.

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

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

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

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?