武汉理工大学数据库系统原理总复习题完整版含答案Word文件下载.docx

资源描述

武汉理工大学数据库系统原理总复习题完整版含答案Word文件下载.docx

《武汉理工大学数据库系统原理总复习题完整版含答案Word文件下载.docx》由会员分享，可在线阅读，更多相关《武汉理工大学数据库系统原理总复习题完整版含答案Word文件下载.docx（25页珍藏版）》请在冰豆网上搜索。

武汉理工大学数据库系统原理总复习题完整版含答案Word文件下载.docx

wecannowdefineinformationas:

●Knowledgederivedfromdata.

●Datapresentedinameaningfulcontext.

●Dataprocessedbysumming,ordering,averaging,grouping,comparingorothersimilaroperations.

1.10Whatproblemcanoccurwhenadatabaseisprocessedbymorethanoneuser?

Whenmorethanoneuseremploysadatabaseapplication,theseisalwaysthechancethatoneuser'

sworkmayinterferewithother'

1.12Whatisthepurposeofthelargestdatabasesate-commercecompaniessuchasA?

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?

WhichofthefiveDBMSp

展开阅读全文