第二单元测试卷及答案英语.docVIP

第二单元测试卷及答案英语

一、填空题（每题2分，共20分）

1.Theprocessofconvertingrawdataintomeaningfulinformationisknownas________.

2.Inadatabase,a________isacollectionofrelateddatatables.

3.A________isalogicalgroupingofrelatedrecordswithinadatabasetable.

4.The________operatorisusedtoretrievedatafromadatabasethatmeetsaspecificcondition.

5.The________clauseisusedtosorttheresultsofaqueryinascendingorder.

6.A________isadatabaseobjectthatstoresdatainastructuredformat.

7.The________keywordisusedtoselectspecificcolumnsfromadatabasetable.

8.The________clauseisusedtolimitthenumberofrowsreturnedbyaquery.

9.A________isadatabaseobjectthatallowsuserstoaccessandmanipulatedata.

10.The________operatorisusedtocombinemultipleconditionsinaquery.

二、判断题（每题2分，共20分）

1.Adatabaseisacollectionofrelateddatatables.(True/False)

2.Adatabasetableisalogicalgroupingofrelatedrecords.(True/False)

3.TheSELECTstatementisusedtoretrievedatafromadatabase.(True/False)

4.TheWHEREclauseisusedtosorttheresultsofaquery.(True/False)

5.TheORDERBYclauseisusedtolimitthenumberofrowsreturnedbyaquery.(True/False)

6.Adatabaseindexisaphysicalstoragestructurethatimprovesqueryperformance.(True/False)

7.Adatabasetransactionisasequenceofdatabaseoperationsthatmustbecompletedtogether.(True/False)

8.Adatabaseconstraintisarulethatrestrictsthetypeofdatathatcanbestoredinadatabase.(True/False)

9.Adatabaseviewisavirtualtablethatisderivedfromoneormoredatabasetables.(True/False)

10.AdatabasetriggerisasetofSQLstatementsthatautomaticallyexecuteinresponsetocertainevents.(True/False)

三、选择题（每题2分，共20分）

1.Whichofthefollowingisatypeofdatabasedatabase?

a)Relationaldatabase

b)Networkdatabase

c)Hierarchicaldatabase

d)Alloftheabove

2.WhichSQLstatementisuse