WGU C175 Pre-Assessment 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 |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
In |which |two |ways |does |a |database |management |system |environment |increase |effectiveness |
in |working |with |data? |- |CORRECT |ANSWER✔✔-- |It |enables |data |sharing, |
- |It |permits |storage |of |vast |volumes |of |data.
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
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 |three |kinds |of |rules |for |referential |integrity |are |provided |by |modern |relational |database
|management |systems? |- |CORRECT |ANSWER✔✔-Insert, |Delete, |Update
What |is |an |important |aspect |of |"referential |integrity"? |- |CORRECT |ANSWER✔✔-Reference |to |
data |in |one |relation |is |based |on |values |in |another |relation.
Sales |data, |detailing |the |customer |names, |products |sold, |and |salespersons, |is |kept |in |a |
database. |
Which |kind |of |data |in |this |database |would |qualify |as |intersection |data |related |to |both |the |
product |and |salesperson |entities? |- |CORRECT |ANSWER✔✔-Customer |names
What |is |an |attribute |or |group |of |attributes |that |uniquely |identify |a |tuple |in |a |relation? |- |
CORRECT |ANSWER✔✔-Primary |key
What |is |necessary |for |a |primary |key |in |one |relation |of |a |database |to |match |with |its |
corresponding |foreign |key |in |another |relation |of |the |same |database? |- |CORRECT |ANSWER✔✔-
A |domain |of |values
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 |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
In |which |two |ways |does |a |database |management |system |environment |increase |effectiveness |
in |working |with |data? |- |CORRECT |ANSWER✔✔-- |It |enables |data |sharing, |
- |It |permits |storage |of |vast |volumes |of |data.
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
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 |three |kinds |of |rules |for |referential |integrity |are |provided |by |modern |relational |database
|management |systems? |- |CORRECT |ANSWER✔✔-Insert, |Delete, |Update
What |is |an |important |aspect |of |"referential |integrity"? |- |CORRECT |ANSWER✔✔-Reference |to |
data |in |one |relation |is |based |on |values |in |another |relation.
Sales |data, |detailing |the |customer |names, |products |sold, |and |salespersons, |is |kept |in |a |
database. |
Which |kind |of |data |in |this |database |would |qualify |as |intersection |data |related |to |both |the |
product |and |salesperson |entities? |- |CORRECT |ANSWER✔✔-Customer |names
What |is |an |attribute |or |group |of |attributes |that |uniquely |identify |a |tuple |in |a |relation? |- |
CORRECT |ANSWER✔✔-Primary |key
What |is |necessary |for |a |primary |key |in |one |relation |of |a |database |to |match |with |its |
corresponding |foreign |key |in |another |relation |of |the |same |database? |- |CORRECT |ANSWER✔✔-
A |domain |of |values
