武汉理工大学数据库系统原理总复习题完整版含答案Word文档格式.docx
《武汉理工大学数据库系统原理总复习题完整版含答案Word文档格式.docx》由会员分享,可在线阅读,更多相关《武汉理工大学数据库系统原理总复习题完整版含答案Word文档格式.docx(25页珍藏版)》请在冰豆网上搜索。
wecannowdefineinformationas:
●Knowledgederivedfromdata.
●Datapresentedinameaningfulcontext.
●Dataprocessedbysumming,ordering,averaging,grouping,comparingorothersimilaroperations.
1.10Whatproblemcanoccurwhenadatabaseisprocessedbymorethanoneuser?
Whenmorethanoneuseremploysadatabaseapplication,theseisalwaysthechancethatoneuser'
sworkmayinterferewithother'
s.
1.12Whatisthepurposeofthelargestdatabasesate-commercecompaniessuchasAmazon.?
Thelargestdatabasesarethosethattrackcustomerbrowserbehavior.(用来记录用户的浏览行为的。
)
1.13Howdothee-commercecompaniesusethesedatabases?
.
E-commercecompaniesuseWebactivitydatabasestodeterminewhichitemsonaWebpagearepopularandsuccessfulandwhicharenot.
1.14Howdodigitaldashboardanddataminingapplicationsdifferfromtransactionprocessingapplications?
Digitaldashboardsandotherreportingsystemsassesspastandcurrentperformance.Dataminingapplicationspredictfutureperformance.
1.15Explainwhyasmalldatabaseisnotnecessarilysimplerthanalargeone.
Whatarethefunctionsofapplicationprograms?
Supposedwehave2companywhicharedifferentinsalesbuthavesimilardatabase.Thoughthedifferenceinsale,bothhavethesamekindsofdata,aboutthesamenumberoftablesofdata,andthesamelevelofcomplexityindatarelationships.Onlytheamountofdatavariesfromonetotheother.Thus,althoughadatabaseforasmallbusinessmaybesmall,itisnotnecessarilysimple.
1.18WhatisStructuredQueryLanguage(SQL),andwhyisitimportant?
StructuredQueryLanguage(SQL)isaninternationallyrecognizedstandardlanguage.BecauseitcanbeunderstoodbyallcommercialDBMSproducts,indatabaseprocessingandthefactthatdatabaseapplicationstypicallysendSQLstatementstotheDBMSforprocessing.
1.19WhatdoesDBMSstandfor?
Thedatabasemanagementsystem.
1.20WhatarethefunctionsoftheDBMS?
Itcanbeusedtocreate,process,andadministerthedatabase.
1.21NamethreevendorsofDBMSproducts.
IBM,Microsoft,Oracle.
1.22Definethetermdatabase.
Adatabaseisaself-describingcollectionofintegratedtables.
1.23Whyisadatabaseconsideredtobeself-describing?
ANSWER:
Adatabaseisself-describingbecauseitcontainsadescriptionofitself.Thus,databasescontainnotonlytablesofuserdata,butalsotablesofdatathatdescribethatuserdata.
1.24Whatismetadata?
Howdoesthistermpertaintoadatabase?
databasescontainnotonlytablesofuserdata,butalsotablesofdatathatdescribethatuserdata.Suchdescriptivedataiscalledmetadatabecauseitisdataaboutdata.
1.25Whatadvantageisthereinstoringmetadataintables?
Becausemetadataisstoredintables,youcanuseSQLtoqueryit.Thus,bylearninghowtowriteSQLtoqueryusertables,youwillalsolearnhowtowriteSQLtoquerymetadata.
1.26Listthecomponentsofadatabaseotherthanusertablesandmetadata.
•Tablesofuserdata
•Metadata
•Indexes
•Storedprocedures
•Triggers
•Securitydata
•Backup/recoverydata
1.27IsMicrosoftAccessaDBMS?
Whyorwhynot?
No,MicrosoftAccessisnotjustaDBMS.Rather,itisapersonaldatabasesystem:
aDBMSplusanapplicationgenerator.
BecausealthoughMicrosoftAccesscontainsaDBMSenginethatcreates,processes,andadministersthedatabase,italsocontainsform,report,andquerycomponentsthataretheMicrosoftAccessapplicationgenerator
1.37Listseveralconsequencesofapoorlydesigneddatabase.
-TheymayrequireapplicationdeveloperstowriteoverlycomplexandcontrivedSQLtoget–wanteddata.
-theymaybedifficulttoadapttonewandchangingrequirements.
-theymayfailinsomeotherway.
1.38Explaintwowaysthatadatabasecanbedesignedfromexistingdata.
ThefirsttypeofdatabasedesigninvolvesdatabasesthatareconstructedfromexistingData.
Asecondwaythatdatabasesaredesignedisforthedevelopmentofnewinformationsystems.
1.39Whatisadatawarehouse?
Whatisadatamart?
Thedatawarehouseanddatamartdatabasesstoredataspecificallyorganizedforresearchandreportingpurposes,andthesedataoftenareexportedtootheranalyticaltools,suchasSAS’sEnterpriseMiner,IBM'
sSPSSDataModeler,orTIBCO'
sSpotfireMetrics.
1.40Describethegeneralprocessofdesigningadatabaseforanewinformationsystem.
First,theteamcreatesadatamodelfromtherequirementsstatementsandthentransformsthatdatamodelintoadatabasedesign.
1.41Explaintwowaysthatdatabasescanberedesigned.
Inthefirst,adatabaseisadaptedtoneworchangingrequirements.Thisprocesssometimesiscalleddatabasemigration.Inthemigrationprocess,tablesmaybecreated,modified,orremoved;
relationshipsmaybealtered;
dataconstraintsmaybechanged;
andsoforth.
Thesecondtypeofdatabaseredesigninvolvestheintegrationoftwoormoredatabases.Thistypeofredesigniscommonwhenadaptingorremovinglegacysystems.Itisalsocommonforenterpriseapplicationintegration,whentwoormorepreviouslyseparateinformationsystemsareadaptedtoworkwitheachother.
1.42Whatdoesthetermdatabasemigrationmean?
Theprocessofadatabaseisadaptedtoneworchangingrequirements.
1.43Summarizethevariouswaysthatyoumightworkwithdatabasetechnology.
Inourcareer,wemayworkwithdatabasetechnologyaseitherauserorasadatabaseadministrator.
Asauser,youmaybeaknowledgeworkerwhopreparesreports,minesdata,anddoesothertypesofdataanalysisoryoumaybeaprogrammerwhowritesapplicationsthatprocessthedatabase.
Alternatively,youmightbeadatabaseadministratorwhodesigns,constructs,andmanagesthedatabaseitself.UsersareprimarilyconcernedwithconstructingSQLstatementstogetandputthedatatheywant.Databaseadministratorsareprimarilyconcernedwiththemanagementofthedatabase.
1.44Whatjobfunctionsdoesaknowledgeworkerperform?
preparingreports,miningdata,anddoingothertypesofdataanalysis.
1.45Whatjobfunctionsdoesadatabaseadministratorperform?
designing,constructing,andmanagingthedatabaseitself.
1.47Whatneeddrovethedevelopmentofthefirstdatabasetechnology?
Theneedfordataintegrationdrovethedevelopmentofthefirstdatabasetechnology.
1.48WhatareDataLanguage/IandCODASYLDBTG?
DataLanguage/I(DL/I)usedhierarchiesortrees(seeAppendixG)torepresentrelationships.
Thissubcommitteedevelopedastandarddatamodelthatcametobearitsname—theCODASYLDBTGmodel.Itwasanunnecessarilycomplicatedmodel.Thisdatarelationshipuseddatastructurescallednetworks.
1.49WhowasE.F.Codd?
E.F.Coddwasalittle-knownIBMengineerpublishedapaperintheCommunicationsoftheACM3inwhichheappliedtheconceptsofabranchofmathematicscalledrelationalalgebratotheproblemof“shareddatabanks,”asdatabaseswerethenknown.Theresultsofthisworkarenowtherelationalmodelfordatabases,andallrelationaldatabaseDBMSproductsarebuiltonthismodel.
1.50Whatweretheearlyobjectionstotherelationalmodel?
1.51NametwoearlyrelationalDBMSproducts.
OracleDatabase,DB2.
1.52WhataresomeofthereasonsforthesuccessofOracleDatabase?
1,itwouldrunonjustaboutanycomputerandjustaboutanyoperatingsystem.
2,OracleDatabasehad,andcontinuestohave,anelegantandefficientinternaldesign.
1.53NamethreeearlypersonalcomputerDBMSproducts.
dBase,R:
base,Paradox.
1.55WhatwasthepurposeofOODBMSproducts?
StatetworeasonsthatOODBMSproductswerenotsuccessful.
TheyweredesignedtomakeiteasytostorethedataencapsulatedinOOPobjects.
Thereweretworeasonsfortheirlackofacceptance.First,usinganOODBMSrequiredthattherelationaldatabeconvertedfromrelationalformattoobject-orientedformat.BythetimeOODBMSemerged,billionsuponbillionsofbytesofdatawerestoredinrelationalformatinorganizationaldatabases.NocompanywaswillingtoundergotheexpensivetravailofconvertingthosedatabasestobeabletousethenewOODBMS.
Second,object-orienteddatabaseshadnosubstantialadvantageoverrelationaldatabasesformostcommercialdatabaseprocessing.Asyouwillseeinthenextchapter,SQLisnotobjectoriented.Butitworks,andthousandsofdevelopershavecreatedprogramsthatuseit.Withoutademonstrableadvantageoverrelationaldatabases,noorganizationwaswillingtotakeonthetaskofconvertingtheirdatatoOODBMSformat.
1.56WhatcharacteristicofHTTPwasaproblemfordatabaseprocessingapplications?
HTTPisastatelessprotocol;
aserverreceivesarequestfromauser,processestherequest,andthenforgetsabouttheuserandtherequest.Manydatabaseinteractionsaremultistage.Acustomerviewsproducts,addsoneormoretoashoppingcart,viewsmoreproducts,addsmoretotheshoppingcart,andeventuallychecksout.Astatelessprotocolcannotbeusedforsuchapplications.
1.57WhatisanopensourceDBMSproduct?
WhichofthefiveDBMSproductsth