D427
D427 / D 427 Final Exam (Latest Update 2025
/ 2026) Data Management – Applications |
Questions and Answers | Grade A | 100%
Correct (Verified Answers). WGU
1. Stored Procedures: 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.
2. Data definition language (DDL): 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.
3. data manipulation languages (DMLs): 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.
4. SELECT *
, D427
FROM CUSTOMER
WHERE CUSTNUMB BETWEEN 1 AND 2;: What would the SELECT
statement look like if you use a BETWEEN.
5. SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');: What would
the SELECT statement look like if you use a IN.
6. SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%';: What would the SELECT statement look
like if you use a LIKE.
7. 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.: What are the
two ways of using the LIKE command?
, D427
8. The clause can include the term ASC at the end to make ascending
explicit or it can include DESC for descending order.: The default
order for ORDER BY is ascending. How can you make it descending
order?
9. SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
FROM SALES
WHERE Name = 'Matt';: Command to use AVG/SUM/MIN/MAX/COUNT
aggregate functions?
10. 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.: There
are two specifications to make in the SELECT statement to make a join
work.
11. SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM: Example of
JOIN CAUSE.
D427 / D 427 Final Exam (Latest Update 2025
/ 2026) Data Management – Applications |
Questions and Answers | Grade A | 100%
Correct (Verified Answers). WGU
1. Stored Procedures: 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.
2. Data definition language (DDL): 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.
3. data manipulation languages (DMLs): 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.
4. SELECT *
, D427
FROM CUSTOMER
WHERE CUSTNUMB BETWEEN 1 AND 2;: What would the SELECT
statement look like if you use a BETWEEN.
5. SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');: What would
the SELECT statement look like if you use a IN.
6. SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%';: What would the SELECT statement look
like if you use a LIKE.
7. 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.: What are the
two ways of using the LIKE command?
, D427
8. The clause can include the term ASC at the end to make ascending
explicit or it can include DESC for descending order.: The default
order for ORDER BY is ascending. How can you make it descending
order?
9. SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
FROM SALES
WHERE Name = 'Matt';: Command to use AVG/SUM/MIN/MAX/COUNT
aggregate functions?
10. 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.: There
are two specifications to make in the SELECT statement to make a join
work.
11. SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM: Example of
JOIN CAUSE.
