WGU D427 Database Management Applications
EXAM Questions & Answers, Well Elaborated |
Already Verified Test |100% Verified solutions |
Latest!!
Save
Terms in this set (64)
Schema The definition of how data in a database will be
organized.
- Create The basis of interacting with databases can be
- Read defined using the CRUD acronym. What does
- Update CRUD stand for?
- Delete
DATE: YYYY-MM-DD What is the DATE datatype syntax?
DATETIME: YYYY-MM-DD What is the DATETIME datatype syntax?
HH:MM:SS
It will have 3 numbers before the What does DECIMAL(3,2) indicate?
decimal and 2 after.
Stored Procedures 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) 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 refers to the four basic operations that can and
(DMLs) 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 * What would the SELECT statement look like if you
FROM CUSTOMER use a BETWEEN.
WHERE CUSTNUMB BETWEEN 1
AND 2;
SELECT * What would the SELECT statement look like if you
FROM CUSTOMER use a IN.
WHERE HQCITY IN ('Atlanta',
'Chicago', 'Washington');
SELECT * What would the SELECT statement look like if you
FROM CUSTOMER use a LIKE.
WHERE HQCITY LIKE 'W%';
A% - The "%" means that any string What are the two ways of using the LIKE
of characters can follow afterwards. command?
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.
EXAM Questions & Answers, Well Elaborated |
Already Verified Test |100% Verified solutions |
Latest!!
Save
Terms in this set (64)
Schema The definition of how data in a database will be
organized.
- Create The basis of interacting with databases can be
- Read defined using the CRUD acronym. What does
- Update CRUD stand for?
- Delete
DATE: YYYY-MM-DD What is the DATE datatype syntax?
DATETIME: YYYY-MM-DD What is the DATETIME datatype syntax?
HH:MM:SS
It will have 3 numbers before the What does DECIMAL(3,2) indicate?
decimal and 2 after.
Stored Procedures 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) 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 refers to the four basic operations that can and
(DMLs) 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 * What would the SELECT statement look like if you
FROM CUSTOMER use a BETWEEN.
WHERE CUSTNUMB BETWEEN 1
AND 2;
SELECT * What would the SELECT statement look like if you
FROM CUSTOMER use a IN.
WHERE HQCITY IN ('Atlanta',
'Chicago', 'Washington');
SELECT * What would the SELECT statement look like if you
FROM CUSTOMER use a LIKE.
WHERE HQCITY LIKE 'W%';
A% - The "%" means that any string What are the two ways of using the LIKE
of characters can follow afterwards. command?
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.
