Test Bank For Essentials of Database Management 1st Edition By Jeffrey A. Hoffer; Heikki Topi

Test Bank For Essentials of Database Management 1st Edition B
u u u u u u u u u


y Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman 978013
u u u u u u u u


3405682 Chapter 1-9 Complete Guide .
u u u u u




InutheuWeakutouStronguEntityuTypeuTransformation,uauweakuentityutypeuanduidentifyingurelationshipuar
euconverteduinto
a)uauM-Nurelationship.
b)umultipleuattributes
c)uaustrongu(notuweak)uentityutypeuanduregularu(non-identifying)urelationship.
d)utwouentityutypesuanduau1-Murelationship.u-
uANSWER:uc)uaustrongu(notuweak)uentityutypeuanduregularu(non-identifying)urelationship.



Forucomplexuproblemsuinvolvingujoinsuandugrouping,uyouucanudecomposeuauSELECTustatementuby
a)uexecutingugroupinguoperationsualoneuwithouturowuoperations.
b)uexecutingurowuoperationsualoneuwithoutugroupuoperations.
c)uexecutingurowuandugroupuoperationsutogetheruinutheusameustatement.
d)uexecutingugroupinguconditionsualoneuwithouturowuconditions.u-
uANSWER:ub)uexecutingurowuoperationsualoneuwithoutugroupuoperations.



Theupersistentupropertyuofudatabasesuindicates
a)uDatauresideuinuvolatileumemoryueraseduwhenuuseruinteractionucompletes.
b)uApplicationsuusinguaudatabaseuneverufail.
c)uDatauresideuonustableustorageuasutheulong-termumemoryuofuanuorganization.
d)uDataurequiresuappropriateuauthorizationuforumodificationuanduretrieval.u-
uANSWER:uc)uDatauresideuonustableustorageuasutheulong-termumemoryuofuanuorganization.



Theuinter-relatedupropertyuofudatabasesuindicates
a)uEntitiesuexistuindependentlyuwithouturelationshipsutouotheruentities.
b)uDatabasesumaintainuconnectionsuorurelationshipsuamonguentitiesutoustoreubusinessuinteractions.
c)Entitiesuexistuindependentlyuexceptuwhenurequireduforuapplications.
d)uDatabasesumaintainuconnectionsuamonguapplicationsuusinguentities.u-
uANSWER:ub)uDatabasesumaintainuconnectionsuorurelationshipsuamonguentitiesutoustoreubusinessuinter

actions.

Theusharedupropertyuofudatabasesuindicates
a)uDatabasesucanuhaveumultipleuusersuanduusesu(applications).
b)uEachuentityuinuaudatabaseucanuonlyuhaveuoneuactiveuuser.
c)uOrganizationsuforfeituaccessucontrolsutoudatabases.
d)uOrganizationsumustugrantuopenuaccessutoudatabases.u-
uANSWER:ua)uDatabasesucanuhaveumultipleuusersuanduusesu(applications).



WhatuisutheumeaninguofutheuSQLuacronym?
a)uSequel
b)uStructureduQuotientuLingo
c)uSuperuQueryuLanguage
d)uStructureduQueryuLanguageu-uANSWER:ud)uStructureduQueryuLanguage

IdentifyuimportantuDBMSufeatures.uMoreuthanuoneuansweruisupossible.
a)uNonuproceduraluaccess
b)uDataudefinition
c)uTransactionuprocessing
d)uWorkflowudefinitionu-uANSWER:ua)uNonuproceduraluaccess
b)uDataudefinition
c)uTransactionuprocessing

,Indicateutheuworkuemphasisuofuaudatabaseuadministrator.uMoreuthanuoneuansweruisupossible.
a)uFocuseduonuindividualudatabases
b)uPrimaryuroleuforudatauplanning
c)uRequiresuskillsuanduknowledgeuofuspecificuDBMSs
d)uPrimaryuroleuforusettingudataustandardsuforuanuorganizationu-
uANSWER:ua)uFocuseduonuindividualudatabases

