WGU D427 DATABASE MANAGEMENT
APPLICATIONS ACTUAL
CERTIFICATION PAPER 2026
QUESTIONS WITH ANSWERS FULL
SOLUTION.
⚫ SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');. Answer:
What would the SELECT statement look like if you use a IN.
⚫ SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%';. Answer: What would the SELECT
statement look like if you use a LIKE.
⚫ A% - The "%" means that any string of characters can follow
afterwards. The percent sign represents zero or more arbitrary regular
characters
A_ - The _ means that there will be exactly one letter following the A.
The underscore represents a single arbitrary regular character..
Answer: What are the two ways of using the LIKE command?
,⚫ The clause can include the term ASC at the end to make
ascending explicit or it can include DESC for descending order..
Answer: The default order for ORDER BY is ascending. How can
you make it descending order?
⚫ SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
FROM SALES
WHERE Name = 'Matt';. Answer: Command to use
AVG/SUM/MIN/MAX/COUNT aggregate functions?
⚫ o One is that the tables to be joined must be listed in the FROM
clause.
o Two is that the join attributes in the tables being joined must be
declared and matched to each other in the WHERE clause.. Answer:
There are two specifications to make in the SELECT statement to
make a join work.
⚫ SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM. Answer:
Example of JOIN CAUSE.
⚫ Dr. CODD. Answer: In 1970, Dr. _________ of IBM published in
Communications of the ACM a paper entitled "A Relational Model of
Data for Large Shared Data Banks." This paper marked the beginning
of the field of relational databases.
⚫ CREATE TABLE
, DROP TABLE. Answer: Commands to create and drop a table?
⚫ - When you create the column definition (known as a column
constraint).
- When you use the CONSTRAINT keyword (known as a table
constraint).. Answer: The CREATE TABLE command lets you define
constraints in two different places:
⚫ NOT
WHERE Location NOT IN ('WV', TN' 'CA');
WHERE Total NOT Between '1000', 2000';
WHERE Name NOT LIKE 'Ma%';. Answer: You can exclude rows
with other types of conditions by using the ______ operator.
⚫ USE
USE MainDatabase. Answer: The _____ command tells the database
system which database you're going to be using for the upcoming
commands.
⚫ SHOW
APPLICATIONS ACTUAL
CERTIFICATION PAPER 2026
QUESTIONS WITH ANSWERS FULL
SOLUTION.
⚫ SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');. Answer:
What would the SELECT statement look like if you use a IN.
⚫ SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%';. Answer: What would the SELECT
statement look like if you use a LIKE.
⚫ A% - The "%" means that any string of characters can follow
afterwards. The percent sign represents zero or more arbitrary regular
characters
A_ - The _ means that there will be exactly one letter following the A.
The underscore represents a single arbitrary regular character..
Answer: What are the two ways of using the LIKE command?
,⚫ The clause can include the term ASC at the end to make
ascending explicit or it can include DESC for descending order..
Answer: The default order for ORDER BY is ascending. How can
you make it descending order?
⚫ SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
FROM SALES
WHERE Name = 'Matt';. Answer: Command to use
AVG/SUM/MIN/MAX/COUNT aggregate functions?
⚫ o One is that the tables to be joined must be listed in the FROM
clause.
o Two is that the join attributes in the tables being joined must be
declared and matched to each other in the WHERE clause.. Answer:
There are two specifications to make in the SELECT statement to
make a join work.
⚫ SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM. Answer:
Example of JOIN CAUSE.
⚫ Dr. CODD. Answer: In 1970, Dr. _________ of IBM published in
Communications of the ACM a paper entitled "A Relational Model of
Data for Large Shared Data Banks." This paper marked the beginning
of the field of relational databases.
⚫ CREATE TABLE
, DROP TABLE. Answer: Commands to create and drop a table?
⚫ - When you create the column definition (known as a column
constraint).
- When you use the CONSTRAINT keyword (known as a table
constraint).. Answer: The CREATE TABLE command lets you define
constraints in two different places:
⚫ NOT
WHERE Location NOT IN ('WV', TN' 'CA');
WHERE Total NOT Between '1000', 2000';
WHERE Name NOT LIKE 'Ma%';. Answer: You can exclude rows
with other types of conditions by using the ______ operator.
⚫ USE
USE MainDatabase. Answer: The _____ command tells the database
system which database you're going to be using for the upcoming
commands.
⚫ SHOW
