D427 - Database Management Applications
UPDATED ACTUAL Exam Questions and
CORRECT Answers
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?
UPDATED ACTUAL Exam Questions and
CORRECT Answers
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?
