WGUC175 - Data Management Foundations|
OA| Objective Assessment | Actual Questions
and Answers Latest Updated
(Graded A+)
Correct 115
Incorrect 0
Your answers
What is necessary for a primary key in one relation of a database to match with its
What uniquely identifies each entity in a collection of entities but is not the primary
, What is the term for the value of one particular attribute associated with a specific
single value of another attribute?
What is a term for a set of columns in a table that can uniquely identify any
record in that table without referring to other data?
Don't know?
2 of 115
Term
How is the cardinality of the customers misrepresented?
Give this one a try later!
There are many
customers, but the The tables are completely
cardinality indicates free of data redundancy.
one customer.
A minimum of zero
Unary one-to-many
customers
Don't know?
, 3 of 115
Term
Refer to the given SQL statement to answer the following question:
SELECT *
FROM PRODUCT;
What would this SQL statement accomplish?
Give this one a try later!
List all entries in the PRODUCT
WHERE COMMPERCT=15;
table.
Insert
Replace COMMPERCT, YEARHIRE
Delete
with an asterisk
Update
Don't know?
4 of 115
Term
What is the uniquely identifiable element about which data can be
categorized in an entity-relationship diagram?
Give this one a try later!
, Many-to-many A domain of values
Entity types Composite
Don't know?
5 of 115
Definition
Prediction classifies objects according to an expected future behavior.
Give this one a try later!
ADDED IN - We can describe a link ADDED IN - Which command is used
by observing that ____. to select partial table contents?
How is the cardinality of the How is prediction distinguished
customers misrepresented? from estimation in data mining?
Don't know?
OA| Objective Assessment | Actual Questions
and Answers Latest Updated
(Graded A+)
Correct 115
Incorrect 0
Your answers
What is necessary for a primary key in one relation of a database to match with its
What uniquely identifies each entity in a collection of entities but is not the primary
, What is the term for the value of one particular attribute associated with a specific
single value of another attribute?
What is a term for a set of columns in a table that can uniquely identify any
record in that table without referring to other data?
Don't know?
2 of 115
Term
How is the cardinality of the customers misrepresented?
Give this one a try later!
There are many
customers, but the The tables are completely
cardinality indicates free of data redundancy.
one customer.
A minimum of zero
Unary one-to-many
customers
Don't know?
, 3 of 115
Term
Refer to the given SQL statement to answer the following question:
SELECT *
FROM PRODUCT;
What would this SQL statement accomplish?
Give this one a try later!
List all entries in the PRODUCT
WHERE COMMPERCT=15;
table.
Insert
Replace COMMPERCT, YEARHIRE
Delete
with an asterisk
Update
Don't know?
4 of 115
Term
What is the uniquely identifiable element about which data can be
categorized in an entity-relationship diagram?
Give this one a try later!
, Many-to-many A domain of values
Entity types Composite
Don't know?
5 of 115
Definition
Prediction classifies objects according to an expected future behavior.
Give this one a try later!
ADDED IN - We can describe a link ADDED IN - Which command is used
by observing that ____. to select partial table contents?
How is the cardinality of the How is prediction distinguished
customers misrepresented? from estimation in data mining?
Don't know?
