. . . .

A£®masterÊý¾Ý¿âµÄ´óС C£®msdbÊý¾Ý¿âµÄ´óС

B£®modelÊý¾Ý¿âµÄ´óС D£®3MB

6£®ÔÚSQL ServerϵͳÊý¾Ý¿âÖУ¬´æ·ÅÓû§Êý¾Ý¿â¹«¹²ÐÅÏ¢µÄÊÇ D A£®master

C£®msdbÊý¾Ý¿âµÄ´óС

B£®model D£®tempdb

7£®ÔÚSQL ServerÖд´½¨Óû§Êý¾Ý¿âʵ¼Ê¾ÍÊǶ¨ÒåÊý¾Ý¿âËù°üº¬µÄÎļþÒÔ¼°ÎļþµÄÊôÐÔ¡£ÏÂÁв»ÊôÓÚÊý¾Ý¿âÎļþÊôÐÔµÄÊÇ C A£®³õʼ´óС C£®Îļþ½á¹¹

B£®ÎïÀíÎļþÃû D£® ×î´ó´óС

8£®ÔÚSQL ServerÖд´½¨Óû§Êý¾Ý¿âʵ¼Ê¾ÍÊǶ¨ÒåÊý¾Ý¿âËù°üº¬µÄÎļþÒÔ¼°ÎļþµÄÊôÐÔ¡£ÏÂÁв»ÊôÓÚÊý¾Ý¿âÎļþÊôÐÔµÄÊÇ C A£®³õʼ´óС C£®Îļþ½á¹¹

B£®ÎïÀíÎļþÃû D£® ×î´ó´óС

9£®ÏÂÁÐÔ¼ÊøÖÐÓÃÓÚÏÞÖÆÁеÄÈ¡Öµ·¶Î§µÄÔ¼ÊøÊÇ B A£®PRIMARY KEY C£®DEFAULT

B£®CHECK D£® UNIQUE

10£®ÏÂÁÐÔ¼ÊøÖÐÓÃÓÚÏÞÖÆÁеÄÈ¡Öµ²»ÖصÄÔ¼ÊøÊÇ D A£®PRIMARY KEY C£®DEFAULT

B£®CHECK D£® UNIQUE

11£®ÏÂÁÐÔ¼ÊøÖÐÓÃÓÚʵÏÖʵÌåÍêÕûÐÔµÄÔ¼ÊøÊÇ A A£®PRIMARY KEY

B£®CHECK

. word×ÊÁϿɱ༭ .

. . . .

C£®DEFAULT D£® UNIQUE

12£®ÏÂÁйØÓÚDEFAULTÔ¼ÊøµÄ˵·¨£¬´íÎóµÄÊÇ D A£®Ò»¸öDEFAULTÔ¼ÊøÖ»ÄÜÔ¼Êø±íÖеÄÒ»¸öÁÐ B£®ÔÚÒ»¸ö±íÉÏ¿ÉÒÔ¶¨Òå¶à¸öDEFAULTÔ¼Êø C£®DEFAULTÖ»Äܶ¨ÒåÔÚÁм¶ÍêÕûÐÔÔ¼Êø´¦

D£®ÔÚÁм¶ÍêÕûÐÔÔ¼ÊøºÍ±í¼¶ÍêÕûÐÔÔ¼Êø´¦¶¼¿ÉÒÔ¶¨ÒåDEFAULTÔ¼Êø

. word×ÊÁϿɱ༭ .

. . . .

µÚ 4 Õ Êý¾Ý²Ù×÷Óï¾ä

Ò»£® Ñ¡ÔñÌâ

1£® µ±¹ØϵRºÍS½øÐÐÁ¬½Ó²Ù×÷ʱ£¬Èç¹ûRÖеÄÔª×é²»Âú×ãÁ¬½ÓÌõ¼þ£¬ÔÚÁ¬½Ó½á¹ûÖÐÒ²»á½«ÕâЩ¼Ç

¼±£ÁôÏÂÀ´µÄ²Ù×÷ÊÇ A A£®×óÍâÁ¬½Ó C£®ÄÚÁ¬½Ó

B£®ÓÒÍâÁ¬½Ó D£®×ÔÁ¬½Ó

2£® ÉèÔÚijSELECTÓï¾äµÄWHERE×Ó¾äÖУ¬ÐèÒª¶ÔGradeÁеĿÕÖµ½øÐд¦Àí¡£ÏÂÁйØÓÚ¿ÕÖµµÄ²Ù