c)uRequiresuskillsuanduknowledgeuofuspecificuDBMSs

Indicateutheuworkuemphasisuofuaudatauadministrator.uMoreuthanuoneuansweruisupossible.
a)uFocuseduonuindividualudatabases
b)uPrimaryuroleuforudatauplanning
c)uRequiresuskillsuanduknowledgeuofuspecificuDBMSs
d)uPrimaryuroleuforusettingudataustandardsuforuanuorganizationu-
uANSWER:ub)uPrimaryuroleuforudatauplanning

d)uPrimaryuroleuforusettingudataustandardsuforuanuorganization

WhatuisuanuenterpriseuDBMS?
a)uSupportsusmalluworkgroupsuwithumodestuperformanceuandureliabilityucapabilities
b)uResidesuinuaulargerusystem,ueitheruanuapplicationuoruaudeviceuwithulimitedutransactionuprocessing,um
emory,uprocessing,uandustorage.
c)uSupportsumissionucriticaluinformationusystemsuwithuhighuperformanceuforustorage,utransactionuproc
essing,uanduscalability.
d)uSupportsuserversuforuwebsiteuusageu-
uANSWER:uc)uSupportsumissionucriticaluinformationusystemsuwithuhighuperformanceuforustorage,utransa

ctionuprocessing,uanduscalability.

WhatuisuaudesktopuDBMS?
a)uSupportsusmalluworkgroupsuwithumodestuperformanceuandureliabilityucapabilities
b)uResidesuinuaulargerusystem,ueitheruanuapplicationuoruaudeviceuwithulimitedutransactionuprocessing,um
emory,uprocessing,uandustorage.
c)uSupportsumissionucriticaluinformationusystemsuwithuhighuperformanceuforustorage,utransactionuproc
essing,uanduscalability.
d)uSupportsuserversuforuwebsiteuusageu-
uANSWER:ua)uSupportsusmalluworkgroupsuwithumodestuperformanceuandureliabilityucapabilities



WhatuisuanuembeddeduDBMS?
a)uSupportsusmalluworkgroupsuwithumodestuperformanceuandureliabilityucapabilities
b)uResidesuinuaulargerusystem,ueitheruanuapplicationuoruaudeviceuwithulimitedutransactionuprocessing,um
emory,uprocessing,uandustorage.
c)uSupportsumissionucriticaluinformationusystemsuwithuhighuperformanceuforustorage,utransactionuproc
essing,uanduscalability.
d)uSupportsuserversuforuwebsiteuusageu-
uANSWER:ub)uResidesuinuaulargerusystem,ueitheruanuapplicationuoruaudeviceuwithulimitedutransactionupr

ocessing,umemory,uprocessing,uandustorage.

Languagesuforunon-proceduraludatabaseuaccessuhaveuexplicitustatementsuforulooping.
a)uTrue
b)uFalseu-uANSWER:ub)uFalse

WhatutoolsudouenterpriseuDBMSsuprovideuforunon-
proceduraluaccess?uMoreuthanuoneuansweruisupossible.
a)utheuSQLuSELECTustatement
b)uGraphicalutoolsusuchuasutheuQueryuBuilderutooluinutheuOracleuSQLuDeveloper
c)uDatabaseuprogrammingulanguagesucombininguauproceduralulanguageuwithunon-
proceduraludatabaseuaccess.
d)uTheuSQLuCREATEuTABLEustatementu-uANSWER:ua)utheuSQLuSELECTustatement

, b)uGraphicalutoolsusuchuasutheuQueryuBuilderutooluinutheuOracleuSQLuDeveloper
c)uDatabaseuprogrammingulanguagesucombininguauproceduralulanguageuwithunon-
proceduraludatabaseuaccess.

