WGU D427 DATABASE MANAGEMENT
APPLICATIONS COMPREHENSIVE
TEST SCRIPT 2026 QUESTIONS WITH
SOLUTIONS 100% CORRECT.
✔ 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
SHOW DATABASES - lists all databases in the database system
instance.
SHOW TABLES - lists all tables in the default database.
SHOW COLUMNS FROM TableName - lists all columns in the
TableName table of the default database.
SHOW CREATE TABLE TableName - shows the CREATE TABLE
statement for the TableName table of the default database.. Answer:
You can use the _______ statement to provide specified information
about a database.
✔ ALTAR TABLE TableName
Add ColumnName DataType
ALTAR TABLE TableName
DRIP ColumnName
ALTAR TABLE TableName
APPLICATIONS COMPREHENSIVE
TEST SCRIPT 2026 QUESTIONS WITH
SOLUTIONS 100% CORRECT.
✔ 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
SHOW DATABASES - lists all databases in the database system
instance.
SHOW TABLES - lists all tables in the default database.
SHOW COLUMNS FROM TableName - lists all columns in the
TableName table of the default database.
SHOW CREATE TABLE TableName - shows the CREATE TABLE
statement for the TableName table of the default database.. Answer:
You can use the _______ statement to provide specified information
about a database.
✔ ALTAR TABLE TableName
Add ColumnName DataType
ALTAR TABLE TableName
DRIP ColumnName
ALTAR TABLE TableName
