WGU D427 DATA MANAGEMENT
APPLICATIONS 2026 COMPLETE QUESTIONS
AND SOLUTIONS GRADED A PLUS SQL
DATABASE DESIGN STUDY GUIDE
◉ - Create
- Read
- Update
- Delete.
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.
Answer: What is the DATE datatype syntax?
What is the DATETIME datatype syntax?
◉ It will have 3 numbers before the decimal and 2 after..
Answer: What does DECIMAL(3,2) indicate?
,◉ Stored Procedures.
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).
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).
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;.
Answer: What would the SELECT statement look like if you use a
BETWEEN.
, ◉ 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?
APPLICATIONS 2026 COMPLETE QUESTIONS
AND SOLUTIONS GRADED A PLUS SQL
DATABASE DESIGN STUDY GUIDE
◉ - Create
- Read
- Update
- Delete.
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.
Answer: What is the DATE datatype syntax?
What is the DATETIME datatype syntax?
◉ It will have 3 numbers before the decimal and 2 after..
Answer: What does DECIMAL(3,2) indicate?
,◉ Stored Procedures.
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).
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).
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;.
Answer: What would the SELECT statement look like if you use a
BETWEEN.
, ◉ 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?
