´óÁ¬¶«ÈíÐÅϢѧԺÊý¾Ý¿â(Êý¾Ý¿âÑ¡ÔñÌâÌâ¿â)

2007-2008ѧÄêµÚһѧÆÚ¡¶Êý¾Ý¿âÔ­Àí¼°Ó¦Óá·ÆÚÄ©¿¼ÊÔÊÔ¾íB

´ð°¸:D ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

19£®ÎªÁËÈóɼ¨ÁÐÖ»ÄÜÔÚ0¡«100µ±ÖÐÈ¡Öµ£¬ÐèÒª½øÐÐ Ô¼Êø¡£ £¨ £© £¨A£©·Ç¿Õ ´ð°¸:C ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

£¨B£©Î¨Ò» £¨C£©¼ì²é

£¨D£©ÍâÂë

20£®µ±Òª²éѯµÄÌõ¼þÊÇij¼¸¸öÌض¨µÄÊýֵʱ£¬¿ÉÒÔÓùؼü×Ö £¨ £© £¨A£©ON ´ð°¸:B ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

21. ÔÚSQL²éѯʱ£¬Èç¹ûÐèҪȥµô²éѯ½á¹ûÖеÄÖظ´×飬ӦʹÓÃ( )¹Ø¼ü×Ö¡£ ( )

(A) UNIQUE (B) DISTINCT (C) CHECK (D) MINUS ´ð°¸:B ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

22.

ÒÔ

ÏÂ

²»

ÊÇ

SQL

Óï

¾ä

ÖÐ

µÄ

¾Û

ºÏ

º¯

Êý

µÄ

ÊÇ

£¨B£©IN £¨C£©BETWEEN £¨D£©OF

£º

£¨ £©

£¨A£©SUM £¨B£©AVG £¨C£©COUNT £¨D£©DISTINCT ´ð°¸:D ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

23£®ÈôÓÃÈçϵÄSQLÓï¾ä´´½¨ÁËÒ»¸ö±íSC£º CREATE TABLE SC £¨S# CHAR£¨6£© NOT NULL£¬C# CHAR£¨3£© NOT NULL£¬SCORE INTEGER£¬NOTE CHAR£¨20£©£©£»ÏòSC±í²åÈëÈçÏÂÐÐʱ£¬£¨ £©

µÚ5 Ò³ ¹² 47 Ò³

2007-2008ѧÄêµÚһѧÆÚ¡¶Êý¾Ý¿âÔ­Àí¼°Ó¦Óá·ÆÚÄ©¿¼ÊÔÊÔ¾íB

ÐпÉÒÔ±»²åÈë ¡£ £¨ £©

£¨A£©£¨¡®201009¡¯£¬¡®111¡¯£¬¡®60¡¯£¬±ØÐÞ£© £¨B£©£¨¡®200823¡¯£¬¡®101¡¯£¬NULL£¬NULL£© £¨C£©£¨NULL£¬¡®103¡¯£¬¡®80¡¯£¬¡®Ñ¡ÐÞ¡¯£© £¨D£©£¨¡®201132¡¯£¬NULL£¬¡®86¡¯£¬¡® ¡¯ £©

´ð°¸:B ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:2

24¡¢ÓÃÈçϵÄSQLÓï¾ä´´½¨Ò»¸ös±í CREATE TABLE s£¨NO CHAR£¨4£© primary key£¬ NAME CHAR£¨8£© NOT NULL£¬ SEX CHAR£¨2£©£¬

AGE INT£© ÄÇô

¿É

ÒÔ²å

Èëµ½

¸Ã

±íÖÐ

µÄ

Êý¾Ý

ÊÇ£¨

£©a.£¨¡¯1031¡¯£¬¡¯Ôø»ª¡¯£¬NULL£¬NULL£© b.£¨¡¯1032¡¯£¬¡¯Ôø»ª¡¯£¬ÄУ¬23£©

c.£¨NULL£¬¡¯Ôø»ª¡¯£¬¡¯ÄС¯£¬¡¯23¡¯£© d.£¨¡¯1033¡¯£¬NULL£¬¡¯ÄС¯£¬23£© ´ð°¸:A

·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:2

25£®ÓÐÁ½¸ö¹ØϵS¡¢P£¬ÒѾ­´æÓÐÈçÏÂÊý¾Ý

S£¨¹©Ó¦ÉÌ£© P£¨Áã¼þ£©

¹©Ó¦É̺Š¹©Ó¦ÉÌÃû ËùÔÚ³ÇÊÐ Áã¼þºÅ ÑÕÉ« ¹©Ó¦É̺ŠB01 ºìÐÇ ±±¾© B001 ºì B01 S10 ÓîÖæ ÉϺ£ T20 ÀèÃ÷ Ìì½ò S100 °× S10 Z01 Á¢Ð ÖØÇì TUXY À¶ T20 ÆäÖÐS±íµÄÖ÷ÂëΪ¹©Ó¦É̺ţ¬P±íµÄÖ÷ÂëΪÁã

