BTE 210 Exam 2/exam study guide/questions and answers/verified A+

BTE 210 Exam 2/exam study guide/quest
[]l[ []l[ []l[ []l[ []l[




ions and answers/verified A+
[]l[ []l[ []l[




Data[]l[increases[]l[______[]l[with[]l[time?[]l[-[]l[correct[]l[answers-exponentially

what[]l[is[]l[Data[]l[Degradation?[]l[-[]l[correct[]l[answers-
Issues[]l[that[]l[happen[]l[with[]l[the[]l[quality[]l[of[]l[data.[]l[Is[]l[the[]l[data[]l[correct?[]l[



customers[]l[move[]l[to[]l[new[]l[addresses,[]l[change[]l[their[]l[names

what[]l[is[]l[data[]l[rot?[]l[-[]l[correct[]l[answers-
worthless[]l[data.[]l[Data[]l[that[]l[no[]l[longer[]l[is[]l[useful[]l[or[]l[exists.[]l[Maybe[]l[a[]l[flashdrive[]l[went[]l[through[]l[the[]l[
washing[]l[machine



physical[]l[problems[]l[with[]l[storage[]l[media[]l[and[]l[thus[]l[make[]l[it[]l[difficult[]l[to[]l[access

what[]l[are[]l[the[]l[3[]l[sources[]l[of[]l[data?[]l[-[]l[correct[]l[answers-1)[]l[internal[]l[data[]l[sources

2)[]l[personal[]l[data[]l[sources

3)[]l[external[]l[data[]l[sources

what[]l[are[]l[Internal[]l[Data[]l[Sources?[]l[-[]l[correct[]l[answers-corporate[]l[databases[]l[and[]l[company[]l[documents

what[]l[are[]l[personal[]l[data[]l[sources?[]l[-[]l[correct[]l[answers-personal[]l[thoughts,[]l[opinions,[]l[experiences



Professor[]l[perez[]l[worked[]l[in[]l[sales[]l[and[]l[she[]l[recorded[]l[info[]l[about[]l[all[]l[her[]l[clients,[]l[like[]l[what[]l[drink[]l[th
ey[]l[like.[]l[Only[]l[she[]l[has[]l[this[]l[information

what[]l[are[]l[external[]l[data[]l[sources?[]l[-[]l[correct[]l[answers-
commercial[]l[databases,[]l[government[]l[reports,[]l[and[]l[corporate[]l[web[]l[sites

what[]l[is[]l[data[]l[governance?[]l[-[]l[correct[]l[answers-
managing[]l[data[]l[information[]l[across[]l[an[]l[entire[]l[organization

what[]l[is[]l[master[]l[data?[]l[-[]l[correct[]l[answers-
core[]l[data[]l[(e.g.,[]l[customer,[]l[product,[]l[employee,[]l[vendor,[]l[geographic[]l[location,[]l[etc.)[]l[that[]l[spans[]l[the[]l[
entire[]l[enterprise[]l[information[]l[systems

what[]l[are[]l[5[]l[components[]l[of[]l[high[]l[quality[]l[data?[]l[-[]l[correct[]l[answers-Accurate
[]l[

,complete
[]l[



timely
[]l[



accessible[]l[(you[]l[need[]l[to[]l[be[]l[able[]l[to[]l[access[]l[data[]l[anywhere,[]l[anytime,[]l[at[]l[any[]l[moment)



relevant[]l[(is[]l[it[]l[relevant[]l[at[]l[the[]l[time[]l[of[]l[the[]l[report)



these[]l[characteristics[]l[make[]l[data[]l[valuable

what[]l[would[]l[Umiamis[]l[master[]l[data[]l[be?[]l[-[]l[correct[]l[answers-
address,[]l[birthday,[]l[c[]l[number,[]l[social[]l[security[]l[number,[]l[email



Stuff[]l[like[]l[which[]l[club[]l[you[]l[were[]l[a[]l[part[]l[of[]l[freshman[]l[year[]l[wouldn't[]l[be[]l[master[]l[data

what[]l[is[]l[master[]l[data[]l[management?[]l[-[]l[correct[]l[answers-
provides[]l[the[]l[ability[]l[to[]l[store,[]l[maintain,[]l[and[]l[manage[]l[a[]l[consistent,[]l[accurate,[]l[and[]l[timely[]l[version[]l[o
f[]l[the[]l[company's[]l[master[]l[data



a[]l[process[]l[that[]l[spans[]l[all[]l[organizational[]l[business[]l[processes

databases[]l[minimize[]l[three[]l[main[]l[problems.[]l[what[]l[are[]l[they?[]l[-[]l[correct[]l[answers-1)[]l[data[]l[redundancy

2)[]l[data[]l[isolation

3)[]l[data[]l[inconsistency

what[]l[is[]l[data[]l[redundancy?[]l[-[]l[correct[]l[answers-The[]l[same[]l[data[]l[are[]l[stored[]l[in[]l[many[]l[places

what[]l[is[]l[data[]l[isolation?[]l[-[]l[correct[]l[answers-
Applications[]l[cannot[]l[access[]l[data[]l[associated[]l[with[]l[other[]l[applications



The[]l[opposite[]l[of[]l[data[]l[redundancy

what[]l[is[]l[data[]l[inconsistency?[]l[-[]l[correct[]l[answers-Various[]l[copies[]l[of[]l[the[]l[data[]l[do[]l[not[]l[agree

databases[]l[maximize[]l[three[]l[main[]l[things.[]l[What[]l[are[]l[they?[]l[-[]l[correct[]l[answers-1)[]l[data[]l[security

2)[]l[data[]l[integrity

3)[]l[data[]l[independence

what[]l[is[]l[data[]l[security?[]l[-[]l[correct[]l[answers-Keeping[]l[the[]l[organization's[]l[data[]l[safe[]l[from[]l[theft

, what[]l[is[]l[data[]l[integrity?[]l[-[]l[correct[]l[answers-data[]l[must[]l[meet[]l[organizational[]l[constraints



Example:[]l[social[]l[security[]l[number[]l[can[]l[only[]l[have[]l[numbers

what[]l[is[]l[data[]l[independence?[]l[-[]l[correct[]l[answers-
Applications[]l[and[]l[data[]l[are[]l[independent[]l[of[]l[one[]l[another

Each[]l[individual[]l[column[]l[in[]l[a[]l[database[]l[is[]l[called[]l[an?[]l[-[]l[correct[]l[answers-attribute



(column[]l[for[]l[student[]l[last[]l[name)

Each[]l[row[]l[for[]l[each[]l[student[]l[is[]l[called[]l[an?[]l[-[]l[correct[]l[answers-instance[]l[(or[]l[record)[]l[



last[]l[name,[]l[first[]l[name,[]l[c[]l[#,[]l[class[]l[part[]l[grade,[]l[exam[]l[grade[]l[for[]l[an[]l[individual[]l[student

Each[]l[individual[]l[cell[]l[in[]l[the[]l[spreadsheet[]l[is[]l[called?[]l[-[]l[correct[]l[answers-a[]l[field



example:[]l["25"[]l[is[]l[in[]l[the[]l[field[]l[for[]l[class[]l[participation

what[]l[is[]l[a[]l[data[]l[file?[]l[-[]l[correct[]l[answers-grouping[]l[of[]l[related[]l[records[]l[



similar[]l[in[]l[appearance[]l[to[]l[an[]l[excel[]l[spreadsheet

what[]l[is[]l[a[]l[database?[]l[-[]l[correct[]l[answers-grouping[]l[of[]l[related[]l[data[]l[files

what[]l[is[]l[the[]l[relational[]l[database[]l[model?[]l[-[]l[correct[]l[answers-based[]l[on[]l[the[]l[concept[]l[of[]l[two-
dimensional[]l[tables



designed[]l[with[]l[a[]l[number[]l[of[]l[related[]l[tables[]l[with[]l[each[]l[of[]l[these[]l[tables[]l[containing[]l[rows[]l[and[]l[colu
mns

what[]l[is[]l[structured[]l[query[]l[language[]l[(SQL)?[]l[-[]l[correct[]l[answers-
language[]l[used[]l[for[]l[interacting[]l[with[]l[a[]l[database



SQL[]l[allows[]l[people[]l[to[]l[perform[]l[complicated[]l[searches[]l[by[]l[using[]l[relatively[]l[simple[]l[statements[]l[or[]l[k
[]l[

ey[]l[words



Who[]l[has[]l[a[]l[higher[]l[gpa,[]l[students[]l[from[]l[cali[]l[or[]l[students[]l[from[]l[boston?