WGU C175 DATA MANAGEMENT - FOUNDATIONS - QUESTIONS WITH
VERIFIED ANSWERS
Correct 275
100
%
Incorrect 00
1 of 275
Term
Determining cardinality always precedes distinguishing independent
and dependent entities.
True or False?
Give this one a try later!
False- the phases are iterative
False- it is not part of MySQL at all and occasionally die out of
order.
False- they may depend on other d- Each keyword, SELECT and FROM,
non-key columns defines a single clause.
Don't know?
, 2 of 275
Term
Determine the maxima for the Entity-Has-Attribute relationship Entity
Passenger, attribute PassengerName.
a) many-many
b) one-many
c) many-one
d) one-one
Give this one a try later!
c- Each passenger has one d- each student can take many
name and each name can courses and each course can have
describe many passengers. many students.
d- each airport has at most one
c- each dependent entity must have
airport code and each airport code
at least one dependency.
describes at most one airport.
Don't know?
, 3 of 275
Term
Database administrators can optimize query performance by assigning
tables or parts of tables to specific nodes of a distributed database.
True or False?
Give this one a try later!
a b- INSERT, UPDATE, DELETE
False True
Don't know?
, 4 of 275
Term
All exams belong to a course. A course must exist before course
exams are created. When a course is deleted, course exams are also
deleted. Courses are always part of an academic department. We set
up a cede mic departments in the database before we add courses.
“Exam-BelongsTo-Course” is an example of __ _.
a) Independent entity
b) Master entity
c) Dependent entity
d) Dependent relationship
Give this one a try later!
d a
d- while the definition is 'c', third
b normal form must meet all previous
forms as well.
Don't know?
5 of 275
Term
Which SQL command will you use to create a new database
called"mydb"?
VERIFIED ANSWERS
Correct 275
100
%
Incorrect 00
1 of 275
Term
Determining cardinality always precedes distinguishing independent
and dependent entities.
True or False?
Give this one a try later!
False- the phases are iterative
False- it is not part of MySQL at all and occasionally die out of
order.
False- they may depend on other d- Each keyword, SELECT and FROM,
non-key columns defines a single clause.
Don't know?
, 2 of 275
Term
Determine the maxima for the Entity-Has-Attribute relationship Entity
Passenger, attribute PassengerName.
a) many-many
b) one-many
c) many-one
d) one-one
Give this one a try later!
c- Each passenger has one d- each student can take many
name and each name can courses and each course can have
describe many passengers. many students.
d- each airport has at most one
c- each dependent entity must have
airport code and each airport code
at least one dependency.
describes at most one airport.
Don't know?
, 3 of 275
Term
Database administrators can optimize query performance by assigning
tables or parts of tables to specific nodes of a distributed database.
True or False?
Give this one a try later!
a b- INSERT, UPDATE, DELETE
False True
Don't know?
, 4 of 275
Term
All exams belong to a course. A course must exist before course
exams are created. When a course is deleted, course exams are also
deleted. Courses are always part of an academic department. We set
up a cede mic departments in the database before we add courses.
“Exam-BelongsTo-Course” is an example of __ _.
a) Independent entity
b) Master entity
c) Dependent entity
d) Dependent relationship
Give this one a try later!
d a
d- while the definition is 'c', third
b normal form must meet all previous
forms as well.
Don't know?
5 of 275
Term
Which SQL command will you use to create a new database
called"mydb"?
