SQL+server+实用教程第三版试题有及答案

1BABCPrimaryD2SQLserverCAndfBldfCmdfDidf3CA#mybaseB-mybaseC$mybaseDmybase4CABCD5SQL(A)AALTERBCREATECUPDATEDINSERT6CABCD7BAmodecBmasterCmsdbDtempelb8Transalt-SQLCADDLBDMLCDCLDDQL9SQLServer2000AABCD10DASQLBSQLCSQLDSQL11[abc]%aDAbedefBa_bedCabc-eDa%a12BABCD13AABCD14SQLBADELETEBDROPCCLEARDREMORE15SQLBETWEEN20AND302030AA2030B2030C2030D203016AAUNIQUEBCOUNTCDISDINCTDUNION17BABCD18SQLServer2000(C)AMasterBMSdbCXscj//DModel19AABCD20AAORDERBYCOMPUTE,COMPUTRBYBORDERBYFROMCCOMPUTEORDERBYDORDERBYGROUPBY21BABCD22SQLDAPRMARYKEYBNOTNULLCFOREIGNKEYDFOREGNKEYREFERENCES````````23BADDLBCD24CABCD25LOCKSCABCD26BTABLE_NAME10Aselect*fromTABLE_NAMEwhererowcount=10BselectTOP10*fromTABLE_NAMECselectTOPof10*fromTABLE_NAMEDselectfromTABLE_NAMEwhererowcount=1027SQLserver2000CASQLserver\MicrosoftSQLserver\mssql\dataB*.mdf*.ldfCDABAB28XSDAselectfromstudentwhere!=NULLBselectfromstudentwhereNOTISNULLCselectfromstudentwhereNULLDselectfromstudentwhereISNOTNULL29BABJOINCDwhere30SQL800BABCD31SelectAAB&C||D|32XSSX(xh,xm,```)W3XMWHEREXMlikeBA-W-%B-%W-C-W-D-W%338CABCD34SQLserverAAINSERTBDNSERTVPDATECUPDATEDADD35CASUMBAVGCCOUNTDMAX36SelectCABCD37AAinnerjoinBleftouterjoinCcrossjoinDrightouterjoin38Transact_SQLAABeginEndBIfThenElseCDcaseDDoWhile1SQLserver2000/C/S2SQLserver___________Windows_______3SQLserver___________4SQLserver_________56SQLserver7SQL__--____/**/________8SQLserver___@@__________@_____9_____________1011___12__eim_eim__________13____________14SQLserver___mdf______ndf______ldf__15_____16SQL_rollback_____17SASystemAdmin_____SQLserver18SQLserver2000SQLserver__SQLServer_1920(sp_)21____________________________22Transact_SQL__DML_________DDL___________DCL_______23_________________________________24_____________25SQLserver_C__26SQLserver2000_________________27SQLserver2000_______28SQLserver2000__BEGIN___________END________29__GRANT____REVOKE___30Transact_SQL_BACKUP__RESTORE_31SQLserver2000_SET____SELECT_32___33___GO34SQLserver2000____Transact_SQL35SQLserver2000_MSSQLSERVER_36SQLserver___37SQLserver2000datetimesmalldatetime________________38SQLserver2000_bit__39SQLserver2000____40_________1SQLserver(sqlserver2000)2SQLserver312344SQLserver51.2.3.6SQLserverSADBODBOOUser7SQL891011T-SQL12SQLserver200012345DTS6SQLServerT-SQLT-SQL7SQLServer891011121314SQL15SQLServer