BCIS1305BUSINESSCOMPUTERAPPLICATIONS
Homework4
PartI
True/False
1. A database is a collection of information that you organize and access
according to the logical structure of that information.
a) True b) False
2. Businessintelligenceisknowledgeaboutyourcustomers,yourcompetitors,
yourpartners,yourcompetitiveenvironment,andyourowninternal
operations.
a) True b) False
3. Onlineanalyticalprocessing(OLAP)isthegatheringofinputinformation,
processingthatinformation,andupdatingexistinginformationtoreflect
thegatheredandprocessedinformation.
a) True b) False
4. Ifanemployeeneedstochangethedetailsofaspecificcustomerorder,
he/shewoulduseOLTP(onlinetransactionprocessing).
a) True b) False
5. XYZ,Corp.wouldliketodetermineadvertisingstrategiesforcustomerswho
buyhigh-pricedproducts.ItwoulduseOLTPonitsdatawarehouse.
a) True b) False
6. Aprimarykeymustconsistofoneandonlyonefield.
a) True b) False
7. Aprimarykeyfromonefileandaforeignkeyfromanotherfileareusedto
createarelationshipbetweentwofilesinarelationaldatabase.
a) True b) False
8. Ifyouneedtoaddanewfieldtoadatabase,youwouldusethedata
manipulationsystem.
a) True b) False
9. Backupandrecoveryfacilitiesareincludedinthedataadministration
subsystem.
a) True b) False
10. Databasesecurityandnetworksecurityarethesamething.
a) True b) False
11. Adatawarehouseisalogicalcollectionofinformationgatheredfrommany
differentoperationaldatabasesusedtocreatebusinessintelligencethat
supportsbusinessanalysisactivitiesanddecision-makingtasks.
a) True b) False
12. Ahypercubeisatwo-dimensionalrepresentationofinformation.
a) True b) False
13. Datawarehousessupporttransactionprocessing.
a) True b) False
14. Multidimensionalanalysis(MDA)toolsareslice-and-dicetechniquesthat
allowyoutoviewmultidimensionalinformationfromdifferentperspectives.
a) True b) False
15. Data-mining tools support the concept of OLTP in manipulating information to
support decisions.
a) True b) False
16. Adatamartisasubsetofadatawarehouseinwhichonlyafocusedportion
ofthedatawarehouseinformationiskept.
a) True b) False
17. Anintelligentagentutilizesartificialintelligenceto"discover"
informationindatawarehouses.
a) True b) False
18. IntelligentagentsareusedinOLAPandinonlinesearching.
a) True b) False
19. Datamartsfocusontheentireorganization,whiledatawarehousesfocus
specificneeds.
a) True b) False
20. Dataadministrationisthefunctioninanorganizationthatisresponsible
forthemoretechnicalandoperationalaspectsofmanagingtheinformation
containedinorganizationalinformationrepositories.
a) True b) False
PartII
MultipleChoice
21. Whichsystemallowsyourorganizationtogather,process,andupdate
transactionalinformation?
a) Onlineanalyticalprocessing(OLAP)
b) Businessintelligence(BI)
c) Filemanagementsystems(FMS)
d) Onlinetransactionprocessing(OLTP)
22. Whichtypeofdatabasestoresdatainaseriesoflogicallyrelated
two-dimensionaltablesorfiles?
a) Hierarchical
b) File-based
c) Conventional
d) Relational
23. YourstudentIDisanexampleofa(n)______.
a) Relation
b) Table
c) Businessrule
d) Attribute
24. Whichtermreferstoaspecificpieceofdatathatisstoredinadatabase
file?
a) Relation
b) Category
c) Class
d) Attribute
25. Whatisthetypeoffield,orgroupoffields,thatcanuniquelyidentify
eachrecordinadatabase?
a) Identifying
b) Relational
c) Primarykey
d) Mainfield
26. Everyprimarykeycanalsobea______key.
a) Foreign
b) Secondary
c) Identifying
d) Relational
27. Whichtypeofconstraintensuresthequalityofinformationinarelational
database?
a) Environmental
b) Businessconstraint
c) Integrityconstraint
d) Productionconstraint
28. Adatabasemanagementsystemcontainsfiveimportantsoftwarecomponents.
Whichofthefollowingcomponentsallowsyoutodefinethestructureofa
database?
a) Datadefinitionsubsystem
b) Datamanipulationsubsystem
c) Applicationgeneratorsubsystem
d) Dataadministrationsubsystem
29. WhatisSQL?
a) AfourthgenerationlanguagefoundinmostDBMSs
b) Astoragetoolthatholdsthedataanddefinitionsforadatabase
c) Anadministrativetoolthatallowsyoutosetaccessrightsfordatabase
users
d) AprogramminglanguagethatcanbeusedinsteadofaDBMS
30. Whatisadatawarehouse?
a) Alargehardwareenvironmentthatsupportsmultipleplatforms
b) Alogicalcollectionofinformationgatheredfrommanydifferent
operationaldatabasestocreatebusinessintelligence
c) Anoperationaldatabasesystemusedtomanageandanalyzetransactional
data
d) Anaccumulationofalloperationaldatastoredbylargeorganizations
31.Whatisthepurposeofadatawarehouse?
a) Backupandrecovery
b) TosupportdecisionmakingandOLAP
c) TosupporttransactionprocessingandOLTP
d) Tosupport,backupandrecovery,OLAP,andOLTP
32. Ifyouweretoperformaregressionanalysis,whattypeofdatawarehouse
toolwouldyouuse?
a) Statistical
b) Multidimensionalanalysis
c) Productionanalysis
d) Hypercube
33. Whatistheobjectiveofbusinessintelligence(BI)?
a) Toprocesstransactionalinformationefficientlyandeffectively
b) Toprovidedecisionsmakerswithagreatdealofinformation
c) Toprovidetimelyandqualityinformationtodecisionmakers
d) Toprocessexternalinformationorinformationthatispurchasedfrom
outsidevendors
34. Whenbusinessintelligenceisfocusedontheexternalcompetitive
environment,itisknownas______.
a) Externalinformation
b) Trends
c) Competitiveintelligence
d) Competitorknowledge
35. Whatisadigitaldashboard?
a) Anewtypeofelectronicdashboardforhigh-pricedcarsthatdisplaysGPS
informationalongsideoftraditionalinformation
b) Alearningenvironmentforonlineeducationalcourses
c) Acomputertoolthatprovidescompetitiveinformationfromexternal
sources
d) Acomputerscreenthatprovidestailored,currentsnapshotsof
informationandtrends
36. Whichorganizationalfunctionisresponsibleforthemoretechnicaland
operationalaspectsofmanaginginformationrepositories?
a) Databaseadministration
b) Strategicmanagement
c) Informationresourceplanning
d) Operationalplanning
37. Whichorganizationalfunctionisresponsiblefordevelopingsecurity
proceduresforanorganization?
a) Datasecurity
b) Dataprotection
c) Informationresourcemanagement
d) Databaseadministration
38. Whatisthedifferencebetweendataadministrationanddatabase
administration?
a) Dataadministrationfocusesonstrategicmanagementwhereasdatabase
administrationfocusesonoperationalissues
b) DataadministrationfocusesonOLTPwhereasdatabaseadministration
focusesonOLAP
c) Dataadministrationanddatabaseadministrationaretermsthatcanbe
usedinterchangeably
d) Dataadministrationfocusesonthedevelopmentofthedatadictionary
whereasdatabaseadministrationfocusesontherawdata
39. Whatisthetermusedtodescribethesharingofinformationregardlessof
titleordepartment.
a) Opensource
b) Datamining
c) Informationsharing
d) Datadistribution
40. Ifyourstudentinformationhadtwodifferentbirthdatesforyou,yourdata
wouldnotbeconsidered______.
a) Legitimate
b) Correct
c) Clean
d) Acceptable
Chapter 3 - Databases and Data Warehouses Page 1 of 6