D427 WGU DATABASE MANAGEMENT APPLICATIONS
COMPREHENSIVE QUESTIONS WITH VERIFIED ANSWERS
NEWEST UPDATE
The definition of how data in a database will be organized. - (correct answer) Schema
The basis of interacting with databases can be defined using the CRUD acronym. What does CRUD stand
for? - (correct answer)
- Create
- Read
- Update
- Delete
What is the DATETIME datatype syntax? - (correct answer) DATE: YYYY-MM-DD
DATETIME: YYYY-MM-DD HH:MM:SS
What does DECIMAL(3,2) indicate? - (correct answer) It will have 3 numbers before the decimal and 2
after.
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. - (correct answer) Stored Procedures
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. - (correct answer) Data definition language
(DDL)
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. - (correct answer) data manipulation languages (DMLs)
What would the SELECT statement look like if you use a BETWEEN. - (correct answer)
SELECT *
FROM CUSTOMER
, WHERE CUSTNUMB BETWEEN 1 AND 2;
What would the SELECT statement look like if you use a IN. - (correct answer)
SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');
What would the SELECT statement look like if you use a LIKE. - (correct answer)
SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%';
What are the two ways of using the LIKE command? - (correct answer) 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.
The default order for ORDER BY is ascending. How can you make it descending order? - (correct
answer) The clause can include the term ASC at the end to make ascending explicit or it can include
DESC for descending order.
Command to use AVG/SUM/MIN/MAX/COUNT aggregate functions? - (correct answer)
SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
FROM SALES
WHERE Name = 'Matt';
There are two specifications to make in the SELECT statement to make a join work. - (correct answer)
o One is that the tables to be joined must be listed in the FROM clause.
COMPREHENSIVE QUESTIONS WITH VERIFIED ANSWERS
NEWEST UPDATE
The definition of how data in a database will be organized. - (correct answer) Schema
The basis of interacting with databases can be defined using the CRUD acronym. What does CRUD stand
for? - (correct answer)
- Create
- Read
- Update
- Delete
What is the DATETIME datatype syntax? - (correct answer) DATE: YYYY-MM-DD
DATETIME: YYYY-MM-DD HH:MM:SS
What does DECIMAL(3,2) indicate? - (correct answer) It will have 3 numbers before the decimal and 2
after.
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. - (correct answer) Stored Procedures
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. - (correct answer) Data definition language
(DDL)
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. - (correct answer) data manipulation languages (DMLs)
What would the SELECT statement look like if you use a BETWEEN. - (correct answer)
SELECT *
FROM CUSTOMER
, WHERE CUSTNUMB BETWEEN 1 AND 2;
What would the SELECT statement look like if you use a IN. - (correct answer)
SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');
What would the SELECT statement look like if you use a LIKE. - (correct answer)
SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%';
What are the two ways of using the LIKE command? - (correct answer) 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.
The default order for ORDER BY is ascending. How can you make it descending order? - (correct
answer) The clause can include the term ASC at the end to make ascending explicit or it can include
DESC for descending order.
Command to use AVG/SUM/MIN/MAX/COUNT aggregate functions? - (correct answer)
SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
FROM SALES
WHERE Name = 'Matt';
There are two specifications to make in the SELECT statement to make a join work. - (correct answer)
o One is that the tables to be joined must be listed in the FROM clause.
