mis12 信息系统复习参考6.docx
《mis12 信息系统复习参考6.docx》由会员分享,可在线阅读,更多相关《mis12 信息系统复习参考6.docx(34页珍藏版)》请在冰豆网上搜索。
mis12信息系统复习参考6
ManagementInformationSystems,12e(Laudon)
Chapter6FoundationsofBusinessIntelligence:
DatabasesandInformationManagement
1)Agroupingofcharactersintoaword,agroupofwords,oracompletenumberiscalledarecord.
Answer:
FALSE
Diff:
1PageRef:
210
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
2)Eachcharacteristicorqualitydescribingaparticularentityiscalledanattribute.
Answer:
TRUE
Diff:
1PageRef:
210
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
3)Program-datadependencereferstothecouplingofdatastoredinfilesandsoftwareprogramsthatusethisdatasuchthatchangesinprogramsrequirechangestothedata.
Answer:
TRUE
Diff:
2PageRef:
211
AACSB:
UseofIT
CASE:
Content
Objective:
6.1
4)ADBMSseparatesthelogicalandphysicalviewsofdata.
Answer:
TRUE
Diff:
2PageRef:
212
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
5)Everyrecordinafileshouldcontainatleastonekeyfield.
Answer:
TRUE
Diff:
1PageRef:
214
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
6)Manyapplicationstodayrequiredatabasesthatcanstoreandretrievemultimedia.
Answer:
TRUE
Diff:
1PageRef:
215
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
7)OneofthedrawbackstoOODBMSarethattheycannotworkwithapplets.
Answer:
FALSE
Diff:
2PageRef:
215
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
8)OODBMSareslowerthanrelationalDBMS.
Answer:
TRUE
Diff:
2PageRef:
215
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
9)Adatadictionaryisalanguageassociatedwithadatabasemanagementsystemthatendusersandprogrammersusetomanipulatedatainthedatabase.
Answer:
FALSE
Diff:
1PageRef:
217
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
10)Inarelationaldatabase,complexgroupingsofdatamustbestreamlinedtoeliminateawkwardmany-to-manyrelationships.
Answer:
TRUE
Diff:
1PageRef:
220
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
11)Adatawarehousemaybeupdatedbyalegacysystem.
Answer:
TRUE
Diff:
1PageRef:
222
AACSB:
UseofIT
CASE:
Content
Objective:
6.4
12)Adatawarehouseistypicallycomprisedofseveralsmallerdatamarts.
Answer:
FALSE
Diff:
2PageRef:
223
AACSB:
UseofIT
CASE:
Content
Objective:
6.4
13)OLAPisakeytoolofBI.
Answer:
TRUE
Diff:
2PageRef:
224
AACSB:
UseofIT
CASE:
Content
Objective:
6.4
14)OLAPenablesuserstoobtainonlineanswerstoad-hocquestionsinafairlyrapidamountoftime,exceptwhenthedataarestoredinverylargedatabases.
Answer:
FALSE
Diff:
2PageRef:
224
AACSB:
UseofIT
CASE:
Content
Objective:
6.4
15)Predictiveanalysisissynonymouswithdatamining.
Answer:
FALSE
Diff:
3PageRef:
226
AACSB:
UseofIT
CASE:
Content
Objective:
6.4
16)InaWeb-baseddatabase,middlewareisusedtotransferinformationfromtheorganization'sinternaldatabasebacktotheWebserverfordeliveryintheformofaWebpagetotheuser.
Answer:
TRUE
Diff:
2PageRef:
229
AACSB:
UseofIT
CASE:
Content
Objective:
6.4
17)ThedisadvantageofusingaWebinterfaceforadatabaseisthatittypicallyrequiressubstantialchangestotheinternaldatabase.
Answer:
FALSE
Diff:
1PageRef:
229
AACSB:
UseofIT
CASE:
Content
Objective:
6.4
18)CommonGatewayInterfaceisaspecificationforprocessingdataonaWebserver.
Answer:
TRUE
Diff:
2PageRef:
2931
AACSB:
UseofIT
CASE:
Content
Objective:
6.4
19)Dataadministrationisaspecialorganizationalfunctionthatmanagesthepoliciesandproceduresthroughwhichdatacanbemanagedasanorganizationalresource.
Answer:
TRUE
Diff:
2PageRef:
230
AACSB:
UseofIT
CASE:
Content
Objective:
6.5
20)Datacleansingisthesameprocessasdatascrubbing.
Answer:
TRUE
Diff:
1PageRef:
231
AACSB:
UseofIT
CASE:
Content
Objective:
6.5
21)Whichofthefollowingbestillustratestherelationshipbetweenentitiesandattributes?
A)theentityCUSTOMERwiththeattributePRODUCT
B)theentityCUSTOMERwiththeattributePURCHASE
C)theentityPRODUCTwiththeattributePURCHASE
D)theentityPRODUCTwiththeattributeCUSTOMER
Answer:
B
Diff:
3PageRef:
210
AACSB:
AnalyticSkills
CASE:
Analysis
Objective:
6.3
22)Whichofthefollowingisnotoneofthemainproblemswithatraditionalfileenvironment?
A)datainconsistency
B)program-dataindependence
C)lackofflexibilityincreatingad-hocreports
D)poorsecurity
Answer:
B
Diff:
2PageRef:
211
AACSB:
UseofIT
CASE:
Analysis
Objective:
6.1
23)ADBMSreducesdataredundancyandinconsistencyby
A)enforcingreferentialintegrity.
B)uncouplingprogramanddata.
C)utilizingadatadictionary.
D)minimizingisolatedfileswithrepeateddata.
Answer:
D
Diff:
3PageRef:
213
AACSB:
UseofIT
CASE:
Content
Objective:
6.1
24)Acharacteristicorqualitydescribinganentityiscalleda(n)
A)field.
B)tuple.
C)keyfield.
D)attribute.
Answer:
D
Diff:
1PageRef:
210
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
25)Whichofthefollowingnon-digitaldatastorageitemsismostsimilartoadatabase?
A)librarycardcatalog
B)cashregisterreceipt
C)doctor'sofficeinvoice
D)listofsalestotalsonaspreadsheet
Answer:
A
Diff:
2PageRef:
210-211
AACSB:
AnalyticSkills
CASE:
Analysis
Objective:
6.1
26)Theconfusioncreatedby________makesitdifficultforcompaniestocreatecustomerrelationshipmanagement,supplychainmanagement,orenterprisesystemsthatintegratedatafromdifferentsources.
A)batchprocessing
B)dataredundancy
C)dataindependence
D)onlineprocessing
Answer:
B
Diff:
1PageRef:
211
AACSB:
UseofIT
CASE:
Content
Objective:
6.1
27)Duplicatedatainmultipledatafilesiscalleddata________.
A)redundancy
B)repetition
C)independence
D)partitions
Answer:
A
Diff:
1PageRef:
211
AACSB:
UseofIT
CASE:
Content
Objective:
6.1
28)ADBMSmakesthe
A)physicaldatabaseavailablefordifferentlogicalviews.
B)logicaldatabaseavailablefordifferentanalyticalviews.
C)physicaldatabaseavailablefordifferentanalyticalviews.
D)logicaldatabaseavailablefordifferentphysicalviews.
Answer:
A
Diff:
2PageRef:
212
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
29)Thelogicalview
A)showshowdataareorganizedandstructuredonthestoragemedia.
B)presentsanentryscreentotheuser.
C)allowsthecreationofsupplementaryreports.
D)presentsdataastheywouldbeperceivedbyendusers.
Answer:
D
Diff:
2PageRef:
212
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
30)DBMSformidrangecomputersincludeallofthefollowingEXCEPT
A)DB2.
B)Oracle.
C)MicrosoftSQLServer.
D)MicrosoftAccess.
Answer:
D
Diff:
3PageRef:
213
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
31)Thetypeoflogicaldatabasemodelthattreatsdataasiftheywerestoredintwo-dimensionaltablesisthe
A)OODBMS.
B)pre-digitalDBMS.
C)relationalDBMS.
D)hierarchicalDBMS.
Answer:
C
Diff:
1PageRef:
213
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
32)OracleDatabaseLiteisa(n)
A)DBMSforsmallhandheldcomputingdevices.
B)InternetDBMS.
C)mainframerelationalDBMS.
D)DBMSformidrangecomputers.
Answer:
A
Diff:
3PageRef:
213
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
33)MicrosoftSQLServerisa(n)
A)DBMSforsmallhandheldcomputingdevices.
B)InternetDBMS.
C)desktoprelationalDBMS.
D)DBMSformidrangecomputers.
Answer:
D
Diff:
3PageRef:
213
AACSB:
UseofIT
CASE:
Content
Objective:
6.2
34)Inatableforcustomers,theinformationaboutasinglecustomerwouldresideinasingle
A)field.
B)row.
C)column.
D)table.
Answer:
B
Diff:
1PageRef:
214
AACSB:
UseofIT
CASE:
Analysis
Objective:
6.3
35)Inarelationaldatabase,arecordisreferredtointechnicaltermsasa(n)
A)tuple.
B)row.
C)entity.
D)field.
Answer:
A
Diff:
2PageRef:
214
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
36)Afieldidentifiedinatableasholdingtheuniqueidentifierofthetable'srecordsiscalledthe
A)primarykey.
B)keyfield.
C)primaryfield.
D)uniqueID.
Answer:
A
Diff:
2PageRef:
214
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
37)Afieldidentifiedinarecordasholdingtheuniqueidentifierforthatrecordiscalledthe
A)primarykey.
B)keyfield.
C)primaryfield.
D)uniqueID.
Answer:
B
Diff:
2PageRef:
214
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
38)Inarelationaldatabase,thethreebasicoperationsusedtodevelopusefulsetsofdataare
A)select,project,andwhere.
B)select,join,andwhere.
C)select,project,andjoin.
D)select,from,andjoin.
Answer:
C
Diff:
2PageRef:
215
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
39)Theselectoperation
A)combinesrelationaltablestoprovidetheuserwithmoreinformationthanisotherwiseavailable.
B)createsasubsetconsistingofcolumnsinatable.
C)identifiesthetablefromwhichthecolumnswillbeselected.
D)createsasubsetconsistingofallrecordsinthefilethatmeetstatedcriteria.
Answer:
D
Diff:
1PageRef:
215
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
40)Thejoinoperation
A)combinesrelationaltablestoprovidetheuserwithmoreinformationthanisotherwiseavailable.
B)identifiesthetablefromwhichthecolumnswillbeselected.
C)createsasubsetconsistingofcolumnsinatable.
D)organizeselementsintosegments.
Answer:
A
Diff:
1PageRef:
215
AACSB:
UseofIT
CASE:
Content
Objective:
6.3
41)Theprojectoperation
A)combinesrelationaltablestoprovidetheuserwithmoreinformationthanisotherwiseavailable.
B)createsasubsetconsistingofcolumnsinatable.
C)organizeselementsintosegments.
D)identifiesthetablefromwhichthecolumnswillbeselected.
Answer:
B
Diff:
1PageRef:
215
AACSB:
Use