SQL数据库考试试题(doc 13页).doc

1SQL(110)1. C A. B.C. D.2.SQL2000 D A. B.C. D.3.SQL Server4 C A. master B.modelC.pub D.msdb4. A ADBMS BDBCDBS DDBA5. SQL ( B )A. CREATE SCHEMA B.CREATE TABLEC.CREATE VIEW D.CREATE INDEX6.SQL BETWEEN 15 AND 351535( A )A. 1535B. 1535C. 1535D. 35157.( C )2A. SQLB. SQLC. SQLD. SQL8.MS SQL Server( D )A. sp_dbhelp B. sp_dbC. sp_help D. sp_helpdb9.SQL( A )A. DELETE B. DROPC. CLEAR D. REMOVE10.SQL C A. B. C. D. SQL 2(110)4. sql CA.mdf B.ldfC.tif D.ndf5. ( A )A. DDL B.DCLC.DML D.DBL8. SQL(A)ACREATE PROCEDURE BCREATE RULECCREATE DURE DCREATE FILE3SQL 3(110)2. A A B C3. B A BER C D5. SQL ( C )A. CREATE SCHEMA B.CREATE TABLEC.CREATE VIEW D.CREATE INDEX9. SQL( B )A. DELETE B. DROP C. CLEAR D. REMOVE(110)1 D ADBMS BDBCDBS DDBA2 A ADBMS BDBSCDBA DDB3 D A BC D4 D 4A BC D5 C A BC D6 C A BC D7SQL Server 2000 D ADELETE BSELECTCUPDATE DDROP8SELECT ASCIIAlklk D A48 B32C90 D65(110)1 D ADATA BINFORMATION CDB DDBS2 A A B C D4.1NF D ABC5D5SQL Server 2000 B A. USE BSELECT CUPDATE DDROP6SQL Server 2000 C AUSE BSELECT CUPDATE DDROP7SQL Server 2000 A Asum Bj Csum D4kk8 D ASQL ServerBSQL ServerCDSQL Server9 B AYEAR BGETDATE CCOUNT DSUM10SQL D ACTEATE BREVOKE CSELECT DGRANTSQL 6(110)1SQL Server A A. master B. modelC. tempdb D. msdb2 C A. Myvar B. My varC. Myvar D. My var63 A A. B.C. D.5sql CA.mdf B.ldfC.dbf D.ndf6SQL SERVER B Transact-SQLA. B.C. D.8( A )A. B. C. D. 9E-R( D)A. B. C. D. 10T-SQLC AUPDATE B. INSERTE. ALTER D. MODIFYSQL 7(110)72. ( D)A. B.C. D.4. SQL Server model( B )A B. C D. 5.( C )A. B.C. D.6. (C )A. B.C. D.8 E-R( A )A. B. C. D. 9. sql CA.mdf B.ldfC.dbf D.ndf10SQL( A )A. GRANT B. REVOKEC. OPTION D. PUBLICSQL 83. A 8A B C D7. like _a%, BA. aili B. baiC.bba D.cca9. SQL( A )A. DELETE B. DROP C. CLEAR D. REMOVESQL 9(110)1. ( C )A. B.C. D.2. SQL Server D ASQL Server BSQL Server AgentCMS DTC D. PWS4. SQL Server D A BC D6. SQL4050 ( B )A. IN (4050) B. BETWEEN 40 AND 50C. BETWEEN 40 OR 50 D. BETWEEN 40 ,507( B )A. = OR = B. = AND =C. BETWEEN AND D. IN (,)8. SQL Server ( B )9A. a12 B. 12aC. a12 D. #qq9. SQL( D )A. AND B. NOTC. OR D. XOR10. C AABS B. SINC. STR D. ROUNDSQL 10(120)13NF( D )A2NF B1NFCBCNF D1NF2NF2DBSDBS( C )A BC D3SQL Server( D )(1) (2)(3) (4)A(1) B(1)(2)C(1)(2) (3) D(1)(2)(3)(4)4MS SQL Server( D )A B10C D5()(C )A1 B2C3 D46()()( C )A BC D7SQL( C )AUPDATE TABLE BMODIFY TABLECALTER TABLE DCHANGE TABLE8CSQL( )AINSTEAD OF DELETE BINSTEAD OF DROPCAFTER DELETE DAFTER UPDATE9MS SQL Server( D )Amaster B modelCtempdb D pubs10SQL Server ( BSD )A BC D11( C )11A BC D12( A )A B.C D15RSRS( D )A BC D16( C )ASUM (*) BMAX (*)CCOUNT (*) DAVG (*)17SQL( C )Aage IS NULL Bage IS NOT NULLCage = NULL DNOT (age IS NULL)18MS SQL ServerWINDOWS 2000( B )A BC D19( B )A BC D20( A )A BC DSQL 111212011NF ( C )A2NF B3NFC2NF3NF D6( D )A BC D7SQL( B )ADELETE TRIGGER BDROP TRIGGERCREMOVE TRIGGER DDISABLE TRIGGER8SQL( C )AINSTEAD OF DELETE BINSTEAD OF DROPCAFTER DELETE DAFTER UPDATE9MS SQL ServerSQL Server( A )Amaster BmodelCtempdb Dpubs10SQL Serverguest ( D )AguestmasterpubstempdbnorthwindBSQL ServerguestCmastertempdbguestDguest1311( D )A BC D12master ( D )A BC D13SQL A ADELETE BDROPCCLEAR DREMORE14( C )A BCnet begin mssqlserver D15( B )AORDER BY BORDER BY descCORDER BY asc DORDER BY dictinct17SQL( C )Aname like hgf# Bname like hgf_t%Cname like hgf% Dname like h#% escape #18MS SQL Server B ABCD1419SQLSQL B A BC DSQL 12(110)1. SQL C AF1 BF3CF5 DF63. B AMOV BEXISTSCUNION DHAVING5. D A/ B%C D-6. CA. B.C. D.7. D A. B. ()C. D. ()8. E-R( B )A. B.C. D.159. select stuff(he rld,3,l, llo wo) C Ahello Bworld helloChello world Dworld10. StudentStuName B A B C D (120)1. _2. SQL Server 2000_4. select lower(Beautiful) , rtrim( ) _ beautiful _5._6._7._8.SQL Server 2000_9. select day(2004-4-6), len(.) _6_7_7. T-SQL _9. select floor(17.4), floor(-214.2), round(13.4382,2), round(-18.4562,3) _17_-215_13.4400_-18.4560_(120)3. select ascii(C), char(68), len( BigTiger ) _67_D_12_7. _ _ _(120)161_4. select year(1931-9-18) _1931_3_4_5(Transaction),_()6. SQL Server 2000 _ Windows_7SQL Server_8SQL Server 2000