數(shù)據(jù)庫原理英文選擇題

數(shù)據(jù)庫原理英文選擇題1.WhichofthefollowingisNOTacharacteristicofarelationaldatabase?A.DataisstoredintablesB.DataisaccessedthroughSQLC.DataredundancyisencouragedD.Dataintegrityismaintained2.Whatistheprimaryfunctionofaprimarykeyinadatabasetable?A.ToensuredatauniquenessB.ToestablishrelationshipsbetweentablesC.ToprovideameansofdataencryptionD.Toimprovequeryperformance3.Inarelationaldatabase,whichofthefollowingrepresentsarelationshipbetweentwotables?A.PrimarykeyB.ForeignkeyC.IndexD.Trigger4.WhichofthefollowingSQLstatementsisusedtoretrievedatafromadatabase?A.SELECTB.INSERTC.UPDATED.DELETE5.Whatisthepurposeofnormalizationindatabasedesign?A.ToimprovedataredundancyB.ToeliminatedataanomaliesC.ToincreasedatastoragespaceD.TodecreasequeryperformanceA.AprimarykeyconsistingofasinglecolumnB.AforeignkeyreferencingaprimarykeyC.AprimarykeyconsistingofmultiplecolumnsD.Auniquekeythatallowsnullvalues7.InSQL,whatisthedifferencebetweenaWHEREclauseandaHAVINGclause?A.WHEREclausefiltersrowsbeforegrouping,whileHAVINGclausefiltersgroupsaftergroupingB.WHEREclauseisusedwithSELECTstatements,whileHAVINGclauseisusedwithUPDATEstatementsC.WHEREclauseisusedtosortdata,whileHAVINGclauseisusedtofilterdataD.WHEREclauseisusedwithJOINoperations,whileHAVINGclauseisusedwithsubqueriesA.CREATETABLEB.ALTERTABLEC.DROPTABLED.SELECTTABLE9.Whatisthepurposeofanindexinadatabase?A.ToimprovedataredundancyB.ToenhancedatasecurityC.TospeedupqueryexecutionD.Toreducedataintegrity10.WhichofthefollowingisNOTatypeofdatabaseconstraint?A.PRIMARYKEYB.FOREIGNKEYC.UNIQUED.VIEW數(shù)據(jù)庫原理英文選擇題（續(xù)）11.Whendesigningadatabase,whichofthefollowingisakeyprincipletoensuredataconsistency?A.DataduplicationB.DataisolationC.DataabstractionD.Datanormalization12.Inadatabase,whatisthetermusedtodescribetheprocessofconvertingaqueryintoanexecutionplan?A.ParsingB.OptimizationC.CompilationD.Execution13.WhichofthefollowingSQLstatementsisusedtomodifyexistingdatainadatabasetable?A.SELECTB.INSERTC.UPDATED.DELETE14.Whatisthepurposeofatransactioninadatabasesystem?A.TostoredatapermanentlyB.ToensuredataconsistencyC.ToimprovequeryperformanceD.Tocreatenewtables15.Whichofthefollowingisatypeofjointhatreturnsrowswhenthereisatleastonematchinbothtables?A.INNERJOINB.LEFTJOINC.RIGHTJOIND.FULLOUTERJOIN16.Inadatabase,whatisthetermusedtodescribetheprocessofretrievingonlydistinct(unique)valuesfromacolumn?A.GROUPBYB.ORDERBYC.DISTINCTD.COUNTA.DROPTABLEB.DELETETABLEC.TRUNCATETABLED.ALTERTABLE18.Whatisthepurposeofastoredprocedureinadatabase?A.TostoretemporarydataB.ToperformaseriesofSQLoperationsC.TocreateanewdatabaseD.Todeleteadatabase19.WhichofthefollowingisacharacteristicofaNoSQLdatabase?A.ItusesafixedschemaB.ItisoptimizedforstructureddataC.ItishorizontallyscalableD.ItonlysupportsSQLasaquerylanguage20.Inadatabase,whatisthetermusedtodescribeacollectionofrelateddataorganizedinrowsandcolumns?A.TableB.ViewC.SchemaD.Database數(shù)據(jù)庫原理英文選擇題（續(xù)二）21.Whatisthedifferencebetweenadatabaseandadatawarehouse?A.Adatabasestorescurrentdata,whileadatawarehousestoreshistoricaldataB.Adatabaseisusedfortransactionalpurposes,whileadatawarehouseisusedforanalyticalpurposesC.Adatabaseissmallinsize,whileadatawarehouseislargeinsizeD.Adatabaseisstructured,whileadatawarehouseisunstructuredB.ToenforcereferentialintegrityC.ToformatdatabeforeitisdisplayedA.UnionB.JoinC.IntersectionD.Concatenation24.WhichofthefollowingSQLkeywordsisusedtolimitthenumberofrowsreturnedaquery?A.LIMITB.FETCHC.OFFSETD.ROWS25.Whatisthepurposeofadatabaseschema?A.TodefinethephysicalstorageofdataB.TodefinethelogicalstructureofadatabaseC.TodefinethesecuritypermissionsforusersD.Todefinethebackupandrecoveryprocedures26.WhichofthefollowingisNOTatypeofdatabasemanagementsystem(DBMS)?A.RelationalDBMSB.DocumentDBMSC.HierarchicalDBMSD.SequentialDBMS27.Inadatabase,whatisthetermusedtodescribeacollectionofdatathatistreatedasasingleunit?A.TupleB.AttributeC.RelationD.Entity28.WhichofthefollowingSQLstatementsisusedtocreateaviewinadatabase?A.CREATEVIEWB.ALTERVIEWC.DROPVIEWD.SELECTVIEW29.Whatisthepurposeofadatabaseindex?A.TosortdatainascendingordescendingorderB.ToimprovethespeedofdataretrievalC.ToenforceuniquenessofdataD.Tohidesensitivedatafromusers3