1|Page
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 *
,2|Page
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|Page
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');
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 *
,2|Page
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|Page
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');
