mis12 信息系统复习参考6Word下载.docx
- 文档编号:22802390
- 上传时间:2023-02-05
- 格式:DOCX
- 页数:34
- 大小:23.56KB
mis12 信息系统复习参考6Word下载.docx
《mis12 信息系统复习参考6Word下载.docx》由会员分享,可在线阅读,更多相关《mis12 信息系统复习参考6Word下载.docx(34页珍藏版)》请在冰豆网上搜索。
2)Eachcharacteristicorqualitydescribingaparticularentityiscalledanattribute.
TRUE
3)Program-datadependencereferstothecouplingofdatastoredinfilesandsoftwareprogramsthatusethisdatasuchthatchangesinprogramsrequirechangestothedata.
2PageRef:
211
6.1
4)ADBMSseparatesthelogicalandphysicalviewsofdata.
212
6.2
5)Everyrecordinafileshouldcontainatleastonekeyfield.
214
6)Manyapplicationstodayrequiredatabasesthatcanstoreandretrievemultimedia.
215
7)OneofthedrawbackstoOODBMSarethattheycannotworkwithapplets.
8)OODBMSareslowerthanrelationalDBMS.
9)Adatadictionaryisalanguageassociatedwithadatabasemanagementsystemthatendusersandprogrammersusetomanipulatedatainthedatabase.
217
10)Inarelationaldatabase,complexgroupingsofdatamustbestreamlinedtoeliminateawkwardmany-to-manyrelationships.
220
11)Adatawarehousemaybeupdatedbyalegacysystem.
222
6.4
12)Adatawarehouseistypicallycomprisedofseveralsmallerdatamarts.
223
13)OLAPisakeytoolofBI.
224
14)OLAPenablesuserstoobtainonlineanswerstoad-hocquestionsinafairlyrapidamountoftime,exceptwhenthedataarestoredinverylargedatabases.
15)Predictiveanalysisissynonymouswithdatamining.
3PageRef:
226
16)InaWeb-baseddatabase,middlewareisusedtotransferinformationfromtheorganization'
sinternaldatabasebacktotheWebserverfordeliveryintheformofaWebpagetotheuser.
229
17)ThedisadvantageofusingaWebinterfaceforadatabaseisthatittypicallyrequiressubstantialchangestotheinternaldatabase.
18)CommonGatewayInterfaceisaspecificationforprocessingdataonaWebserver.
2931
19)Dataadministrationisaspecialorganizationalfunctionthatmanagesthepoliciesandproceduresthroughwhichdatacanbemanagedasanorganizationalresource.
230
6.5
20)Datacleansingisthesameprocessasdatascrubbing.
231
21)Whichofthefollowingbestillustratestherelationshipbetweenentitiesandattributes?
A)theentityCUSTOMERwiththeattributePRODUCT
B)theentityCUSTOMERwiththeattributePURCHASE
C)theentityPRODUCTwiththeattributePURCHASE
D)theentityPRODUCTwiththeattributeCUSTOMER
B
AnalyticSkills
Analysis
22)Whichofthefollowingisnotoneofthemainproblemswithatraditionalfileenvironment?
A)datainconsistency
B)program-dataindependence
C)lackofflexibilityincreatingad-hocreports
D)poorsecurity
23)ADBMSreducesdataredundancyandinconsistencyby
A)enforcingreferentialintegrity.
B)uncouplingprogramanddata.
C)utilizingadatadictionary.
D)minimizingisolatedfileswithrepeateddata.
D
213
24)Acharacteristicorqualitydescribinganentityiscalleda(n)
A)field.
B)tuple.
C)keyfield.
D)attribute.
25)Whichofthefollowingnon-digitaldatastorageitemsismostsimilartoadatabase?
A)librarycardcatalog
B)cashregisterreceipt
C)doctor'
sofficeinvoice
D)listofsalestotalsonaspreadsheet
A
210-211
26)Theconfusioncreatedby________makesitdifficultforcompaniestocreatecustomerrelationshipmanagement,supplychainmanagement,orenterprisesystemsthatintegratedatafromdifferentsources.
A)batchprocessing
B)dataredundancy
C)dataindependence
D)onlineprocessing
27)Duplicatedatainmultipledatafilesiscalleddata________.
A)redundancy
B)repetition
C)independence
D)partitions
28)ADBMSmakesthe
A)physicaldatabaseavailablefordifferentlogicalviews.
B)logicaldatabaseavailablefordifferentanalyticalviews.
C)physicaldatabaseavailablefordifferentanalyticalviews.
D)logicaldatabaseavailablefordifferentphysicalviews.
29)Thelogicalview
A)showshowdataareorganizedandstructuredonthestoragemedia.
B)presentsanentryscreentotheuser.
C)allowsthecreationofsupplementaryreports.
D)presentsdataastheywouldbeperceivedbyendusers.
30)DBMSformidrangecomputersincludeallofthefollowingEXCEPT
A)DB2.
B)Oracle.
C)MicrosoftSQLServer.
D)MicrosoftAccess.
31)Thetypeoflogicaldatabasemodelthattreatsdataasiftheywerestoredintwo-dimensionaltablesisthe
A)OODBMS.
B)pre-digitalDBMS.
C)relationalDBMS.
D)hierarchicalDBMS.
C
32)OracleDatabaseLiteisa(n)
A)DBMSforsmallhandheldcomputingdevices.
B)InternetDBMS.
C)mainframerelationalDBMS.
D)DBMSformidrangecomputers.
33)MicrosoftSQLServerisa(n)
C)desktoprelationalDBMS.
34)Inatableforcustomers,theinformationaboutasinglecustomerwouldresideinasingle
B)row.
C)column.
D)table.
35)Inarelationaldatabase,arecordisreferredtointechnicaltermsasa(n)
A)tuple.
C)entity.
D)field.
36)Afieldidentifiedinatableasholdingtheuniqueidentifierofthetable'
srecordsiscalledthe
A)primarykey.
B)keyfield.
C)primaryfield.
D)uniqueID.
37)Afieldidentifiedinarecordasholdingtheuniqueidentifierforthatrecordiscalledthe
38)Inarelationaldatabase,thethreebasicoperationsusedtodevelopusefulsetsofdataare
A)select,project,andwhere.
B)select,join,andwhere.
C)select,project,andjoin.
D)select,from,andjoin.
39)Theselectoperation
A)combinesrelationaltablestoprovidetheuserwithmoreinformationthanisotherwiseavailable.
B)createsasubsetconsistingofcolumnsinatable.
C)identifiesthetablefromwhichthecolumnswillbeselected.
D)createsasubsetconsistingofallrecordsinthefilethatmeetstatedcriteria.
40)Thejoinoperation
B)identifiesthetablefromwhichthecolumnswillbeselected.
C)createsasubsetconsistingofcolumnsinatable.
D)organizeselementsintosegments.
41)Theprojectoperation
C)organizeselementsintosegments.
D)identifiesthetablefromwhichthecolumnswillbeselected.
Use
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- mis12 信息系统复习参考6 信息系统 复习 参考
![提示](https://static.bdocx.com/images/bang_tan.gif)