数据库原理英文选择题.docx

数据库原理英文选择题

1.WhichofthefollowingisNOTacharacteristicofarelationaldatabase?

A.Dataisstoredintables

B.DataisaccessedthroughSQL

C.Dataredundancyisencouraged

D.Dataintegrityismaintained

2.Whatistheprimaryfunctionofaprimarykeyinadatabasetable?

A.Toensuredatauniqueness

B.Toestablishrelationshipsbetweentables

C.Toprovideameansofdataencryption

D.Toimprovequeryperformance

3.Inarelationaldatabase,whichofthefollowingrepresentsarelationshipbetweentwotables?

A.Primarykey

B.Foreignkey

C.Index

D.Trigger

4.WhichofthefollowingSQLstatementsisusedtoretrievedatafromadatabase?

A.SELECT

B.INSERT

C.UPDATE

D.DELETE

5.Whatisthepurposeofnormalizationindatabasedesign?

A.Toimprovedataredundancy

B.Toeliminatedataanomalies

C.Toincreasedatastoragespace

D.Todecreasequeryperformance

A.Aprimarykeyconsistingofasinglecolumn

B.Aforeignkeyreferencingaprimarykey

C.Aprimarykeyconsistingofmultiplecolumns

D.Auniquekeythatallowsnullvalues

7.InSQL,whatisthedifferencebetweenaWHEREclauseandaHAVINGclause?

A.WHEREclausefiltersrowsbeforegrouping,whileHAVINGclausefiltersgroupsaftergrouping

B.WHEREclauseisusedwithSELECTstatements,whileHAVINGclauseisusedwithUPDATEstatements

C.WHEREclauseisusedtosortdata,whileHAVINGclauseisusedtofilterdata

D.WHEREclauseisusedwithJOINoperations,whileHAVINGclauseisusedwithsubqueries

A.CREATETABLE

B.ALTERTABLE

C.DROPTABLE

D.SELECTTABLE

9.Whatisthepurposeofanindexinadatabase?

A.Toimprovedataredundancy

B.Toenhancedatasecurity

C.Tospeedupqueryexecution

D.Toreducedataintegrity

10.WhichofthefollowingisNOTatypeofdatabaseconstraint?

A.PRIMARYKEY

B.FOREIGNKEY

C.UNIQUE

D.VIEW

数据库原理英文选择题（续）

11.Whende