,CHAPTER 1: DATABASE SYSTEMS
m m m
1. Datamand minformation maremessentially mthemsamemthing.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mEasy REF: p.4
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: DatamversusmInformation
2. Datamprocessingmcan mbemasmsimplemasmorganizingmdatamto mrevealmpatterns.
a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mEasy REF: p.4
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: DatamversusmInformation
3. Datamismthemresultmof mprocessingmrawmfactsmto mrevealmitsmmeaning.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mEasy REF: p.4
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: DatamversusmInformation
4. When mdatamarementered minto mamformmand msaved,mthey maremplaced min mthemunderlyingmdatabase masmknowledge.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mModerate REF: p.4
NAT:m BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: DatamversusmInformation
5. Datamconstitute mthembuildingmblocksmof minformation.
a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mEasy REF: p.4
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: DatamversusmInformation
6. Metadatamdescribemthemdatamcharacteristicsmand mthemsetmofmrelationshipsmthatmlinksmthemdatamfoundmwithin
mthe mdatabase.
, a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mEasy REF: p.6
NAT: BUSPROG:mTechnology STATE: DISC:mInformation mTechnologies
KEY: Bloom's:mKnowledge TOP: IntroducingmthemDatabase
7. Themonly mway mto maccessmthemdatamin mamdatabase mismthrough mthemDBMS.
a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mModerate REF: p.6
NAT:m BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: IntroducingmthemDatabase
8. Database mprogrammingmlanguagesmreceivemallmapplicationmrequestsmandmtranslatemthemminto mthemcomplex moperati
onsmrequired mto mfulfillmthosemrequests.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mModerate REF: p.6
NAT:m BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: IntroducingmthemDatabase
9. ThemDBMSmrevealsmmuch mof mthemdatabase’sminternalmcomplexity mto mthemapplication mprogramsmand musers.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mModerate REF: p.6
NAT:m BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: IntroducingmthemDatabase
10. Onemdisadvantage mof mthemDBMSmismthatmitmincreasesmthemrisk mof mdatamsecurity mbreaches.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mEasy REF: p.7
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: IntroducingmthemDatabase
11. An moperationalmdatabase mismsometimesmreferred mto masman menterprise mdatabase.
a. True
b. False
, ANSWER:m False
PTS: 1 DIF: Difficulty:mEasy REF: p.9
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: IntroducingmthemDatabase
12. Amdatamwarehouse mcan mstoremdatamderived mfrommmany msources.
a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mEasy REF: p.9
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: IntroducingmthemDatabase
13. Themsamemdatammightmbemsimultaneously mstructured mand munstructured mdependingmon mthemintended mprocessing.
a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mModerate REF: p.9
NAT: BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY: Bloom's:mComprehension TOP: IntroducingmthemDatabase
14. Corporationsmusemonly mstructured mdata.
a. True
b. False
ANSWER:m False
mPTS: 1 DIF: Difficulty:mModerate REF: p.10
NAT:m BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: IntroducingmthemDatabase
15. Field mrefersmto mamcollection mof mrelated mrecords.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mEasy REF:
p.15 mNAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP:m Evolution mof mFilemSystemmDatamProcessing
16. Structuralmdependencemexistsmwhenmitmismpossiblemtommakemchangesmin mthemfilemstructuremwithoutmaffecting
mthe mapplication mprogram’s mability mto maccess mthe mdata.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mModerate REF:
p.19 mNAT:m BUSPROG:mAnalytic STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: Problemsmwith mFilemSystemmDatamProcessing
17. Datamanomalymismdefinedmasmthemcondition min mwhich mallmofmthemdataminmthemdatabasemaremconsistentmwith mthe
mreal-mworld mevents mand mconditions.
m m m
1. Datamand minformation maremessentially mthemsamemthing.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mEasy REF: p.4
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: DatamversusmInformation
2. Datamprocessingmcan mbemasmsimplemasmorganizingmdatamto mrevealmpatterns.
a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mEasy REF: p.4
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: DatamversusmInformation
3. Datamismthemresultmof mprocessingmrawmfactsmto mrevealmitsmmeaning.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mEasy REF: p.4
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: DatamversusmInformation
4. When mdatamarementered minto mamformmand msaved,mthey maremplaced min mthemunderlyingmdatabase masmknowledge.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mModerate REF: p.4
NAT:m BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: DatamversusmInformation
5. Datamconstitute mthembuildingmblocksmof minformation.
a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mEasy REF: p.4
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: DatamversusmInformation
6. Metadatamdescribemthemdatamcharacteristicsmand mthemsetmofmrelationshipsmthatmlinksmthemdatamfoundmwithin
mthe mdatabase.
, a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mEasy REF: p.6
NAT: BUSPROG:mTechnology STATE: DISC:mInformation mTechnologies
KEY: Bloom's:mKnowledge TOP: IntroducingmthemDatabase
7. Themonly mway mto maccessmthemdatamin mamdatabase mismthrough mthemDBMS.
a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mModerate REF: p.6
NAT:m BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: IntroducingmthemDatabase
8. Database mprogrammingmlanguagesmreceivemallmapplicationmrequestsmandmtranslatemthemminto mthemcomplex moperati
onsmrequired mto mfulfillmthosemrequests.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mModerate REF: p.6
NAT:m BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: IntroducingmthemDatabase
9. ThemDBMSmrevealsmmuch mof mthemdatabase’sminternalmcomplexity mto mthemapplication mprogramsmand musers.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mModerate REF: p.6
NAT:m BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: IntroducingmthemDatabase
10. Onemdisadvantage mof mthemDBMSmismthatmitmincreasesmthemrisk mof mdatamsecurity mbreaches.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mEasy REF: p.7
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: IntroducingmthemDatabase
11. An moperationalmdatabase mismsometimesmreferred mto masman menterprise mdatabase.
a. True
b. False
, ANSWER:m False
PTS: 1 DIF: Difficulty:mEasy REF: p.9
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: IntroducingmthemDatabase
12. Amdatamwarehouse mcan mstoremdatamderived mfrommmany msources.
a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mEasy REF: p.9
NAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP: IntroducingmthemDatabase
13. Themsamemdatammightmbemsimultaneously mstructured mand munstructured mdependingmon mthemintended mprocessing.
a. True
b. False
ANSWER:m True
PTS: 1 DIF: Difficulty:mModerate REF: p.9
NAT: BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY: Bloom's:mComprehension TOP: IntroducingmthemDatabase
14. Corporationsmusemonly mstructured mdata.
a. True
b. False
ANSWER:m False
mPTS: 1 DIF: Difficulty:mModerate REF: p.10
NAT:m BUSPROG:mAnalytic STATE: DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: IntroducingmthemDatabase
15. Field mrefersmto mamcollection mof mrelated mrecords.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mEasy REF:
p.15 mNAT:m BUSPROG:mTechnology STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mKnowledge TOP:m Evolution mof mFilemSystemmDatamProcessing
16. Structuralmdependencemexistsmwhenmitmismpossiblemtommakemchangesmin mthemfilemstructuremwithoutmaffecting
mthe mapplication mprogram’s mability mto maccess mthe mdata.
a. True
b. False
ANSWER:m False
PTS: 1 DIF: Difficulty:mModerate REF:
p.19 mNAT:m BUSPROG:mAnalytic STATE:m DISC:mInformation mTechnologies
KEY:m Bloom's:mComprehension TOP: Problemsmwith mFilemSystemmDatamProcessing
17. Datamanomalymismdefinedmasmthemcondition min mwhich mallmofmthemdataminmthemdatabasemaremconsistentmwith mthe
mreal-mworld mevents mand mconditions.