Test Bank for Database Concepts, 10th edition by David M. Kroenke.pdf

,DOWNLOAD THE Test Bank for Database Concepts 8th Edition Kroenke
p p p p p p p p p




DatabasepConcepts,p8ep(Kroenke)p
Chapterp2p ThepRelationalpModel

1) Apkeypmustpbepunique.
Answer:p FALSE
Diff:p1 PagepRef:p74
AACSB:p InformationpTechnology
ChapterpObj:p LearnpbasicprelationalpterminologypClassification
:p Concept

2) Ensuringpthatpeverypvaluepofpapforeignpkeypmatchespapvaluepofpthepcorrespondingpprimarypkeypi
spanpexamplepofpapreferentialpintegritypconstraint.
Answer:p TRUE
Diff:p1 PagepRef:p80
AACSB:p InformationpTechnology
ChapterpObj:p LearnpbasicprelationalpterminologypClassification
:p Concept

3) Apdoubleparrowpnotation,pAp→→pB,pispusedptopindicatepapmultivaluedpdependency.p
Answer:p TRUE
Diff:p2 PagepRef:p96
AACSB:p InformationpTechnology
ChapterpObj:p LearnpbasicprelationalpterminologypClassification
:p Concept

4) MicrosoftpAccesspformspcanponlypcontainpdatapfromponeptable.p
Answer:p FALSE
Diff:p1 PagepRef:p115
AACSB:p InformationpTechnology
ChapterpObj:p LearnpbasicprelationalpterminologypClassification
:p Concept

5) Whichpofpthepfollowingptermspispsynonymouspwithp"tuple"?
A) Attribute
B) Table
C) Field
D) Row
E) Relation
pAnswer:p D

Diff:p1 PagepRef:p73
AACSB:p InformationpTechnology
ChapterpObj:p LearnpbasicprelationalpterminologypClassification
:p Concept




1
Copyrightp©p2018pPearsonpEducation,pInc.
mynursytest.store

,DOWNLOAD THE Test Bank for Database Concepts 8th Edition Kroenke
p p p p p p p p p




6) Whichpofpthepfollowingpispnotptruepaboutpnullpvalues?
A) Apnullpvaluepcanpmeanpthatpthepvaluepispunknown.
B) Apnullpvaluepispambiguous.
C) Apnullpvaluepcanpmeanpthatpthepvaluepispknownptopbepblank.
D) Apnullpvaluepcanpmeanpthatpnopvaluepforpthepfieldpispappropriate.
E) Nullpvaluespcannotpbepavoided.p
Answer:p E
Diff:p2 PagepRef:p83-
84pAACSB:p InformationpTechnolo
gy
ChapterpObj:p LearnpbasicprelationalpterminologypClassification
:p Concept

7) Explainptheptermsprelation,ptuple,pandpattribute.
Answer:p Theptermsprelation,ptuple,pandpattributeparepusedpprimarilypbypdatabaseptheoreticians.pThe
septermsparepsynonymouspwithptheptermsptable,prow,pandpcolumn,prespectively,pinpregardsptopaprelati
onalpdatabase.pTheyparepalsopequivalentptoptheptermspfile,precord,pandpfield,pwhichptendptopbepusedpb
ypmanyptraditionalpdatapprocessingpprofessionals.
Diff:p1 PagepRef:p73
AACSB:p InformationpTechnology
ChapterpObj:p LearnpbasicprelationalpterminologypClassification
:p Concept

8) Explainptheppossiblepinterpretationspofpapnullpvalue.
Answer:p Thepproblempwithpallowingpnullpvaluespinpaptablepispthatpthepnullpvaluepispopenptopthreepdiff
erentpinterpretations.pFirst,papnullpvaluepinpapfieldpmaypmeanpthatpnopvaluepispappropriatepforpthepfiel
dpforpthepgivenprecord.pSecond,papnullpvaluepmaypmeanpthatpthepvaluepofpthatpfieldpispknownptopbepbla
nkpforpthepgivenprecord.pThird,papnullpvaluepmaypmeanpthatpthepvaluepofpthatpfieldpispnotpknownpforpt
hepgivenprecord.
Diff:p1 PagepRef:p83-
84pAACSB:p InformationpTechnolo
gy
ChapterpObj:p LearnpbasicprelationalpterminologypClassification
:p Concept

9) Whileptheprelationalpmodelpforpdatabasespappearsptopholdpmuchppromise,pfewpcommercialp
databasesphavepimplementedpit.
Answer:p FALSE
Diff:p1 PagepRef:p70
AACSB:p InformationpTechnology
ChapterpObj:p LearnpthepconceptualpfoundationpofptheprelationalpmodelpClassific
ation:p Concept

10) Everypcellpinpaprelationpcanpholdponlypapsinglepvalue.p
Answer:p TRUE
Diff:p1 PagepRef:p71
AACSB:p InformationpTechnology
2
Copyrightp©p2018pPearsonpEducation,pInc.
mynursytest.store

, ChapterpObj:p LearnpthepconceptualpfoundationpofptheprelationalpmodelpClassific
ation:p Concept




3
Copyrightp©p2018pPearsonpEducation,pInc.
mynursytest.store