1、10任時(shí)間：2013-11-5 5，6地點(diǎn)機(jī)房一、10任時(shí)間：2013-11-5 5，6地點(diǎn)機(jī)房一、1tblEmployeesNameHireDate，下面哪些語句能完成該功能？SELECTName,HireDateFROMSELECTName,HireDateFROMWHEREHireDate=2001-01-01OR2001-12-SELECTName,HireDateFROMWHEREHireDateN2000-12-31AND2002-01-SELECTName,HireDateFROMtblEmployees WHEREDATEPART(yy,HireDate)=2001（2）SQL

2、Server2005CREATETABLE( 訂單代IDENTITY(1,1)PRIMARYnotnot null,datetime not null,notvarchar(200) )0，下面哪條語句能夠準(zhǔn)確地完成該任務(wù)？SELECTFROM 訂單表ORDERBYSELECTFROM 訂單表ORDERBYSELECTFROM 訂單表ORDERBYDESCSELECTFROM 訂單表ORDERBYDESC,（3）SQLServer2005CREATE)CREATE( 訂單號(hào) )IDENTITY(10001,1)PRIMARYKEY varchar(20) NOTIDENTITY(1,1)PRI

3、MARYNOT（3）SQLServer2005CREATE)CREATE( 訂單號(hào) )IDENTITY(10001,1)PRIMARYKEY varchar(20) NOTIDENTITY(1,1)PRIMARYNOTASaLEFTOUTERJOINASa.bWHEREb.ANDIN(SELECTMAXFROMASaLEFTOUTERJOINASa.bANDbGROUPBYa.雇員代號(hào),aASaINNERJOINASb a.雇員代號(hào) = b.雇員代號(hào)WHEREb.GROUPBYa.雇員代號(hào),aSELECTa.雇員代號(hào),a.雇FROMASa ONa.WHEREb.INNERJOINAS=(SEL

4、ECTMAXFROMAND（4）SQLServer2005CREATE( 訂單號(hào) )IDENTITY(100001,1)PRIMARYNOT TOMSalaryEmployeesBonusPercentageSELECTTomdb_datareader 數(shù)據(jù)庫角色（1）SQLServer2005CREATETABLEnullPRIMARYnot部門名稱 )CREATE nullPRIMARYvarchar(20) D. 添加Tom到sadmin數(shù)據(jù)庫角2DELETEFROMWHEREDATEADD(YY,3,GETDATEDELETEFROMWHEREDATEADD(YY,3,GETDATE(

5、)DELETEFROMWHEREGETDATE()DELETEFROMWHEREGETDATE()ORDER TOP DEFAULTUNIQUECHECKFOREIGNKEYCREATETABLE( 學(xué)PRIMARYKEYvarchar(20) NOT號(hào)碼 varchar(30) NOTNULL,出生日期 datetime NULL,系號(hào) char(2) NOT NULL)UNIQUEUNIQUEPRIMARYKEY PRIMARYKEY )CREATETABLEPK_WorksPRIMARYKEYFK_EmployeesFOREIGNKEYONDELETEFK_DepartmentsFORE

6、IGNKEY)（2）小王是一位健康護(hù)理計(jì)劃)CREATETABLEPK_WorksPRIMARYKEYFK_EmployeesFOREIGNKEYONDELETEFK_DepartmentsFOREIGNKEY)（2）小王是一位健康護(hù)理計(jì)劃的數(shù)據(jù)庫管理員。使用下面語句創(chuàng)建 CREATETABLEnsIDENTITY(100,2)NOTNULLNOTNULL NOTNULL ,city varchar (255) NULL , evarchar(255)NULLtal_codevarchar(7) co_paymoneyNOTNULL,phys_co_payDEFAULT)（NY（WA的（3）在

7、數(shù)據(jù)庫中應(yīng)該將哪種約束添加到 Country 字段中，以確保小王CREATETABLE( notnullPRIMARYvarchar(20) notCREATETABLE( StudID notnull PRIMARYKEY, not null,not學(xué)生信息表 tblStudInfo 的列 DeptID ，用來存放學(xué)生所在系的代號(hào)。該列系信息表 均成績，zcjzcjpj （6）仔細(xì)閱讀以下兩個(gè)數(shù)據(jù)表，假設(shè)它們都是創(chuàng)建在數(shù)據(jù)庫friends bh,xm,nl,zwxm gl 3 gongzuo表里所有dw gl2二、實(shí)驗(yàn)結(jié)1120 6230 7380 6420 55not學(xué)生信息表 tblSt

8、udInfo 的列 DeptID ，用來存放學(xué)生所在系的代號(hào)。該列系信息表 均成績，zcjzcjpj （6）仔細(xì)閱讀以下兩個(gè)數(shù)據(jù)表，假設(shè)它們都是創(chuàng)建在數(shù)據(jù)庫friends bh,xm,nl,zwxm gl 3 gongzuo表里所有dw gl2二、實(shí)驗(yàn)結(jié)1120 6230 7380 6420 5540 361 271 187 2920 450 51可男2男3男4男5女6令女7女長8女9女剛男2三、實(shí)驗(yàn)思1（1）D 2selectfromWHEREnot(select*fromwhere not(select*fromwhereand2三、實(shí)驗(yàn)思1（1）D 2selectfromWHEREnot(select*fromwhere not(select*fromwhereand)SELECTFROM WHERENOT(SELECT*FROM WHERENOT(SELECT 部門號(hào) FROM 任職表 WHEREand 雇員表.雇員)WHERE e= NYOR e= WAOR e =WHERE ein(NY,WA,VA,ALTER ADD (DeptID) Use table (,as as )use CreateALTER ADD (DeptID) Use table (,as as )use Create view aaa Select bh,xm,nl,zw where zwl