WGU D427 DATA MANAGEMENT
APPLICATIONS ACTUAL TEST PAPER
COMPLETE QUESTIONS AND SOLUTIONS
TESTED ANSWERS
◉ 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?
◉ SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
FROM SALES
WHERE Name = 'Matt';
Answer: Command to use AVG/SUM/MIN/MAX/COUNT aggregate
functions?
APPLICATIONS ACTUAL TEST PAPER
COMPLETE QUESTIONS AND SOLUTIONS
TESTED ANSWERS
◉ 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?
◉ SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
FROM SALES
WHERE Name = 'Matt';
Answer: Command to use AVG/SUM/MIN/MAX/COUNT aggregate
functions?
