1 | Page
WGU D427 - DATABASE MANAGEMENT
APPLICATIONS 2025 UPDATED ACTUAL EXAM
WITH CORRECT SOLUTIONS.
Schema - correct answer- The definition of how data in a
database will be organized.
- Create
- Read
- Update
- Delete - correct answer- The basis of interacting with
databases can be defined using the CRUD acronym. What
does CRUD stand for?
DATE: YYYY-MM-DD
DATETIME: YYYY-MM-DD HH:MM:SS - correct answer- What
is the DATE datatype syntax?
What is the DATETIME datatype syntax?
,2 | Page
It will have 3 numbers before the decimal and 2 after. - correct
answer- What does DECIMAL(3,2) indicate?
Stored Procedures - correct answer- a series of commands
stored on the database. This allows the reuse of long or
detailed queries instead of writing them for each use. It also
provides a safe way to deal with sensitive data, especially with
those unfamiliar with SQL syntax.
Data definition language (DDL) - correct answer- involves
instructing the DBMS software on what tables will be in the
database, what attributes will be in the tables, which attributes
will be indexed, and so forth.
data manipulation languages (DMLs) - correct answer- refers to
the four basic operations that can and must be performed on
data stored in any DBMS (or in any other data storage
arrangement, for that matter): data retrieval, data update,
insertion of new records, and deletion of existing records.
SELECT *
FROM CUSTOMER
WHERE CUSTNUMB BETWEEN 1 AND 2; - correct answer-
What would the SELECT statement look like if you use a
BETWEEN.
, 3 | Page
SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington'); -
correct answer- What would the SELECT statement look like if
you use a IN.
SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%'; - correct 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. - correct 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.
WGU D427 - DATABASE MANAGEMENT
APPLICATIONS 2025 UPDATED ACTUAL EXAM
WITH CORRECT SOLUTIONS.
Schema - correct answer- The definition of how data in a
database will be organized.
- Create
- Read
- Update
- Delete - correct answer- The basis of interacting with
databases can be defined using the CRUD acronym. What
does CRUD stand for?
DATE: YYYY-MM-DD
DATETIME: YYYY-MM-DD HH:MM:SS - correct answer- What
is the DATE datatype syntax?
What is the DATETIME datatype syntax?
,2 | Page
It will have 3 numbers before the decimal and 2 after. - correct
answer- What does DECIMAL(3,2) indicate?
Stored Procedures - correct answer- a series of commands
stored on the database. This allows the reuse of long or
detailed queries instead of writing them for each use. It also
provides a safe way to deal with sensitive data, especially with
those unfamiliar with SQL syntax.
Data definition language (DDL) - correct answer- involves
instructing the DBMS software on what tables will be in the
database, what attributes will be in the tables, which attributes
will be indexed, and so forth.
data manipulation languages (DMLs) - correct answer- refers to
the four basic operations that can and must be performed on
data stored in any DBMS (or in any other data storage
arrangement, for that matter): data retrieval, data update,
insertion of new records, and deletion of existing records.
SELECT *
FROM CUSTOMER
WHERE CUSTNUMB BETWEEN 1 AND 2; - correct answer-
What would the SELECT statement look like if you use a
BETWEEN.
, 3 | Page
SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington'); -
correct answer- What would the SELECT statement look like if
you use a IN.
SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%'; - correct 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. - correct 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.
