WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM LATEST 2024 ACTUAL 150
QUESTIONS WITH DETAILED ANSWERS /A+ GRADE ASSURED
The definition of how data
in
... [Show More] a database will be organized.
The basis of interacting with databases can
be defined using the
CRUD acronym. What
does CRUD stand for?
What is the DATE datatype
syntax?
What is the DATETIME
datatype syntax?
What does DECIMAL(3,2)
indicate?
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
Schema
- Create
- Read
- Update
- Delete
DATE:YYYY-MM-DD
DATETIME: YYYY-MM-DD
HH:MM:SS
It will have 3 numbers before the decimal and 2 after.
Stored Procedures
2 / 30
WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM LATEST 2024 ACTUAL 150
QUESTIONS WITH DETAILED ANSWERS /A+ GRADE ASSURED
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.
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.
What would the SELECT
statement look like if you
use a BETWEEN.
Data definition language
(DDL)
data manipulation languages (DMLs)
SELECT *
FROM CUSTOMER
WHERE CUSTNUMB BETWEEN 1 AND 2;
with those unfamiliar with
SQL syntax.
3 / 30
WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM LATEST 2024 ACTUAL 150
QUESTIONS WITH DETAILED ANSWERS /A+ GRADE ASSURED
What would the SELECT
statement look like if you
use a IN.
What would the SELECT
statement look like if you
use a LIKE.
What are the two ways of
using the LIKE command?
The default order for ORDER BY is ascending.
SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');
SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE
'W%';
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 clause can include the
term ASC at the end to
make ascending explicit or
4 / 30
WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM LATEST 2024 ACTUAL 150
QUESTIONS WITH DETAILED ANSWERS /A+ GRADE ASSURED
SELECT
Command to use AVG/SUM/MIN/MAX/COUNT
AVG/SUM/MIN/MAX/COUNuTmn_Name)
aggregate functions?
There are two specifications to make in the SELECT statement to make a
join work.
Example of JOIN CAUSE.
In 1970, Dr. of
IBM published in CommuFROM SALES
WHERE Name = 'Matt';
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.
SELECT SPNAME
FROM SALESPERSON,
CUSTOMER
WHERE
SALESPERSON.SPNUM=CUSTOMER.SPNUM
How can you make it de- it can include DESC for descending order? scending order.
5 / 30
WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM LATEST 2024 ACTUAL 150
QUESTIONS WITH DETAILED ANSWERS /A+ GRADE ASSURED
nications 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.
Commands to create and
drop a table?
The CREATETABLE command lets you define constraints in two different
places:
You can exclude rows with
other types of conditions
by using the operator.
Dr. CODD
CREATE TABLE [Show Less]