数据库应用技术在线作业aApplication of database technologyonline operation aWord格式文档下载.docx

数据库应用技术在线作业aApplication of database technologyonline operation aWord格式文档下载.docx

《数据库应用技术在线作业aApplication of database technologyonline operation aWord格式文档下载.docx》由会员分享，可在线阅读，更多相关《数据库应用技术在线作业aApplication of database technologyonline operation aWord格式文档下载.docx（8页珍藏版）》请在冰豆网上搜索。

E-Rdiagramsprovidemethodsforrepresentingentities,attributes,andconnections,wheretheentitytypeis（）.

Ellipse

diamond

rectangle

Undirectededge

rectangle

Knowledgepoint:

1.1.4datamodel

Three

Thephysicalstructureandstoragepatternofthedataaredescribed.

Pattern

Subpattern

Externalmode

Internalmodel

internalmodel

thearchitectureof1.1.5databasesystem

Four

Inrelationaldatabases,theconstraintsthatcannotbeusedtorefertotuplesthatarenotpresentinthemaintablefromthetableare（）.

Defaultconstraint

Referentialintegrityrules

Entityintegrityrules

Uniquenessconstraint

Useranswers:

referentialintegrityrules

1.2.1relationmodel

Five

X=Y,whichiscalledtrivialfunctionaldependencywhenthefollowingconditionsareestablished.

XY=f

XY

YX

Answer:

YXusers

1.2.2relationaldatatheory

Six

ThetransformationfromE-Rmodeltorelationaldatabaseindatabasedesigniscarriedoutin（）phase.

conceptualdesign

physicaldesign

logicdesign

requirementanalysis

LogicDesign

thetaskof1.3.2requirementanalysis

Seven

WhentheE-Rmodelistransformedintoarelationaldatabase,thecodeoftherelationalschemaofthem:

nconnectiontransformationshouldbe（）.

ThecombinationofMandNentitycodes

Reselectotherattributes

CodeofNendentity

CodeofMendentity

combinationofMandNentitycodes

logicalstructuredesignof1.3.4

Eight

FortheauthenticationmodesupportedbySQLServer2005,thefollowingdescriptionisincorrect（）.

MixedverificationmodemeansthatusersmustbeauthenticatedbyWindowsandauthenticatedbySQLServer2005,sotheycanbesuccessfullyconnectedtotheSQLServerdatabaseserver

WindowsauthenticationmodereferstotheWindowsaccountorusergroupasalegitimateuserofSQLServer2005,throughWindowsverificationcansuccessfullyconnecttotheSQLServer2005databaseserver

SQLServerauthenticationmechanismreferstotheusermustprovidelegitimateSQLServerloginaccountandpassword,throughtheSQLServersecuritysystemverification,inordertosuccessfullyconnecttotheSQLServerdatabaseserver

Mixedmodereferstothesystemsettingsforthismode,theusercanconnecttotheSQLServerdatabaseservertoWindowsthroughidentityauthenticationmode,canalsotakeSQLServer2005identitythroughtheauthenticationmodetoconnectSQLServerdatabaseserver

mixedverificationmodemeansthattheusermustbeauthenticatedbyWindowsandauthenticatedbySQLServer2005,andthencanbesuccessfullyconnectedtotheSQLServerdatabaseserver

thesecurityof2.3SQLServer2005

Nine

EachinstallationofSQLServer2005onacomputeriscalledaninstance.Thefollowingdescriptionofaninstanceisincorrect.

Thenameofthedefaultinstanceisunique,identifiedbythecomputernetworknamethatrunsit.

Thereisonlyonedefaultinstanceonacomputer

WhenyouinstallSQLServer2005onacomputerthatdoesnotinstallaSQLServer,youcannotinstallanamedinstance

Multipleinstancescanbeinstalledonacomputer

whenyouinstallSQLServer2005onacomputerthatdoesnotinstallSQLServer,youcannotinstallanamedinstance

2.2.2installSQLServer2005

Ten

AttributeassignmentinSQLServer2005doesnotinclude（）.

Loginconfiguration

Advancedconfiguration

Serviceconfiguration

Clientconfiguration

clientconfiguration

2.4SQLServer2005tools

Eleven

Theinformationstoredinthesystemdatabasetempdbis（）.

TemporarytablesandotherstoresneedtoprovidestoragespacetosharetheworkspaceusedbyalldatabasesinSQLServer

SystemconfigurationinformationandSQLServerinitializationinformation,etc.

Createatemplatefileforalluserdatabases

SQLServerallsysteminformation,suchaslogininformation,userdatabaseinformation,etc.

temporarytablesandotherstorageneededtoprovidestoragespaceforalldatabasessharedinSQLServer

basicknowledgeandconceptsof3.1SQLServer

Twelve

BeforecreatingtheSQLServer2005database,youhavetodoitfirst.

Viewdatabaseinformation

Designofdatabasestructure

Deletingandseparatingdatabases

Modifythepropertiesofthedatabase

thedesignofdatabasestructure

3.2createdatabase

Thirteen

AftertheestablishmentofSQLServer2005database,theoperationcannotbedone.

Deletedatabase

Changedatabasename

Increasedatabasecapacity

Changetheownerofthedatabase

changetheownerofthedatabase

3.3managedatabase

Fourteen

InthedesignoftablesinSQLServerdatabase,itisnotnecessarytoconsider（）.

Themaintenancemechanismofdatabaseintegrity

Whatarethedatainthetable?

Makesurethetablesarethere

Whatarethetypesandconstraintsofdata?

maintenancemechanismofdatabaseintegrity

anoverviewofthe4.1SQLServertable

Fifteen

Whencreatingtablesinanobjectexplorer,theoperationofdefiningtablestructuresdoesnotinclude（）.

Limitsofinputvaluesforrestrictedcolumns

Determiningthelengthofacolumn

Fieldnamesforcolumns

Determineswhethercolumndatacanbeempty

limittherangeofinputvaluesforcolumns

4.2.1createsatablewithobjectExplorer

Sixteen

WhenyoucreateatablewiththeCREATETABLEstatement,thekeywordforbuildingaforeignkeyis（）.

CONSTRAINT...REFERENCES

PRIMARYKEY

NOTNULL

DEFALTE

CONSTRAINT...REFERENCES

4.2.2createstableswithT-SQLstatements

Seventeen

WhenthetablestructureismodifiedwiththeALTERTABLEstatement,thekeytodeletethecolumnis（）.

DROPCOLUMN

ADD

ALTERCOLUMN

DROPCONSTRAINT

DROPCOLUMN

4.3modifytablestructure

Eighteen

Themostcommonlyusedandnecessaryoperationintherelationaltabledataoperationis（）.

query

modify

delete

increase

query

5.1relationaloperations

Nineteen

Inrelationalgebra,thechoiceofoperationis（）.

Comparisonoperator

Specialrelationaloperator

Logicaloperator

Traditionalsetoperator

specialrelationaloperators

5.1.2relationalalgebra

Twenty

Thefollowingstatementsareincorrecttoupdate,deleteorinsertdata.

ASQLstatementcanmodifymultipletuplesinatable

ASQLstatementcaninsertmultipletuplesintoatable

ASQLstatementcanonlyupdateatable

ASQLstatementcanbeusedtoupdatemultipletables

aSQLstatementcanupdatemultipletables

5.2add,modifyanddeletedata