WGU D427 Database Management Applications
Exam 113 Questions with Verified Answers
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 DATE datatype syntax?
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.
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. - CORRECT ANSWER SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM
Exam 113 Questions with Verified Answers
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 DATE datatype syntax?
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.
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. - CORRECT ANSWER SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM
