WGU D427 Database Management Applications Exam Questions With 100% Correct Answers | Verified | Latest Update

WGU D427 Database Management

Applications Exam Questions With 100%

Correct Answers | Verified | Latest

Update

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).