WGU D427 DATABASE MANAGEMENT APPLICATIONS
EXAM PRE-ASSESSMENT AND OBJECTIVE
ASSESSMENT LATEST 2025 WITH ACTUAL QUESTIONS
AND CORRECT VERIFIED ANSWERS ALREADY GRADED
A+ 100% GUARANTEED PASS!
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.
Dr. CODD - CORRECT ANSWER-In 1970, Dr. _________ of IBM published in
Communications of the ACM a paper entitled "A Relational Model of Data for
, Large Shared Data Banks." This paper marked the beginning of the field of
relational databases.
CREATE TABLE
DROP TABLE - CORRECT ANSWER-Commands to create and drop a table?
- When you create the column definition (known as a column constraint).
- When you use the CONSTRAINT keyword (known as a table constraint). -
CORRECT ANSWER-The CREATE TABLE command lets you define constraints
in two different places:
NOT
WHERE Location NOT IN ('WV', TN' 'CA');
WHERE Total NOT Between '1000', 2000';
WHERE Name NOT LIKE 'Ma%'; - CORRECT ANSWER-You can exclude rows
with other types of conditions by using the ______ operator.
USE
USE MainDatabase - CORRECT ANSWER-The _____ command tells the
database system which database you're going to be using for the upcoming
commands.
SHOW
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Expertellen. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $21.99. You're not tied to anything after your purchase.
