C175 - Data Management Foundations PA
Exam Questions With Correct Answers
What |is |a |broad |definition |of |data? |- |CORRECT |ANSWER✔✔-*Raw |facts* |that |are |captured |on |
printed |or |digital |media
What |are |data? |- |CORRECT |ANSWER✔✔-Facts |that |are |collected |and |stored |in |a |database |
system
What |is |a |determining |characteristic |of |unstructured |data? |- |CORRECT |ANSWER✔✔-It |does |
not |follow |a |data |model.
Which |item |represents |unstructured |data? |- |CORRECT |ANSWER✔✔-Training |Video |Content
Which |is |true |about |flat |files? |- |CORRECT |ANSWER✔✔-They |contain |no |internal |hierarchical |
organization.
Which |technology |has |no |internal |hierarchy? |- |CORRECT |ANSWER✔✔-Flat |files
How |were |data |retrieved |before |database |management |systems? |- |CORRECT |ANSWER✔✔-
Sequentially |from |simple |files
What |is |the |*uniquely |identifiable |element* |about |which |data |can |be |categorized |in |an |entity-
relationship |diagram? |- |CORRECT |ANSWER✔✔-Entity |types
, Which |classification |is |correct |for |the |box |marked |"Quantity" |in |the |given |entity-relationship |
diagram? |- |CORRECT |ANSWER✔✔-Intersection |data
Which |data |classification |is |an |entity? |- |CORRECT |ANSWER✔✔-event
What |is |the |entity-relationship |diagram |about |a |car |rental |agency |showing? |- |CORRECT |
ANSWER✔✔-One |manufacturer |created |at |least |one |of |the |agency's |cars.
A |salesperson |is |authorized |to |sell |12 |products; |a |product |can |be |sold |by |10 |salespersons. |
Which |kind |of |binary |relationship |is |described |in |this |example? |- |CORRECT |ANSWER✔✔-Many-
to-many
Which |relationship |does |the |cardinality |in |the |diagram |represent? |- |CORRECT |ANSWER✔✔-
Many |customers |to |many |products
How |is |the |cardinality |of |the |customers |misrepresented? |- |CORRECT |ANSWER✔✔-There |are |
many |customers, |but |the |cardinality |indicates |one |customer.
What |is |the |correct |way |to |read |the |modality |on |the |right |side |of |the |association? |- |CORRECT |
ANSWER✔✔-A |minimum |of |zero |customers
What |is |the |modality |of |the |product? |- |CORRECT |ANSWER✔✔-At |least |one
Which |kind |of |relationship |does |this |diagram |depict? |- |CORRECT |ANSWER✔✔-Unary |one-to-
one
Which |kind |of |relationship |does |this |diagram |depict? |- |CORRECT |ANSWER✔✔-Unary |one-to-
many
Exam Questions With Correct Answers
What |is |a |broad |definition |of |data? |- |CORRECT |ANSWER✔✔-*Raw |facts* |that |are |captured |on |
printed |or |digital |media
What |are |data? |- |CORRECT |ANSWER✔✔-Facts |that |are |collected |and |stored |in |a |database |
system
What |is |a |determining |characteristic |of |unstructured |data? |- |CORRECT |ANSWER✔✔-It |does |
not |follow |a |data |model.
Which |item |represents |unstructured |data? |- |CORRECT |ANSWER✔✔-Training |Video |Content
Which |is |true |about |flat |files? |- |CORRECT |ANSWER✔✔-They |contain |no |internal |hierarchical |
organization.
Which |technology |has |no |internal |hierarchy? |- |CORRECT |ANSWER✔✔-Flat |files
How |were |data |retrieved |before |database |management |systems? |- |CORRECT |ANSWER✔✔-
Sequentially |from |simple |files
What |is |the |*uniquely |identifiable |element* |about |which |data |can |be |categorized |in |an |entity-
relationship |diagram? |- |CORRECT |ANSWER✔✔-Entity |types
, Which |classification |is |correct |for |the |box |marked |"Quantity" |in |the |given |entity-relationship |
diagram? |- |CORRECT |ANSWER✔✔-Intersection |data
Which |data |classification |is |an |entity? |- |CORRECT |ANSWER✔✔-event
What |is |the |entity-relationship |diagram |about |a |car |rental |agency |showing? |- |CORRECT |
ANSWER✔✔-One |manufacturer |created |at |least |one |of |the |agency's |cars.
A |salesperson |is |authorized |to |sell |12 |products; |a |product |can |be |sold |by |10 |salespersons. |
Which |kind |of |binary |relationship |is |described |in |this |example? |- |CORRECT |ANSWER✔✔-Many-
to-many
Which |relationship |does |the |cardinality |in |the |diagram |represent? |- |CORRECT |ANSWER✔✔-
Many |customers |to |many |products
How |is |the |cardinality |of |the |customers |misrepresented? |- |CORRECT |ANSWER✔✔-There |are |
many |customers, |but |the |cardinality |indicates |one |customer.
What |is |the |correct |way |to |read |the |modality |on |the |right |side |of |the |association? |- |CORRECT |
ANSWER✔✔-A |minimum |of |zero |customers
What |is |the |modality |of |the |product? |- |CORRECT |ANSWER✔✔-At |least |one
Which |kind |of |relationship |does |this |diagram |depict? |- |CORRECT |ANSWER✔✔-Unary |one-to-
one
Which |kind |of |relationship |does |this |diagram |depict? |- |CORRECT |ANSWER✔✔-Unary |one-to-
many
