- | P a g e
WGU D427 Objective Assessment final exam 100 questions covering data modeling, SQL queries, database design, normalization, and relational database management systems.
Write a query to find the average amount of cars in the Neighborhood Table - ANSWER-SELECT AVG(Cars) FROM Neighborhood;
Write a query to find the total number of trees in the Neighborhood table - ANSWER-SELECT SUM(Trees) FROM Neighborhood;
Select all records for customers in the Customers table with a CustomerName starting with "a" - ANSWER-SELECT * FROM Customers WHERE CustomerName LIKE 'a%';
Write a query that selects all records for customers with a CustomerName ending with "a" - ANSWER-SELECT * 1 / 3
- | P a g e
FROM Customers WHERE CustomerName LIKE '%a';
Write a query that selects records for all customers with a CustomerName that have "a" in any position - ANSWER-
SELECT *
FROM Customers WHERE CustomerName LIKE '%a%';
Write a query that selects all records for customers with a CustomerName that have "a" in the second position -
ANSWER-SELECT *
FROM Customers WHERE CustomerName LIKE '_a%';
Write a query that selects all customers with a CustomerName that starts with "a" and are at least 3 characters in length -
ANSWER-SELECT *
FROM Customers WHERE CustomerName LIKE 'a_%';
- / 3
- | P a g e
Write a query that selects all customers with a ContactName that starts with "a" and ends with "o" - ANSWER-SELECT * FROM Customers WHERE ContactName LIKE 'a%o';
Write a query that selects all customers with a CustomerName that does NOT start with "a" - ANSWER-SELECT * FROM Customers WHERE CustomerName NOT LIKE 'a%';
Write a query that selects all customers that are located in "Germany", "France" or "UK" - ANSWER-SELECT * FROM Customers WHERE Country IN ('Germany,', 'France', 'UK');
Write a query that selects all customers that are NOT located in "Germany", "France" or "UK" - ANSWER-SELECT * FROM Customers WHERE Country NOT IN ('Germany,', 'France', 'UK');
- / 3