ÄÚÈÝ·¢²¼¸üÐÂʱ¼ä : 2025/7/11 11:47:43ÐÇÆÚÒ» ÏÂÃæÊÇÎÄÕµÄÈ«²¿ÄÚÈÝÇëÈÏÕæÔĶÁ¡£
2015Äê3ÔÂÈý¼¶Êý¾Ý¿â¼¼ÊõÕæÌâ¼°´ð°¸½âÎö
(1/30)Ñ¡ÔñÌâ µÚ1Ìâ
ÔÚÊý¾Ý¿âÓ¦ÓÃϵͳµÄÐèÇó·ÖÎö½×¶Î£¬È·¶¨ÏµÍ³ÍÌÍÂÁ¿µÄ¹¤×÷ÊôÓÚ______¡£ A.Êý¾Ý´¦ÀíÐèÇó·ÖÎö B.ÒµÎñ¹æÔòÐèÇó·ÖÎö C.ÐÔÄÜÐèÇó·ÖÎö D.°²È«ÐÔÐèÇó·ÖÎö ÏÂÒ»Ìâ
(2/30)Ñ¡ÔñÌâ µÚ2Ìâ
ÔÚÒ»¸öERͼÖУ¬°üº¬Èý¸öʵÌ弯£¬Á½¸ö¶þÔªÒ»¶Ô¶àÁªÏµ£¬Á½¸ö¶þÔª¶à¶Ô¶àÁªÏµ£¬ÒÔ¼°Ò»¸öÒ»Ôª¶à¶Ô¶àÁªÏµ¡£½«¸ÃERͼת»¯Îª¹ØÏµÄ£Ðͺ󣬵õ½µÄ¹ØÏµÄ£Ê½¸öÊýÊÇ______¡£ A.4¸ö B.5¸ö C.6¸ö D.7¸ö
ÉÏÒ»Ìâ ÏÂÒ»Ìâ (3/30)Ñ¡ÔñÌâ µÚ3Ìâ
DFD½¨Ä£·½·¨ÓÉÊý¾ÝÏî¡¢´¦Àí¡¢Êý¾Ý´æ´¢ÒÔ¼°ÍⲿÏî×é³É¡£ÏÂÁйØÓÚDFD±íʾ·½·¨µÄ˵·¨£¬´íÎóµÄÊÇ______¡£ A.Êý¾ÝÁ÷ÓüýÍ·±íʾ B.´¦ÀíÓþØÐοò±íʾ
C.Êý¾Ý´æ´¢ÓÃÔ²½Ç¾ØÐοò±íʾ D.ÍⲿÏîÓÃÁâÐαíʾ ÉÏÒ»Ìâ ÏÂÒ»Ìâ (4/30)Ñ¡ÔñÌâ µÚ4Ìâ
IDEF1XÊÇÒ»ÖÖ³£ÓÃÊý¾Ý½¨Ä£·½·¨¡£ÏÂÁйØÓÚIDEF1X±ê¶¨ÐÍÁªÏµµÄ±íʾʵÀý£¬ÕýÈ·µÄÊÇ______¡£ A£® ͼƬ B£® ͼƬ C£® ͼƬ D£® ͼƬ A. B. C. D.
ÉÏÒ»Ìâ ÏÂÒ»Ìâ
(5/30)Ñ¡ÔñÌâ µÚ5Ìâ
ÏÂÁйØÓÚ¸÷ÖÖË÷ÒýµÄ˵·¨£¬ÕýÈ·µÄÊÇ______¡£ A.Ö÷Ë÷ÒýÒ»¶¨ÊǾۼ¯Ë÷Òý B.¾Û¼¯Ë÷ÒýÒ»¶¨ÊÇÖ÷Ë÷Òý C.ÓÐÐòË÷ÒýÖ»ÊʺϷ¶Î§²éѯ D.É¢ÁÐË÷ÒýÖ»Êʺϵã²éѯ ÉÏÒ»Ìâ ÏÂÒ»Ìâ (6/30)Ñ¡ÔñÌâ µÚ6Ìâ
Á¬½Ó²Ù×÷ÊÇÊý¾Ý¿âÖзdz£ºÄʱµÄ²Ù×÷¡£ÏÂÃæÁгöÁËÊý¾Ý¿âÖÐһЩÌá¸ßÐÔÄܵÄ×ö·¨£º ¢ñ£®Ôö¼ÓÈßÓàÁУ¬Ò²¾ÍÊǽ«Ò»¸ö±íµÄÁи´ÖƵ½ÁíÍâÒ»¸ö±íÖÐ ¢ò£®·´¹æ·¶»¯£¬Ò²¾ÍÊǽµµÍ±íµÄ¹æ·¶»¯³Ì¶È ¢ó£®ÔÚÏà¹ØÁÐÉϽ¨Á¢Ë÷Òý ¢ô£®½«±í×é֯Ϊ¾Û¼¯Îļþ
ÒÔÉÏ×ö·¨ÖУ¬ÄÜÌá¸ßÁ¬½Ó²Ù×÷ÐÔÄÜ»ò¼õÉÙÁ¬½Ó²Ù×÷µÄÊÇ______¡£ A.½ö¢ñ¡¢¢òºÍ¢ó B.½ö¢ñ¡¢¢òºÍ¢ô C.½ö¢ò¡¢¢óºÍ¢ô D.È«²¿¶¼ÊÇ ÉÏÒ»Ìâ ÏÂÒ»Ìâ (7/30)Ñ¡ÔñÌâ µÚ7Ìâ
ÒÑÖªÓйØÏµ£ºÔ±¹¤(Ô±¹¤Ãû,ÐÔ±ð,³öÉúÈÕÆÚ,¹¤×Ê,²¿ÃÅÃû)£¬¶Ô¸Ã¹ØÏµÓÐÈçϲéѯ²Ù×÷£º SELECT²¿ÃÅÃû,SUM(¹¤×Ê) FROMÔ±¹¤
WHEREÐÔ±ð=\ÄÐ\³öÉúÈÕÆÚ IS NOT NULL GROUP BY ²¿ÃÅÃû
ΪÁ˼ӿìÆä²éѯËÙ¶È£¬ÔòÓ¦¸Ã______¡£ A.ÔÚ¹¤×ÊÉϽ¨Ë÷Òý B.ÔÚÐÔ±ðÉϽ¨Ë÷Òý C.ÔÚ³öÉúÈÕÆÚÉϽ¨Ë÷Òý D.ÔÚ²¿ÃÅÃûÉϽ¨Ë÷Òý ÉÏÒ»Ìâ ÏÂÒ»Ìâ (8/30)Ñ¡ÔñÌâ µÚ8Ìâ
ÏÂÁйØÓÚ½µµÍËÀËø¿ÉÄÜÐÔµÄ˵·¨£¬ÕýÈ·µÄÊÇ______¡£ A.Ìá¸ßÊÂÎñµÄ¸ôÀëÐÔ¼¶±ð£¬·¢ÉúËÀËøµÄ¿ÉÄÜÐÔ¸üµÍ B.ʹÓÃ±í¼¶Ëø±ÈʹÓÃÐм¶Ëø£¬·¢ÉúËÀËøµÄ¿ÉÄÜÐÔ¸üµÍ C.½«µ¥¸ö´óÊÂÎñ²ð·Ö¶à¸öСÊÂÎñ£¬·¢ÉúËÀËøµÄ¿ÉÄÜÐÔ¸üµÍ D.¾¡¿ÉÄܰ´Ëæ»ú˳Ðò·ÃÎÊÊý¾ÝÏ·¢ÉúËÀËøµÄ¿ÉÄÜÐÔ¸üµÍ ÉÏÒ»Ìâ ÏÂÒ»Ìâ (9/30)Ñ¡ÔñÌâ µÚ9Ìâ
ÔÚÊý¾Ý¿âÓ¦ÓÃϵͳ½¨Ä£¹ý³ÌÖУ¬¾³£²ÉÓÃUML½¨Ä£¹¤¾ß¡£ÏÂÁйØÓÚUML½¨Ä£»úÖÆµÄ˵·¨£º
¢ñ£®ÓÃÀýÄ£ÐÍÊǰÑÂú×ãÓû§ÐèÇóµÄËùÓÐÊý¾Ý½á¹¹±íʾ³öÀ´µÄÄ£ÐÍ ¢ò£®ÀàͼÊÇÕ¹ÏÖÒ»×éÀà¡¢½Ó¿ÚºÍÐ×÷ÒÔ¼°ËüÃÇÖ®¼ä¹ØÏµµÄ¾²Ì¬ÊÓͼ ¢ó£®×´Ì¬Í¼Ö÷ÒªÓÃÀ´ÃèÊöÒ»¸öʵÌåÔÚ·¢ÉúһЩʼþʱµÄ״̬±ä»¯Çé¿ö
¢ô£®Ë³ÐòͼÖ÷ÒªÓÃÓÚÃèÊöϵͳ¡¢ÓÃÀýºÍ³ÌÐòÄ£¿éÖÐÂß¼Á÷³ÌµÄÏȺóÖ´ÐдÎÐò»ò²¢ÐдÎÐò ¢õ£®»î¶¯Í¼Ö÷ÒªÓÃÓÚÃèÊöϵͳÄÚ¶ÔÏóÖ®¼äµÄÏûÏ¢·¢ËͺͽÓÊÕÁ÷³Ì ¢ö£®°üͼÊDZíʾ°ü¼°°üÖ®¼äµÄ¹ØÏµµÄÀàͼ ÒÔÉÏ˵·¨ÖУ¬ÕýÈ·µÄÊÇ______¡£ A.½ö¢òºÍ¢ö B.½ö¢ñ¡¢¢òºÍ¢õ C.½ö¢ó¡¢¢ôºÍ¢ö D.½ö¢ò¡¢¢óºÍ¢ö ÉÏÒ»Ìâ ÏÂÒ»Ìâ (10/30)Ñ¡ÔñÌâ µÚ10Ìâ
ÔÚSQL Server 2008ÖУ¬ÉèÓÐÉÌÆ·±í(ÉÌÆ·ºÅ£¬ÉÌÆ·Ãû£¬Àà±ð)£¬ÏÖÒª²éѯÓë¡°±ùÏ䡱Àà±ðÏàͬµÄÆäËûÉÌÆ·µÄÉÌÆ·Ãû¡£ÏÂÁÐÓï¾äÖÐ×î·ûºÏ¸Ã²éѯҪÇóµÄÊÇ______¡£
A.SELECT T1.ÉÌÆ·ÃûFROMÉÌÆ·±íT1 JOINÉÌÆ·±íT2ON T1.Àà±ð=T2.Àà±ðWHERE T1.ÉÌÆ·Ãû=\±ùÏä\
B.SELECT T1.ÉÌÆ·ÃûFROMÉÌÆ·±íT1 JOINÉÌÆ·±íT2ON T1.Àà±ð=T2.Àà±ðWHERE T2.ÉÌÆ·Ãû=\±ùÏä\
C.SELECT T1.ÉÌÆ·ÃûFROMÉÌÆ·±íT1 JOINÉÌÆ·±íT2ON T1.Àà±ð=T2.Àà±ðWHERE T2.ÉÌÆ·Ãû=\±ùÏä\ÉÌÆ·Ãû!=\±ùÏä\
D.SELECT T1.ÉÌÆ·ÃûFROMÉÌÆ·±íT1 JOINÉÌÆ·±íT2ON T1.Àà±ð=T2.Àà±ðWHERE T1.ÉÌÆ·Ãû=\±ùÏä\ÉÌÆ·Ãû!=\±ùÏä\ÉÏÒ»Ìâ ÏÂÒ»Ìâ (11/30)Ñ¡ÔñÌâ µÚ11Ìâ
ÏÂÁйØÓÚSQL Server 2008´¥·¢Æ÷µÄ˵·¨£¬´íÎóµÄÊÇ______¡£ A.´¥·¢Æ÷¿ÉÓÃÓÚʵÏÖ¸´ÔÓµÄÒµÎñ¹æÔò
B.µ±´¥·¢Æ÷Ö´ÐÐʱ¶¼»áÉú³ÉINSERTED±íºÍDELETED±í C.INSERTED±í´æ´¢µÄÊDzåÈë»ò¸üкóµÄÊý¾Ý
D.µ±ºó´¥·¢ÐÍ´¥·¢Æ÷Ö´ÐÐʱ£¬Òý·¢´¥·¢Æ÷Ö´ÐеIJÙ×÷Óï¾äÒÑÖ´ÐÐÍê±Ï ÉÏÒ»Ìâ ÏÂÒ»Ìâ (12/30)Ñ¡ÔñÌâ µÚ12Ìâ
ÔÚSQL Server 2008ÖУ¬ÉèÓÐÈç϶¨ÒåµÄÄÚÁª±íÖµº¯Êý£º CREATE FUNCTION dbo.f_StuInfo(@dept varchar(20)) RETURNS TABLE AS
RETURN (SELECT S.Dept ASϵÃû,COUNT(*) ASÈËÊý£¬AVG(SC.Grade)ASƽ¾ù³É¼¨ FROM Student S JOIN SC ON S.Sno=SC.Sno WHERE S.Dept=@ dept GROUP BYS.Dept) ÓÐÏÂÁÐÀûÓøú¯ÊýµÄ²éѯÓï¾ä£º ¢ñ£®SELECT*FROM dbo.f_StuInfo(\
¢ò£®SELECT Dept, COUNT(*)£¬AVG(SC.Grade) FROM dbo.f_StuInfo(\