WGU D427 DATA MANAGEMENT
APPLICATIONS OA EXAM LATEST 2024
ACTUAL 150 QUESTIONS WITH
DETAILED ANSWERS /A+ GRADE
ASSURED
What are the two ways of
... [Show More] using the LIKE command? -
...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? - ...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? - ...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. - ...ANSWER...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.
Example of JOIN CAUSE. - ...ANSWER...SELECT
SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM
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. - ...ANSWER...Dr. CODD
Commands to create and drop a table? -
...ANSWER...CREATE TABLE
DROP TABLE
The CREATE TABLE command lets you define
constraints in two different places: - ...ANSWER...-
When you create the column definition (known as a
column constraint).
- When you use the CONSTRAINT keyword (known as
a table constraint).
You can exclude rows with other types of conditions
by using the ______ operator. - ...ANSWER...NOT
WHERE Location NOT IN ('WV', TN' 'CA');
WHERE Total NOT Between '1000', 2000';
WHERE Name NOT LIKE 'Ma%';
The _____ command tells the database system which
database you're going to be using for the upcoming
commands. - ...ANSWER...USE
USE MainDatabase
You can use the _______ statement to provide specified
information about a database. - ...ANSWER...SHOW
SHOW DATABASES - lists all databases in the
database system instance.
SHOW TABLES - lists all tables in the default
database.
SHOW COLUMNS FROM TableName - lists all columns
in the TableName table of the default database.
SHOW CREATE TABLE TableName - shows the
CREATE TABLE statement for the TableName table of
the default database.
The ALTAR Table adds, deletes, or modifies columns.
What is the syntax for each of these? -
...ANSWER...ALTAR TABLE TableName
Add ColumnName DataType
ALTAR TABLE TableName
DRIP ColumnName
ALTAR TABLE TableName
CHANGE CurrentColumnName New ColumnName
NewDataType
Some tables may contain thousands or millions o [Show Less]