Test Bank for Modern Database Management 13th Edition by Hoffer, Ramesh, and Topi

TESTBANK
ji

,ModernDatabaseManagement, 13e(Hoffer)
ji ji ji ji




Chapter1 TheDatabaseEnvironmentandDevelopment Process ji j i ji ji ji ji ji




1) AccordingtoaMcKinseyGlobalInstituteReport,in2010alone,globalenterprisesstored more ji ji ji ji ji ji ji ji ji ji ji ji ji




than:
ji




A) 1terabyteofdata.
ji ji ji




B) 3gigabytesofdata.
ji ji ji




C) atleast 100petabytesofdata.
ji ji ji ji ji




D) morethan7billionexabytesofdata. ji ji ji ji ji ji




Answer: D
ji ji




LO: 1.1:Definekeyterms.
j i ji ji ji




Difficulty: Easy
ji ji




Classification: Concept
ji j i




AACSB: InformationTechnology j i ji




2) Databasemanagement involvesallofthefollowingEXCEPT: ji ji ji ji ji ji ji




A) collectingdata. ji




B) organizingdata. ji




C) designwebpages. ji ji




D) managingdata. ji




Answer: C
ji ji




LO: 1.1:Definekeyterms.
j i ji ji ji




Difficulty: Easy
ji ji




Classification: Concept
ji j i




AACSB: InformationTechnology j i ji




3) Adatabase isanorganizedcollectionof
ji ji ji ji ji ji relateddata. ji




A) logically
B) physically
C) loosely
D) badly
Answer:A
ji ji




LO: 1.1:Definekeyterms.
j i ji ji ji




Difficulty: Easy
ji ji




Classification: Concept
ji j i




AACSB: InformationTechnology j i ji




4) Legacysystems oftencontaindataof ji ji ji ji ji qualityand aregenerallyhostedon
ji ji ji ji ji .
A) poor;personalcomputers ji ji




B) excellent;mainframes ji




C) poor;mainframes ji




D) excellent;workgroupcomputers ji ji




Answer: C
ji ji




LO: 3.1:Definekeyterms.
ji ji ji ji

,5) Program-datadependenceiscausedby: ji ji ji ji




A) filedescriptionsbeingstoredineachdatabase application.
ji ji ji ji ji ji ji




B) datadescriptions beingstoredona server.
ji ji ji ji ji ji




C) datadescriptionsbeingwrittenintoprogramming code.
ji ji ji ji ji ji




D) datacohabitingwithprograms.
ji ji ji




Answer: A
ji ji




LO: 1.2:Nameseverallimitationsofconventionalfileprocessingsystems.
j i ji ji ji ji ji ji ji ji




Difficulty: Moderate
ji ji




Classification: Concept j i




AACSB: InformationTechnology j i ji




6) Becauseapplicationsareoftendeveloped independentlyinfileprocessingsystems: ji ji ji ji ji ji ji ji ji




A) thedataisalways non-redundant.
ji ji ji ji




B) unplannedduplicatedata filesaretheruleratherthantheexception. ji ji ji ji ji ji ji ji ji ji




C) datacanalways be shared withothers.
ji ji ji ji ji ji




D) thereisalargevolumeoffileI/O. ji ji ji ji ji ji ji




Answer: B
ji ji




LO: 1.2:Nameseverallimitationsofconventionalfileprocessingsystems.
j i ji ji ji ji ji ji ji ji




Difficulty: Moderate
ji ji




Classification: Concept j i




AACSB: InformationTechnology j i ji




7) Relationaldatabasesestablishtherelationshipsbetweenentitiesbymeansofcommonfields ji ji ji ji ji ji ji ji ji ji ji




included in a file called a(n):
ji ji ji ji ji ji




A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
ji ji




LO: 1.3:Explainatleast10advantagesofthedatabaseapproach,comparedtotraditionalfile
j i ji ji ji ji ji ji ji ji ji ji ji ji ji




processing.
ji




Difficulty: Moderate ji




Classification:Concept
ji ji




AACSB: InformationTechnology j i ji




8) A(n) isoftendevelopedbyidentifyingaformorreportthatauserneedsona regular ji ji ji ji ji ji ji ji ji ji ji ji ji ji ji




basis.
ji




A) enterpriseview ji




B) reportingdocument ji




C) userview ji




D) usersnapshot ji




Answer: C
ji ji




LO: 1.3:Explainatleast10advantagesofthedatabaseapproach,comparedtotraditionalfile
j i ji ji ji ji ji ji ji ji ji ji ji ji ji




processing.
ji

, 9) Agraphicalsystemused to capturethenatureand relationshipsamongdataiscalled a(n):
ji ji ji ji ji ji ji ji ji ji ji ji ji ji




A) XMLdatamodel. ji ji




B) hypertext graphic. ji




C) relationaldatabase. ji




D) datamodel. ji




Answer: D
ji ji




LO: 1.3:Explainatleast10advantagesofthedatabaseapproach,comparedtotraditionalfile processing.
j i ji ji ji ji ji ji ji ji ji ji ji ji ji ji




Difficulty: Moderate ji




Classification:Concept
ji ji




AACSB: InformationTechnology j i ji




10) Datathat describethe propertiesofother dataare:
ji ji ji ji ji ji ji ji




A) relationships.
B) logical.
C) physical.
D) metadata.
Answer: D
ji ji




LO: 1.3:Explainatleast10advantagesofthedatabaseapproach,comparedtotraditionalfile
j i ji ji ji ji ji ji ji ji ji ji ji ji ji




processing.
ji




Difficulty: Moderate ji




Classification:Concept
ji ji




AACSB: InformationTechnology j i ji




11) Metatdatatypicallydescribesallofthefollowing EXCEPT: ji ji ji ji ji ji ji




A) datadefinitions.ji




B) length.
C) allowable values. ji




D) locationondisk. ji ji




Answer: D
ji j i




LO: 1.3:Explainatleast10advantagesofthedatabaseapproach,comparedtotraditionalfile
j i ji ji ji ji ji ji ji ji ji ji ji ji ji




processing.
ji




Difficulty: Moderate ji




Classification:Concept
ji ji




AACSB: InformationTechnology j i ji




.