WGU D426 Data Management Foundations | PA |
Pre- Assessment| Actual Questions and Answers
Latest Updated (Graded A+)
Correct 69
Incorrect 0
D426 Data Management Foundations
Term
A table that has all key attributes defined, has no repeating groups, and
all its attributes are dependent on the primary key, is said to be in
2nf
, 1NF 3nf
Don't know?
2 of 69
Term
The SQL command that lets you insert data into a table, one row at a
time, is ____.
Give this one a try later!
INSERT UPDATE
CREATE DELETE
Don't know?
3 of 69
Term
Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME,
EMP_NAME, PROJ_START, HOURS), which of the following is a partial
dependency?
,Give this one a try later!
Proj_num, emp_num --> proj_name Proj_name --> Hours
PROJ_NUM --> PROJ_NAME Proj_num, emp_num --> hours
Don't know?
4 of 69
Term
What is the E-R Diagram about an online pet food vendor showing?
Give this one a try later!
One Invoice Line must include a
One Invoice Line must include at
minimum of one and a maximum
least two Items.
of one Item.
One Invoice Line must include One Invoice Line can include multiple
exactly two Items. Items.
Don't know?
5 of 69
, Term
Database models were developed to?
Give this one a try later!
Model real-world events or
Optimize database performance
conditions
Standardize data storage formats Organize data for faster retrieval
Don't know?
6 of 69
Term
A primary key?
Give this one a try later!
Must be uppercase letters and
Must be numeric
cannot contain numbers
Must be lowercase letters and cannot
Must be unique
contain numbers
Don't know?
Pre- Assessment| Actual Questions and Answers
Latest Updated (Graded A+)
Correct 69
Incorrect 0
D426 Data Management Foundations
Term
A table that has all key attributes defined, has no repeating groups, and
all its attributes are dependent on the primary key, is said to be in
2nf
, 1NF 3nf
Don't know?
2 of 69
Term
The SQL command that lets you insert data into a table, one row at a
time, is ____.
Give this one a try later!
INSERT UPDATE
CREATE DELETE
Don't know?
3 of 69
Term
Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME,
EMP_NAME, PROJ_START, HOURS), which of the following is a partial
dependency?
,Give this one a try later!
Proj_num, emp_num --> proj_name Proj_name --> Hours
PROJ_NUM --> PROJ_NAME Proj_num, emp_num --> hours
Don't know?
4 of 69
Term
What is the E-R Diagram about an online pet food vendor showing?
Give this one a try later!
One Invoice Line must include a
One Invoice Line must include at
minimum of one and a maximum
least two Items.
of one Item.
One Invoice Line must include One Invoice Line can include multiple
exactly two Items. Items.
Don't know?
5 of 69
, Term
Database models were developed to?
Give this one a try later!
Model real-world events or
Optimize database performance
conditions
Standardize data storage formats Organize data for faster retrieval
Don't know?
6 of 69
Term
A primary key?
Give this one a try later!
Must be uppercase letters and
Must be numeric
cannot contain numbers
Must be lowercase letters and cannot
Must be unique
contain numbers
Don't know?
