SQL Select 1
Authored by Halyna Melnyk
Computers
Professional Development
Used 81+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How to select all data from the table my_table_name?
SELECT * FROM my_table_name
SELECT ALL FROM my_table_name
SELECT ANY FROM my_table_name
SELECT ALL ROWS FROM my_table_name
2.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
How to select only rows which are equal by the condition?
SELECT * FROM my_table_name WHERE city = 'Berlin'
SELECT * FROM my_table_name WHERE city LIKE 'Berlin'
SELECT * FROM my_table_name WHERE city EQUAL 'Berlin'
SELECT * FROM my_table_name WHERE city EQUALS TO 'Berlin'
3.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
How to select only rows which aren't equal by the condition?
SELECT * FROM my_table_name WHERE city <> 'Berlin'
SELECT * FROM my_table_name WHERE city NOT LIKE 'Berlin'
SELECT * FROM my_table_name WHERE city NOT EQUAL 'Berlin'
SELECT * FROM my_table_name WHERE city NOT IN ('Berlin')
4.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
How to select only specific columns from the table?
SELECT city, country FROM customers
SELECT customers.city, customers.country FROM customers
SELECT c.city, c.country FROM customers c
SELECT COLUMNS city, country FROM customers
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How to select values by many conditions? (choose all possible options)
SELECT * FROM Products WHERE price = 18 OR price = 19
SELECT * FROM Products WHERE price = 18 BETWEEN name LIKE 'nik'
SELECT * FROM Products WHERE price = 18 AND name LIKE 'nik'
SELECT * FROM Products WHERE price = 18 IN name LIKE 'nik'
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the proposed statements can return a result that is less or more than the given value?
SELECT * FROM Products WHERE price < 18
SELECT * FROM Products WHERE price LESS THEN 18
SELECT * FROM Products WHERE price BY 18
SELECT * FROM Products WHERE price BETWEEN 18 AND 100
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How to select only NULL values?
SELECT * FROM Products WHERE price = NULL
SELECT * FROM Products WHERE price LIKE NULL
SELECT * FROM Products WHERE price IS NULL
SELECT * FROM Products WHERE price EQUALS NULL
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
%20(1).png)
Apple
Others
Already have an account?
