DATABASE MANAGEMENT APPLICATIONS WGU D427 QUESTIONS AND
CORRECT DETAILED ANSWERS (VERIFIED ANSWERS)|ALREADY
GRADED A+ 2024
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?
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.
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. - CORRECT 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'; - CORRECT 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. - CORRECT 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 - CORRECT ANSWER✔✔Example of JOIN CAUSE.
CORRECT DETAILED ANSWERS (VERIFIED ANSWERS)|ALREADY
GRADED A+ 2024
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?
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.
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. - CORRECT 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'; - CORRECT 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. - CORRECT 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 - CORRECT ANSWER✔✔Example of JOIN CAUSE.
