SQL 3 – Quiz | Divex Consult

1. Which SQL statement is used to retrieve data from a database table? *

A) GET

B) FETCH

C) SELECT

D) RETRIEVE

2. What does the following SQL statement do?
SELECT * FROM Customers; *

A) Selects all columns from the Customers table

B) Selects only unique values from the Customers table

C) Deletes all records from the Customers table

D) Shows the table structure of Customers

3. What will this query return?
SELECT First_Name, Last_Name FROM Customers WHERE City = 'New York'; *

A) All customers in the database

B) Only customers who live in New York

C) Customers whose first or last name contains ‘New York’

D) Customers with missing city information

4. What does the IN operator do in SQL? *

A) Checks if a column contains NULL values

B) Filters results based on a list of specific values

C) Joins two tables together

D) Sorts data in ascending order

5. What will this query return?
SELECT * FROM Orders WHERE Status IN ('Shipped', 'Delivered'); *

A) Only orders that are Shipped or Delivered

B) Orders where the status is not Shipped or Delivered

C) Orders where the status contains the letter ‘S’

D) Orders that were placed today

6. What does the BETWEEN operator do in SQL? *

A) Filters values within a range, including the boundary values

B) Finds values that are missing

C) Checks if a value is not in a specific list

D) Sorts results in descending order

7. What will this query return?
SELECT * FROM Products WHERE Price BETWEEN 500 AND 1000; *

A) Products priced below 500

B) Products priced exactly at 500 and 1000

C) Products priced between 500 and 1000, inclusive

D) Products that are out of stock

8. What does the % wildcard do in SQL LIKE statements? *

A) Matches a single character

B) Matches zero or more characters

C) Finds exact matches only

D) Ignores case sensitivity

9. What will this query return?
SELECT * FROM Customers WHERE Email LIKE '%@gmail.com'; *

A) Customers whose email ends with @gmail.com

B) Customers whose email contains gmail.com anywhere

C) Customers with no email address

D) Customers from the Gmail office

10. How would you find all products that start with "S" in the Products table? *

A) SELECT * FROM Products WHERE Product_Name = 'S%';

B) SELECT * FROM Products WHERE Product_Name LIKE 'S%';

C) SELECT * FROM Products WHERE Product_Name LIKE '%S';

D) SELECT * FROM Products WHERE Product_Name IN ('S');

Structured Query Language(SQL)

SQL 3 – Quiz