WGU D427 DATABASE MANAGEMENT APPLICATIONS EXAM QUESTIONS WITH
100% CORRECT ANSWERS | VERIFIED | 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 *
100% CORRECT ANSWERS | VERIFIED | 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 *