Whatuareutheubenefitsuofunon-proceduraludatabaseuaccess?uMoreuthanuoneuansweruisupossible.
a)uImproveusoftwareuproductivity
b)uImproveuaccessibilityuofudatabasesutouusersuwithoutuprogramminguskillsuandutraining.
c)uProvideusecurityuforudatabases
d)uProvideuprivacyuforudatabasesu-uANSWER:ua)uImproveusoftwareuproductivity
b)uImproveuaccessibilityuofudatabasesutouusersuwithoutuprogramminguskillsuandutraining.

Indicateureasonsuthatuorganizationsuuseudatabaseuprogrammingulanguages.uMoreuthanuoneureasonuisup
ossible.
a)uBatchuprocessinguespeciallyuforubigudatautasks
b)uCustomizationuespeciallyuforuecommerceuanduautomation
c)uDatauvisualizationuforubusinessuanalysts
d)uModularizationutouorganizeucodeuperformingudatabaseuretrievaluandumodificationu-
uANSWER:ua)uBatchuprocessinguespeciallyuforubigudatautasks

b)uCustomizationuespeciallyuforuecommerceuanduautomation
d)uModularizationutouorganizeucodeuperformingudatabaseuretrievaluandumodification

Whatustatementsuareutrueuaboutudatabaseutransactions.uMoreuthanuoneuansweruisupossible.
a)uSupportudailyuoperationsuofuanuorganization
b)uAudatabaseutransactionuconsistsuofuaucollectionuofudatabaseuoperationsutoureaduanduwriteutouaudata
base.
c)uAutransactionuconsistsuofuausingleudatabaseuoperation.
d)uAuDBMSureliablyuanduefficientlyuprocessesueachutransactionuasuoneuunituofuwork.u-
uANSWER:ua)uSupportudailyuoperationsuofuanuorganization

b)uAudatabaseutransactionuconsistsuofuaucollectionuofudatabaseuoperationsutoureaduanduwriteutouaudata
base.
d)uAuDBMSureliablyuanduefficientlyuprocessesueachutransactionuasuoneuunituofuwork.

Identifyuservicesuprovideduinudatabaseutransactionuprocessing.uMoreuthanuoneuansweruisupossible.
a)uOptimizeduprocessinguofuSQLuSELECTustatements
b)uControluofuinterferenceuamonguconcurrentuusers
c)uRecoveryufromufailuresuwithoutulossuofucompletedutransactions
d)uQueryumodificationu-uANSWER:ub)uControluofuinterferenceuamonguconcurrentuusers
c)uRecoveryufromufailuresuwithoutulossuofucompletedutransactions

Identifyudecisionumakingulevelsuwithuprimaryusupportubyudatauwarehouses.uMoreuthanuoneuansweruisup
ossible.
a)uLoweru(operational)udecisionsusuchuasuresolvinguaushippingudelay
b)uMiddleu(tactical)udecisionsusuchuasusalesuforecasting
c)uTopu(strategic)udecisionsusuchuasuidentifyingunewumarkets
d)uMicrou(subuoperational)udecisionsusuchuasupacketuroutingu-
uANSWER:ub)uMiddleu(tactical)udecisionsusuchuasusalesuforecasting

c)uTopu(strategic)udecisionsusuchuasuidentifyingunewumarkets

Identifyucharacteristicsuofudatauwarehouses.uMoreuthanuoneuansweruisupossible.
a)uPopulatedufromuoperationaludatabasesuanduexternaludatausources
b)uOptimizeduforuefficientuandureliableuprocessinguofulargeuvolumesuofudailyutransactions.
c)uTransformationsuanduintegrationsuperformedutousupportudecisionumaking
d)uOptimizeduforureportinguthatusummarizesulargeuamountsuofudatau-
uANSWER:ua)uPopulatedufromuoperationaludatabasesuanduexternaludatausources

c)uTransformationsuanduintegrationsuperformedutousupportudecisionumaking
d)uOptimizeduforureportinguthatusummarizesulargeuamountsuofudata