SQL Query Quiz

SQL Query Quiz

12th Grade

•

30 Qs

quiz-placeholder

Similar activities

Understanding Input, Selection and Loops in Python

Understanding Input, Selection and Loops in Python

7th Grade - University

•

25 Qs

KELAS 12 MIA

KELAS 12 MIA

12th Grade

•

25 Qs

Uji Pengetahuan Multimedia Interaktif

Uji Pengetahuan Multimedia Interaktif

12th Grade

•

25 Qs

Pangkalan Data 2

Pangkalan Data 2

8th - 12th Grade

•

25 Qs

Logical Thinking and MS Word Quiz

Logical Thinking and MS Word Quiz

5th Grade - University

•

25 Qs

Latihan Soal Persiapan SAS

Latihan Soal Persiapan SAS

12th Grade

•

35 Qs

CodeHS APCSP Programming with Python

CodeHS APCSP Programming with Python

9th - 12th Grade

•

26 Qs

Common Algorithms

Common Algorithms

9th - 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?