WGU D427 DATABASE MANAGEMENT APPLICATIONS
EXAM PRE-ASSESSMENT AND OBJECTIVE ASSESMENT |
ACCURATE CURRENTLY TESTING EXAMS | ACCURATE
AND VERIFIED FOR GUARANTEED PASS | LATEST UPDATE
The definition of how data in a database will be organized. - (ANSWER)Schema
The basis of interacting with databases can be defined using the CRUD acronym.
What does CRUD stand for? - (ANSWER)- Create
- Read
- Update
- Delete
What is the DATE datatype syntax?
What is the DATETIME datatype syntax? - (ANSWER)DATE: YYYY-MM-DD
DATETIME: YYYY-MM-DD HH:MM:SS
What does DECIMAL(3,2) indicate? - (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. -
(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. - (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. - (ANSWER)data manipulation languages (DMLs)
What would the SELECT statement look like if you use a BETWEEN. -
(ANSWER)SELECT *
FROM CUSTOMER
WHERE CUSTNUMB BETWEEN 1 AND 2;
What would the SELECT statement look like if you use a IN. - (ANSWER)SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');
What would the SELECT statement look like if you use a LIKE. - (ANSWER)SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%';
, What are the two ways of 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
EXAM PRE-ASSESSMENT AND OBJECTIVE ASSESMENT |
ACCURATE CURRENTLY TESTING EXAMS | ACCURATE
AND VERIFIED FOR GUARANTEED PASS | LATEST UPDATE
The definition of how data in a database will be organized. - (ANSWER)Schema
The basis of interacting with databases can be defined using the CRUD acronym.
What does CRUD stand for? - (ANSWER)- Create
- Read
- Update
- Delete
What is the DATE datatype syntax?
What is the DATETIME datatype syntax? - (ANSWER)DATE: YYYY-MM-DD
DATETIME: YYYY-MM-DD HH:MM:SS
What does DECIMAL(3,2) indicate? - (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. -
(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. - (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. - (ANSWER)data manipulation languages (DMLs)
What would the SELECT statement look like if you use a BETWEEN. -
(ANSWER)SELECT *
FROM CUSTOMER
WHERE CUSTNUMB BETWEEN 1 AND 2;
What would the SELECT statement look like if you use a IN. - (ANSWER)SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington');
What would the SELECT statement look like if you use a LIKE. - (ANSWER)SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%';
, What are the two ways of 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