¼þºÅ£¬ÍâÂëΪ¹©Ó¦É̺ţ¬²ÎÕÕS±íµÄ¹©Ó¦É̺ţ¬ÏÂÃæÄÄÌõ¼Ç¼Äܹ»²åÈëµ½P±íÖÐ £¨A£©£¨¡¯S100¡¯£¬¡¯ºì¡¯£¬¡¯T20¡¯£© £¨B£©£¨¡¯TQOT¡¯£¬¡¯ÂÌ¡¯£¬NULL£© £¨C£©£¨¡¯A001¡¯£¬¡¯»Æ¡¯£¬¡¯T11¡¯£© £¨D£©£¨NULL£¬¡¯ºì¡¯£¬¡¯S10¡¯£©

´ð°¸:B ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:2

µÚ6 Ò³ ¹² 47 Ò³

£©

£¨ 2007-2008ѧÄêµÚһѧÆÚ¡¶Êý¾Ý¿âÔ­Àí¼°Ó¦Óá·ÆÚÄ©¿¼ÊÔÊÔ¾íB

26. ÔĶÁÏÂÃæµÄһϵÁÐSQLÓï¾ä£º

create table table1(column1 int) insert into table1 values(91)

create view view1 as select * from table1 where column1<=100 with check option insert into view1 values(95) insert into view1 values(110) insert into table1 values(101)

°´Ë³ÐòÖ´ÐÐÍêÉÏÃæÕâÁùÌõSQLÓï¾äÖ®ºó£¬ÔËÐÐselect count£¨*£© from table1µÄÖµ

£¨ £© (A) 1

(B)2

(C) 3

(D) 4

´ð°¸:C ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

27.ÓÃÓÚÊÂÎñ»Ø¹öµÄSQLÓï¾äÊÇ£¨ £© A¡¢CREATE TABLE B¡¢COMMIT C¡¢GRANTºÍREVOKE D¡¢ROLLBACK ´ð°¸:D ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

28£®SQLÖУ¬¡°DELETE FROM ±íÃû¡±±íʾ A£®´Ó»ù±¾±íÖÐɾ³ýËùÓÐÔª×é B£®´Ó»ù±¾±íÖÐɾ³ýËùÓÐÊôÐÔ C£®´ÓÊý¾Ý¿âÖг·ÏûÕâ¸ö»ù±¾±í D£®´Ó»ù±¾±íÖÐɾ³ýÖظ´Ôª×é ´ð°¸:A ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1 29. ÔÚ

SELECT

Óï¾äÖÐʹÓÃ

[]

MAX(ÁÐÃû)ʱ£¬ÁÐÃûÓ¦¸Ã

£¨ £©

£¨A£©±ØÐëÊÇ×Ö·ûÐÍ £¨B£©±ØÐëÊÇÊýÖµÐÍ £¨C£©±ØÐëÊÇÊýÖµÐÍ»ò×Ö·ûÐÍ £¨D£©²»ÏÞÖÆÊý¾ÝÀàÐÍ ´ð°¸:B ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

µÚ7 Ò³ ¹² 47 Ò³

2007-2008ѧÄêµÚһѧÆÚ¡¶Êý¾Ý¿âÔ­Àí¼°Ó¦Óá·ÆÚÄ©¿¼ÊÔÊÔ¾íB

30.SQL »ù±¾±íµÄ´´½¨ÖÐÊÇͨ¹ýÏÂÁÐÄĸöÑ¡ÏîʵÏÖ²ÎÕÕÍêÕûÐÔ¹æÔòµÄ ( ) £¨A£©Íâ¼ü×Ó¾ä £¨B£©Ö÷¼ü×Ó¾ä £¨C£©¼ì²é×Ó¾ä £¨D£©NOT NULL ´ð°¸:A ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

31£®SQLÖУ¬ÏÂÁÐÉæ¼°¿ÕÖµµÄ²Ù×÷£¬²»ÕýÈ·µÄÊÇ £¨ £©

£¨A£©AGE IS NOT NULL £¨B£©AGE IS NULL £¨C£©AGE = NULL

£¨D£©NOT (AGE IS NULL)

´ð°¸:C ·ÖÊý:1

ÌâÐÍ:Ñ¡ÔñÌâ ÄѶÈ:1

32. SQL µÄ SELECT Óï¾äÖУ¬¡°HAVING Ìõ¼þ±í´ïʽ¡±ÓÃÀ´É¸Ñ¡Âú×ãÌõ¼þµÄ£¨D£© ()ÐÐ (B)ÁÐ (C)¹Øϵ (D)·Ö×é ´ð°¸:D ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

33. SQLÓïÑÔÖУ¬SELECTÓï¾äµÄÖ´Ðнá¹ûÊÇ£¨£© (A)¼¯ºÏ (B)ÊôÐÔ (C)Ôª×é (D)Êý¾Ý¿â ´ð°¸:A ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1 34

£®

ÏÂ

ÁÐ

SQL

Óï

¾ä

ÖÐ

£¬

ÐÞ

¸Ä

±í

½á

¹¹

£¨ £©

£¨A£©ALTER £¨B£©CREATE £¨C£©UPDATE £¨D£©INSERT ´ð°¸:A ·ÖÊý:1

ÌâÐÍ: Ñ¡ÔñÌâ ÄѶÈ:1

µÚ8 Ò³ ¹² 47 Ò³

ÊÇ

µÄ