SQL Quiz

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;

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;

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';

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);

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;

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;

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;

Which SQL command will retrieve all of the records from the Customers table whose last name starts with an 'R'?

• SELECT * FROM Customers WHERE lastname='R'

• SELECT * FROM Customers WHERE lastname LIKE 'R%'

• SELECT * FROM Customers WHERE lastname STARTS WITH 'R'

• SELECT * FROM Customers WHERE lastname='R_'

Imagine you are managing a database for a library. You need to find all books from the 'Authors' table whose last name starts with an 'R' but consists of only three letters. How would you retrieve this information?

• SELECT * from Authors where lastname='R__'

• SELECT * from Authors where lastname LIKE 'R__'

• SELECT * from Authors where lastname STARTS WITH 'R' LIMIT 3

• SELECT * from Authors where lastname='R_' LIMIT 3

What does this command do? SELECT * FROM Customers where City in ('Lincoln', 'Omaha');

• Selects all of the customers who live in Lincoln or Omaha.

• Checks to see if they live in Lincoln or Omaha.

• Makes sure that they can only live in Lincoln or Omaha.

• Invalid command.