Test Bank - for Database Systems Design Implementation & Management 12th Edition by Carlos Coronel Steven Morris All Chapters Complete Guide A+

dbms
bygshilp_dg



AC14/AT11

DatabasegManagementgSystems

TYPICALgQUESTIONSg&gANSWERS
PARTg-I

OBJECTIVEgTYPEgQUESTIONS
EachgQuestiongcarriesg2gmarks.
Choosethegcorrectgorgthegbestgalternativegingthegfollowing:
Q.1

Whichgofgthegfollowinggrelationalgalgebragoperationsgdognotgrequiregthegparticipatinggtablesgtogb
egunion-compatible?
(A)gUnion
(B)gIntersection
(C)gDifference
(D)gJoin
Ans:g(D)

Q.2

Whichgofgthegfollowinggisgnotgagpropertygofgtransactions?
(A)gAtomicity
(B)gConcurrency
(C)gIsolation
(D)gDurability
Ans:g(B)

Q.3

RelationalgAlgebragdoesgnotghave
(A)gSelectiongoperator.
(C)gAggregationgoperators.

,(B)gProjectiongoperator.
(D)gDivisiongoperator.

Ans:g(Cg)
Q.4

Checkpointsgaregagpartgof
(A)gRecoverygmeasures.
(Cg)gConcurrencygmeasures.

(B)gSecuritygmeasures.
(D)gAuthorizationgmeasures.

Ans:g(A)
Q.5

Treegstructuresgaregusedgtogstoregdatagin
(A)gNetworkgmodel.
(B)gRelationalgmodel.
(C)gHierarchicalgmodel.
(D)gFilegbasedgsystem.
Ans:g(Cg)

Q.6

Theglanguagegthatgrequiresgagusergtogspecifygthegdatagtogbegretrievedgwithoutgspecifyinggexactl
yghowgtoggetgitgis
(A)gProceduralgDML.
(B)gNon-ProceduralgDML.
(C)gProceduralgDDL.
(D)gNon-ProceduralgDDL.
Ans:g(B)

Q.7

Precedenceggraphsghelpgtogfindga
1

,AC14/AT11

DatabasegManagementgSystems

(A)gSerializablegschedule.
(C)gDeadlockgfreegschedule.

(B)gRecoverablegschedule.
(D)gCascadelessgschedule.

Ans:g(A)
Q.8

Thegrulegthatgagvaluegofgagforeigngkeygmustgappeargasgagvaluegofgsomegspecificgtablegisgcalledg
a
(A)gReferentialgconstraint.
(B)gIndex.
(C)gIntegritygconstraint.
(D)gFunctionalgdependency.
Ans:g(A)gThegrulegthatgagvaluegofgagforeigngkeygmustgappeargasgagvaluegofgsomegspecificgtableg
isgcalledgagreferentialgconstraint.g(Referentialgintegritygconstraintgisgconcernedgwithgforeigngkey)

Q.9

ThegclausegingSQLgthatgspecifiesgthatgthegquerygresultgshouldgbegsortedgingascendinggorgdesce
ndinggordergbasedgongthegvaluesgofgonegorgmoregcolumnsgisg(A)gView
(B)gOrdergby
(C)gGroupgby
(D)gHaving
Ans:g(B)gThegclausegingSQLgthatgspecifiesgthatgthegquerygresultgshouldgbegsortedgingascendingg
orgdescendinggordergbasedgongthegvaluesgofgonegorgmoregcolumnsgisgORDERgBY.g(ORDERgB
YgclausegisgusedgtogarrangegthegresultgofgthegSELECTgstatement)

Q.10

Whatgisgagdisjointglessgconstraint?
(A)gItgrequiresgthatgangentitygbelongsgtognogmoregthangoneglevelgentitygset.g(B)gThegsamegentity
gmaygbelonggtogmoregthangoneglevel.

(C)gThegdatabasegmustgcontaingangunmatchedgforeigngkeygvalue.g(D)gAngentitygcangbegjoinedg
withganothergentitygingthegsameglevelgentitygset.gAns:g(A)gDisjointglessgconstraintgrequiresgthatga

, ngentitygbelongsgtognogmoregthangoneglevelgentitygset.g(Disjointglessgconstraintgmeansgthatgange
ntitygcangbegagmembergofgatgmostgonegofgthegsubclassesgofgthegspecialization.)

Q.11

Accordinggtogtheglevelsgofgabstraction,gthegschemagatgthegintermediateglevelgisgcalledg(A)gLogic
algschema.
(B)
Physicalgschema.
(C)gSubschema.
(D)
Supergschema.
Ans:gAccordinggtogtheglevelsgofgabstraction,gthegschemagatgthegintermediateglevelgisgcalledgcon
ceptualgschema.
(Note:gAllgthegoptionsggivengingthegquestiongaregwrong.)

Q.12

Itgisgangabstractiongthroughgwhichgrelationshipsgaregtreatedgasghigherglevelgentitiesg(A)gGenerali
zation.
(B)gSpecialization.
(C)gAggregation.
(D)gInheritance.
Ans:g(Cg)gItgisgangabstractiongthroughgwhichgrelationshipsgaregtreatedgasghigherglevelgentitiesgA
ggregation.g(IngERgdiagram,gaggregationgisgusedgtogrepresentgagrelationshipgasgangentitygset.)
2