Chapter 3 Database Systems, Data Warehouses, and Data Marts True False

Chapter 3 - Database Systems, Data Warehouses, and Data Marts True / False 1.Althoughadatabasecanconsistofonlyasinglefile,itisusuallyagroupoffiles.  a. True  b. False ANSWER: True RATIONALE: Correct Althoughadatabasecanconsistofonlyasinglefile,itisusuallyagroupoffiles.Auniversity database,forexample,mighthavefilesforstudents,staff,faculty,andcourses.See3-1:Databases POINTS: 1 DIFFICULTY: Easy REFERENCES: Defineadatabaseandadatabasemanagementsystem. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.01 TIVES: TOPICS: Databases KEYWORDS: Remember DATECREATED: DATEMODIFIED: 2.Adatabaseisacriticalcomponentofinformationsystemsbecauseanytypeofanalysisthatisdoneisbasedondata availableinthedatabase.  a. True  b. False ANSWER: True RATIONALE: Correct Adatabaseisacriticalcomponentofinformationsystemsbecauseanytypeofanalysisthatisdone isbasedondataavailableinthedatabase.Tomakeusingdatabasesmoreefficient,adatabase managementsystemisused.See3-1:Databases POINTS: 1 DIFFICULTY: Moderate REFERENCES: Defineadatabaseandadatabasemanagementsystem. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.01 TIVES: TOPICS: Databasedefined KEYWORDS: Understand DATECREATED: DATEMODIFIED: 3.Laborandpopulationstatisticsareexamplesofsourcesforinternaldatathatareaccessedbyadatabase.  a. True  b. False ANSWER: False Page1 Chapter 3 - Database Systems, Data Warehouses, and Data Marts RATIONALE: Correct Laborandpopulationstatisticsareexamplesofsourcesforexternaldatathatareaccessedbya database.Externaldatacomesfromavarietyofsourcesandisoftenstoredinadatawarehouse.See 3-1:Databases POINTS: 1 DIFFICULTY: Easy REFERENCES: Defineadatabaseandadatabasemanagementsystem. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.01 TIVES: TOPICS: Databases KEYWORDS: Remember DATECREATED: DATEMODIFIED: 4.Disksaresequentialaccessdevices,whereastapesarerandomaccessdevices.  a. True  b. False ANSWER: False RATIONALE: Correct Disksarerandomaccessdevices,whereastapesaresequentialaccessdevices.Inasequentialaccess filestructure,recordsinfilesareorganizedandprocessedinnumericalorsequentialorder,typically theorderinwhichtheywereentered.Inarandomaccessfilestructure,recordscanbeaccessedin anyorder,regardlessoftheirphysicallocationsinstoragemedia.See3-1:Databases POINTS: 1 DIFFICULTY: Easy REFERENCES: Defineadatabaseandadatabasemanagementsystem. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.01 TIVES: TOPICS: Databases KEYWORDS: Remember DATECREATED: DATEMODIFIED: 5.Withtheindexedsequentialaccessmethod(ISAM),recordscannotbeaccessedrandomly.  a. True  b. False ANSWER: False RATIONALE: Correct WiththeISAM,recordscanbeaccessedsequentiallyorrandomly,dependingonthenumberbeing accessed.Forasmallnumberofrecords,randomaccessisused,andforalargenumber,sequential accessisused.See3-1:Databases POINTS: 1 Page2 Chapter 3 - Database Systems, Data Warehouses, and Data Marts DIFFICULTY: Understand REFERENCES: Defineadatabaseandadatabasemanagementsystem. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.01 TIVES: TOPICS: Databases KEYWORDS: Moderate DATECREATED: DATEMODIFIED: 6.Anetworkmodelissimilartoahierarchicaldatamodelbecauseinbothdatamodelsrecordsareorganizedinthesame way.  a. True  b. False ANSWER: False RATIONALE: Correct Anetworkmodelissimilartoahierarchicalmodel,butrecordsareorganizeddifferently.Unlikethe hierarchicalmodel,eachrecordinthenetworkmodelcanhavemultipleparentandchildrecords. See3-2:LogicalDatabaseDesign POINTS: 1 DIFFICULTY: Moderate REFERENCES: Explainlogicaldatabasedesignandtherelationaldatabasemodel. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.02 TIVES: TOPICS: Databasedesign KEYWORDS: Understand DATECREATED: DATEMODIFIED: 7.Aselectoperationparesdownatableinarelationaldatabasebyeliminatingcolumnsaccordingtocertaincriteria.  a. True  b. False ANSWER: False RATIONALE: Correct Aselectoperationsearchesdatainatableandretrievesrecordsbasedoncertaincriteria.Aproject operationparesdownatablebyeliminatingcolumnsaccordingtocertaincriteria.See3-2:Logical DatabaseDesign POINTS: 1 DIFFICULTY: Easy REFERENCES: Explainlogicaldatabasedesignandtherelationaldatabasemodel. QUESTIONTYPE:True/False HASVARIABLES: False Page3 Chapter 3 - Database Systems, Data Warehouses, and Data Marts LEARNINGOBJEC MIS9.BIDG.19.03.02 TIVES: TOPICS: Relationaldatabasedesign KEYWORDS: Remember DATECREATED: DATEMODIFIED: 8.Adatabaseengineconvertslogicalrequestsfromusersintotheirphysicalequivalentsbyinteractingwithother componentsofthedatabasemanagementsystem(DBMS).  a. True  b. False ANSWER: True RATIONALE: Correct Adatabaseengineconvertslogicalrequestsfromusersintotheirphysicalequivalentsbyinteracting withothercomponentsoftheDBMS.Itisresponsiblefordatastorage,manipulation,andretrieval. See3-3:ComponentsofaDBMS POINTS: 1 DIFFICULTY: Easy REFERENCES: Definethecomponentsofadatabasemanagementsystem. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.03 TIVES: TOPICS: Databasemanagementsystemcomponents KEYWORDS: Remember DATECREATED: DATEMODIFIED: 9.TheuseoftheORoperatorinaqueryform,whenusingquerybyexample(QBE),meansthatallconditionsmustbe met.  a. True  b. False ANSWER: False RATIONALE: Correct WithQBE,yourequestdatafromadatabasebyconstructingastatementmadeupofqueryforms. TheuseoftheORoperatorinaqueryform,whenusingQBE,meansthatonlyoneoftheconditions mustbemet.See3-3:ComponentsofaDBMS POINTS: 1 DIFFICULTY: Easy REFERENCES: Definethecomponentsofadatabasemanagementsystem. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.03 TIVES: TOPICS: Databasemanagementsystemcomponents KEYWORDS: Remember Page4 Chapter 3 - Database Systems, Data Warehouses, and Data Marts DATECREATED: DATEMODIFIED: 10.StaticWebsitesareusefulfore-commercesitesthatneedfrequentupdates.  a. True  b. False ANSWER: False RATIONALE: Correct Data-drivenWebsitesareusefulfore-commercesitesthatneedfrequentupdates.WithadatadrivenWebsite,userscangetmorecurrentinformationfromavarietyofdatasources.See3-4: RecentTrendsinDatabaseDesignandUse POINTS: 1 DIFFICULTY: Moderate REFERENCES: Summarizerecenttrendsindatabasedesignanduse. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.04 TIVES: TOPICS: Databaseinformationuses KEYWORDS: Understand DATECREATED: DATEMODIFIED: 11.Incontrasttothequerylanguagesusedtointeractwitharelationaldatabase,interactionwithanobject-oriented databasetakesplacesviamethods,whicharecalledbysendingamessagetoanobject.  a. True  b. False ANSWER: True RATIONALE: Correct Incontrasttothequerylanguagesusedtointeractwitharelationaldatabase,interactionwithan object-orienteddatabasetakesplacesviamethods,whicharecalledbysendingamessagetoan object.Messagesareusuallygeneratedbyaneventofsomekind,suchaspressingEnterorclicking themousebutton.See3-4:RecentTrendsinDatabaseDesignandUse POINTS: 1 DIFFICULTY: Moderate REFERENCES: Summarizerecenttrendsindatabasedesignanduse. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.04 TIVES: TOPICS: Databasetrends KEYWORDS: Understand DATECREATED: DATEMODIFIED: 12.Datainadatabaseisusedforanalyticalpurposes,whereasdatainadatawarehouseisusedforcapturingand Page5 Chapter 3 - Database Systems, Data Warehouses, and Data Marts managingtransactions.  a. b.  True False ANSWER: RATIONALE: False Correct Datainadatawarehouseisusedforanalyticalpurposes,whereasdatainadatabaseisusedfor capturingandmanagingtransactions.Datawarehousesstoremultidimensionaldata,sotheyare sometimescalled“hypercubes.”See3-5:DataWarehouses POINTS: 1 DIFFICULTY: Easy REFERENCES: Explainthecomponentsandfunctionsofadatawarehouse. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.05 TIVES: TOPICS: Datawarehouses KEYWORDS: Remember DATECREATED: DATEMODIFIED: 13.Consolidatinginformationfromdifferentdepartmentsorfunctionalareasiseasierindatamartsthanindata warehouses.  a. True  b. False ANSWER: False RATIONALE: Correct Datamartsusuallyhavemorelimitedscopethandatawarehouses,andconsolidatinginformation fromdifferentdepartmentsorfunctionalareasismoredifficult.Adatamartisusuallyasmaller versionofadatawarehouse,usedbyasingledepartmentorfunction.See3-6:DataMarts POINTS: 1 DIFFICULTY: Easy REFERENCES: Describethefunctionsofadatamart. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.06 TIVES: TOPICS: Datamarts KEYWORDS: Remember DATECREATED: DATEMODIFIED: 14.Businessintelligence(BI)usesscorecardsanddashboardstosupportdecision-makingactivities,whereasbusiness analytics(BA)usesdataminingtoolsandpredictivemodeling.  a. True  b. False ANSWER: True Page6 Chapter 3 - Database Systems, Data Warehouses, and Data Marts RATIONALE: Correct BIusesdashboards,scorecards,onlineanalyticalprocessing,andqueryreportstosupportdecisionmakingactivities,whereasBAusesstatisticalanalysis,dataminingtools,andpredictivemodeling. See3-7:BusinessAnalytics POINTS: 1 DIFFICULTY: Easy REFERENCES: Definebusinessanalyticsanddescribeitsroleinthedecision-makingprocess. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.07 TIVES: TOPICS: Businessanalytics KEYWORDS: Remember DATECREATED: DATEMODIFIED: 15.Databasemarketingworksbyusingmultivariateanalysis,datasegmentation,andautomatedtoolstotransform marketingfromaproactivetoareactiveprocess.  a. True  b. False ANSWER: False RATIONALE: Correct Databasemarketingworksbyusingmultivariateanalysis,datasegmentation,andautomatedtools totransformmarketingfromareactivetoaproactiveprocess.Itmakesanorganizationmore responsivetotheneedsanddesiresofitscustomersandalsoallowstheorganizationtobetter respondtochangesinthemarketplace.See3-9:DatabaseMarketing POINTS: 1 DIFFICULTY: Moderate REFERENCES: Explaindatabasemarketinganditsbusinessapplications. QUESTIONTYPE:True/False HASVARIABLES: False LEARNINGOBJEC MIS9.BIDG.19.03.09 TIVES: TOPICS: Databaseinformationuses KEYWORDS: Understand DATECREATED: DATEMODIFIED: Page7