SQL Quiz

SQL Quiz

12th Grade

14 Qs

quiz-placeholder

Similar activities

Red Planet

Red Planet

9th - 12th Grade

17 Qs

CHECK YOUR KNOWLEDGE

CHECK YOUR KNOWLEDGE

10th - 12th Grade

10 Qs

Disney Personalities

Disney Personalities

5th Grade - University

15 Qs

Pop Culture Trivia 2020

Pop Culture Trivia 2020

KG - Professional Development

15 Qs

DofE training refresher

DofE training refresher

10th - 12th Grade

18 Qs

Football Quiz

Football Quiz

KG - Professional Development

15 Qs

Exoictic cars.

Exoictic cars.

5th Grade - Professional Development

10 Qs

Ohio Valley College of Technology

Ohio Valley College of Technology

KG - University

10 Qs

SQL Quiz

SQL Quiz

Assessment

Quiz

Other

12th Grade

Practice Problem

Medium

Created by

Debbie Unterseher

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...

14 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Imagine you are a database administrator for a retail company. You need to generate a report that includes all details from the 'Customers' table. Which SQL command would you use?

SELECT * FROM Customers;

INSERT INTO Customers;

UPDATE Customers SET ContactName;

SELECT Country FROM Customers;

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL command is used to select only unique countries from the Customers table?

SELECT Country FROM Customers;

SELECT DISTINCT Country FROM Customers;

SELECT * FROM Customers WHERE Country='Germany';

SELECT * FROM Customers ORDER BY Country;

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Imagine you are managing a database for a bookstore. How would you correctly update the contact name to 'Alfred Smith' for a customer with CustomerID = 1?

UPDATE Customers SET ContactName='Alfred Smith' WHERE CustomerID = 1;

INSERT INTO Customers SET ContactName='Alfred Smith';

SELECT * FROM Customers WHERE ContactName='Alfred Smith';

UPDATE Customers SET ContactName='Juan';

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Imagine you're a database administrator for a bookstore. You need to add a new customer, John Doe, who is 30 years old and lives in the USA, into the Customers table. Which SQL statement would you use?

UPDATE Customers (customer_id, first_name, last_name, age, country) VALUES (5, 'John', 'Doe', '30', 'USA');

UPDATE Customers SET first_name = 'John', last_name = 'Doe', age = '30', country = 'USA' WHERE customer_id = 5;

INSERT INTO Customers (first_name, last_name, age, country) VALUES ('John', 'Doe', '30', 'USA');

SELECT * INTO Customers FROM (SELECT 'John', 'Doe', '30', 'USA);

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Imagine you are managing an online bookstore. How can you display ONLY the book titles from the Books table?

SELECT titles FROM Books;

SELECT * FROM Books;

DISPLAY titles FROM Books;

Select FROM Books ORDER BY title;

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Imagine you are a database administrator for a library. You need to display all of the records from the Members table in order by last name in descending order. Which SQL query would you use?

SELECT * FROM Members ORDER BY last_name DESC;

SELECT * FROM Members SORT BY last_name DESC;

SELECT * FROM Members ORDER BY DESCENDING last_name;

SELECT * FROM Members WHERE ORDER BY DESC last_name;

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Imagine you are a database administrator for a retail company. You want to send a special promotional email to all young customers. What SQL statement would you use to select all customers from the database where the customer age is less than 25?

SELECT * FROM Customers WHERE age < 25;

SELECT * FROM Customers WHERE age <= 25;

SELECT * FROM Customers WHERE age > 25;

SELECT * FROM Customers WHERE age = 25;

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?