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