1单项选择题，（选择一个正确的答案，将相应的字母填入题内的括号中）1.数据库系统的核心是（B）。A）数据库B）数据库管理系统C）操作系统D）文件2.数据库(DB)、数据库系统(DBS)和数据库管理系统(DBMS)之间的关系是(A)。A）DBS包括DB和DBMSB）DBMS包括DB和DBSC）DB包括DBS和DBMSD）DBS就是DB，也就是DBMS3.在数据管理技术的发展过程中，数据独立性最高的是（A）阶段。A）数据库系统B）文件系统C）人工管理D）数据项管理4.数据库系统是由数据库、数据库管理系统（及其开发工具）、应用系统、（D）和用户构成。A）DBMSB）DBC）DBSD）DBA（数据库管理员）5.文字、图形、图像、声音、学生的档案记录、货物的运输情况等，这些都是（A）。A）DATAB）INFORMATIONC）DBD）其他6.（C）是长期存储在计算机内有序的、可共享的数据集合。A）DATAB）INFORMATION2CDBDDBS7.AADBMSBDBCDBSDDBA8.BADBMSBDBMSCD9.E-RCABCD10.CABCD11.AABCD12.3DIIIIII3AIIIBIICIIIIIDI13.CABCD14.CABCD15.AABCD16.DABCD17.CABCD418.CABCD19.SS#SNAMESEXAGECC#CNAMETEACHERSCS#C#GRADECOMPUTERDASBSCCCSSCDSCSC20.RABCSQLSELECTDISTINCTAFROMRWHEREB=17CAA(R)BB=17(R)CA(B=17(R))DB=17A(R)21.SELECTCASELECTBFROMCWHEREDGROUPBY22.BABCD23.C5ABCD24.SELECTAASELECTBFROMCWHEREDGROUPBY25.(B)ABCD26.AABCD27.AABCD28.AABCD629.AABCD30.BABCD31.RSRSDABCD32.AAE-RBCD33.CAPPSCHENBJ.MartinCE.F.CoddDw.H.Inmon734.CSQLServer2005ABCD35.MicrosoftSQLServer2005/BATCP/IPBT-SQLCCDASP36.AMicrosoftSQLServer2005SQLServerAMicrosoftSQLServerManagementStudioBSQLServerCAnalysisServicesDSQLServerBusinessIntelligenceDevelopmentStudio37.CAMasterBMsdbCModelDTempdb38.SQLServer2005DAMasterTempdbAdventureWorksMsdbResourceBMasterTempdbModelLibrarResourceCMasterNorthwindModelMsdbResourceDMasterTempdbModelMsdbResource39.D1234568A123B1234C12345D40.DMLDABCD41.CABCNULLDCHECK42.SQLCCreatetableCC#char(10)primarykeyCNchar(20)notnullCCintnullCAA005VC++6B005NULL6CNULLVC++6D005VC++NULL43.T-SQLNULLDANULLBNULL0CNULL0DNULL44.SQLServerBAintmoneycharBcharvarchartextCdatetimebinaryint9Dcharvarcharint45.FOREIGNKEYBABCD46.SQLSTUDENTCREATETABLESTUDENTNOchar4NOTNULLNAMEchar8NOTNULLSEXchar2AGEintSTUDENTBA103123B1031NULLNULLCNULL23D1031NULL2347.SQLBADELETEBDROPCCLEARDREMORVE48.SQLAADELETEBDROPCCLEARDREMORVE49.T-SQLBADELETETABLEBCREATETABLECADDTABLEDDROPTABLE50.ORDERBYCA10BCSELECTDISTINCTDORDERBY51.SQLBETWEEN20AND302030AA2030B2030C2030D302052.SQLBABCD53.SELETCOUNT(*)FROMhumanAA1B2C3D454.SQLDABCD55.test110BASELECT2*FROMtest1BSELECTTOP2*FROMtest1CSELECTPERCENT2*FROMtest111DSELECTPERCENT20*FROMtest156.CABCD57.SQLSELECTINSERTUPDATEDELETEAASELECTBINSERTCUPDATEDDELETE58.SELECT*BABCD59.SELECTname,sex,birthdayFROMhumanCA1B2C3D460.SQLBADELETEBDROPCCLEARDREMORVE61.SQLCAB12CD62.BABCDSELECT63.CASUM*BMAX*CCOUNT*DAVG*64.BAYEARBGETDATECCOUNTDSUM65.T-SQLAA--B/**/C**D&&66.BA--B/**/C////D////67.SQLServer2005BA@B@@13C**D&&68.DMLBAINSERTBUPDATECDELETEDSELECT69.bookpriceDMLDAFORBBEFORECAFTERDINSTEADOF70.AABCSQLServer2005DDLD71.DACREATEBDROPCSELECTDEXECUTE72.SQLSERVERBTransact-SQLABCD73.db_securityadminC14ABCD74.CABCD75.SQLServer20054BABCSQLServerD76.SQLServerWindowsBAWindowsNTBCD77.AABCD78.SQLServer2005BABCD1579.AABCD80.CABCD81.AABCD82.RR(A,B,C,D).SS(B,C,D),RSAA.4B.3C.7D.683.AA.B.C.D.84.RFRSFRCA.B.C.D.85.AA.B.C.D.86.FRSRFSB16A.B.C.D(p51)87.(C)A.B.C.D.88.SQLBA.B.C.D.89.SQLCA.UPDATEB.DELETEC.DROPD.INSERT90.WHEREGradeNOTBETWEEN80AND90AA.WHEREGrade<80ORGrade>90B.WHEREGrade>=80ORGrade<=90C.WHEREGrade>=80ANDGrade<=90D.WHEREGrade>80ANDGrade<9091.RS5060TRSTDA.110B.2500C.3600D.3000(P45)92.SQ...