×÷£¬´íÎóµÄÊÇ

C

B£®Grade IS NULL

D£®NOT (Grade IS NULL) D

B£®MAX(ÁÐÃû)

D£®COUNT(*)

A

A£®Grade IS NOT NULL C£®Grade = NULL

3£® ÏÂÁоۺϺ¯ÊýÖУ¬²»ºöÂÔ¿ÕÖµµÄÊÇ

A£®SUM(ÁÐÃû) C£®AVG(ÁÐÃû)

4£®SELECT ¡­ INTO ¡­FROMÓï¾äµÄ¹¦ÄÜÊÇ

A£® ½«²éѯ½á¹û²åÈëµ½Ò»¸öбíÖÐ

B£® ½«²éѯ½á¹û²åÈëµ½Ò»¸öÒѽ¨ºÃµÄ±íÖÐ C£® ºÏ²¢²éѯµÄ½á¹û

D£® ÏòÒÑ´æÔڵıíÖÐÌí¼ÓÊý¾Ý

5£®ÏÂÁÐÀûÓÃSC±íµÄ²éѯÓï¾äÖУ¬´íÎóµÄÊÇ

B

A£® SELECT Sno, COUNT(*) FROM SC GROUP BY Sno

. word×ÊÁϿɱ༭ .

. . . .

B£® SELECT Sno FROM SC GROUP BY Sno WHERE COUNT(*) > 3 C£® SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*) > 3 D£® SELECT Sno FROM SC GROUP BY Sno

6£®ÏÖÒªÀûÓÃStudent±í²éѯÄêÁä×îСµÄѧÉúÐÕÃûºÍÄêÁä¡£ÏÂÁÐʵÏִ˹¦ÄܵIJéѯÓï¾äÖУ¬ÕýÈ·µÄÊÇ

D

A£® SELECT Sname, MIN(Sage) FROM Student

B£® SELECT Sname, Sage FROM Student WHERE Sage = MIN(Sage) C£® SELECT TOP 1 Sname, Sage FROM Student

D£® SELECT TOP 1 Sname, Sage FROM Student ORDER BY Sage

7£®ÉèSC±íÖмǼ³É¼¨µÄÁÐΪ£ºGrade£¬ÀàÐÍΪint¡£ÈôÔÚ²éѯ³É¼¨Ê±£¬Ï£Íû½«³É¼¨°´¡®ÓÅ¡¯¡¢¡®Á¼¡¯¡¢¡®ÖС¯¡¢¡®¼°¸ñ¡¯ºÍ¡®²»¼°¸ñ¡¯ÐÎʽÏÔʾ£¬ÕýÈ·µÄCaseº¯ÊýÊÇ C

A.

Case Grade

When 90~100 THEN 'ÓÅ' When 80~89 THEN 'Á¼' When 70~79 THEN 'ÖÐ' When 60~69 THEN '¼°¸ñ' Else '²»¼°¸ñ' End B.

Case

When Grade between 90 and 100 THEN Grade = 'ÓÅ' When Grade between 80 and 89 THEN Grade = 'Á¼' When Grade between 70 and 79 THEN Grade = 'ÖÐ'

. word×ÊÁϿɱ༭ .

. . . .

When Grade between 60 and 69 THEN Grade = '¼°¸ñ' Else Grade = '²»¼°¸ñ' End C.

Case

When Grade between 90 and 100 THEN 'ÓÅ' When Grade between 80 and 89 THEN 'Á¼' When Grade between 70 and 79 THEN 'ÖÐ' When Grade between 60 and 69 THEN '¼°¸ñ' Else '²»¼°¸ñ' End D.

Case Grade

When 90~100 THEN Grade = 'ÓÅ' When 80~89 THEN Grade = 'Á¼' When 70~79 THEN Grade = 'ÖÐ' When 60~69 THEN Grade = '¼°¸ñ' Else Grade = '²»¼°¸ñ'

End

8£®ÏÂÊöÓï¾äµÄ¹¦ÄÜÊǽ«Á½¸ö²éѯ½á¹ûºÏ²¢ÎªÒ»¸ö½á¹û¡£ÆäÖÐÕýÈ·µÄÊÇ A£®select sno,sname,sage from student where sdept = 'cs' Order by sage Union

select sno,sname,sage from student where sdept = 'is'

. word×ÊÁϿɱ༭ B

.