TEST BANK FOR DATABASE SYSTEMS DESIGN IMPLEMENTATION & MANAGEMENT 19TH EDITION CARLOS CORONEL STEVEN MORRIS VERIFIED ANSWERS ACTUAL UPDATED PRACTICE QUESTIONS HIGH YIELD STUDY GUIDE DATABASE SYSTEMS EXAM PREPARATION GRADED A+ STUDENT SUCCESS REV

TEST BANK FOR DATABASE
SYSTEMS DESIGN
IMPLEMENTATION & MANAGEMENT
19TH EDITION CARLOS CORONEL
STEVEN MORRIS 2026 2027
VERIFIED ANSWERS ACTUAL
UPDATED PRACTICE QUESTIONS
HIGH YIELD STUDY GUIDE
DATABASE SYSTEMS EXAM
PREPARATION GRADED A+
STUDENT SUCCESS REVIEW




dbms
bygshilp_dg



AC14/AT11

DatabasegManagementgSystems

TYPICALgQUESTIONSg&gANSWERS




, , , ,

,PARTg-I

OBJECTIVEgTYPEgQUESTIONS
EachgQuestiongcarriesg2gmarks.
Choosethegcorrectgorgthegbestgalternativegingthegfollowing:
Q.1

Whichgofgthegfollowinggrelationalgalgebragoperationsgdognotgrequiregthegparticipatinggtablesgtogbegu
nion-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

Theglanguagegthatgrequiresgagusergtogspecifygthegdatagtogbegretrievedgwithoutgspecifyinggexactlygh
owgtoggetgitgis
(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

Thegrulegthatgagvaluegofgagforeigngkeygmustgappeargasgagvaluegofgsomegspecificgtablegisgcalledga
(A)gReferentialgconstraint.
(B)gIndex.
(C)gIntegritygconstraint.
(D)gFunctionalgdependency.
Ans:g(A)gThegrulegthatgagvaluegofgagforeigngkeygmustgappeargasgagvaluegofgsomegspecificgtablegisgca
lledgagreferentialgconstraint.g(Referentialgintegritygconstraintgisgconcernedgwithgforeigngkey)

Q.9

ThegclausegingSQLgthatgspecifiesgthatgthegquerygresultgshouldgbegsortedgingascendinggorgdescendi
nggordergbasedgongthegvaluesgofgonegorgmoregcolumnsgisg(A)gView
(B)gOrdergby
(C)gGroupgby (D)gHaving
Ans:g(B)gThegclausegingSQLgthatgspecifiesgthatgthegquerygresultgshouldgbegsortedgingascendinggorgd
escendinggordergbasedgongthegvaluesgofgonegorgmoregcolumnsgisgORDERgBY.g(ORDERgBYgclaus
egisgusedgtogarrangegthegresultgofgthegSELECTgstatement)

Q.10

Whatgisgagdisjointglessgconstraint?
(A)gItgrequiresgthatgangentitygbelongsgtognogmoregthangoneglevelgentitygset.g(B)gThegsamegentitygma
ygbelonggtogmoregthangoneglevel.
(C)gThegdatabasegmustgcontaingangunmatchedgforeigngkeygvalue.g(D)gAngentitygcangbegjoinedgwithg
anothergentitygingthegsameglevelgentitygset.gAns:g(A)gDisjointglessgconstraintgrequiresgthatgangentityg
belongsgtognogmoregthangoneglevelgentitygset.g(Disjointglessgconstraintgmeansgthatgangentitygcangbe
,


agmembergofgatgmostgonegofgthegsubclassesgofgthegspecialization.)
g




Q.11

Accordinggtogtheglevelsgofgabstraction,gthegschemagatgthegintermediateglevelgisgcalledg(A)gLogicalgs
chema.




, , ,,