A.ʵÌå C.ÁªÏµ
B.ÊôÐÔ D.Ä£ÐÍ
61.ÉèÒ»¸ö¿ÆÑÐÏîĿֻÄÜÓÉÒ»¸öÑо¿×é³Ðµ££¬¶øÒ»¸öÑо¿×é¿É³Ðµ£¶à¸öÏîÄ¿¡£ÔòÏîÄ¿ÓëÑо¿×éÖ®¼äÊÇ A.Ò»¶ÔÒ»µÄ¹ØÏµ C.¶à¶ÔÒ»µÄÁªÏµ
B.Ò»¶Ô¶àµÄ¹ØÏµ D.¶à¶Ô¶àµÄÁªÏµ
62.ÏÂÁйØÏµ´úÊýµÄ²Ù×÷ÖУ¬²»ÊÇ»ù±¾ÔËËãµÄÊÇ A.½»
B.²¢
C.µÑ¿¨¶û»ý D.ͶӰ
63.ÓÐ2¸ö¹ØÏµÄ£Ê½R£¨A£¬B£¬C£©ºÍS£¨D£¬E£©£¬RÖÐÓÐ3¸öÔª×飬SÖÐÓÐ2¸öÔª×飬ÔòRºÍS×ÔÈ»Á¬½ÓºóµÃµ½µÄйØÏµÖУ¬ÊôÐÔ¸öÊý¼°Ôª×é¸öÊý·Ö±ðΪ A.5£¬5 C.6£¬5
B.5£¬6 D.6£¬6
64.º¯ÊýÒÀÀµÊÇÃèÊö¹ØÏµÖи÷¸öÊôÐÔÖ®¼äÏà»¥ÖÆÔ¼¶øÓÖÏ໥ÒÀÀµµÄ¹ØÏµ¡£È·¶¨ÊôÐÔ¼äµÄº¯ÊýÒÀÀµ£¬Òª¸ù¾Ý
A.µ±Ç°µÄÊý¾ÝÖµ¹éÄÉ B.Ö÷¼üÖµ¾ö¶¨ C.ºòÑ¡¼üÖµ¾ö¶¨
D.ÊôÐÔµÄÓïÒå¾ö¶¨
65.ÔÚÊý¾Ý¿âÉè¼ÆÖУ¬Ê¹ÓÃE-Rͼ±íʾÊý¾Ý¿âµÄ A.ÐÅϢģÐÍ C.ÎïÀíÄ£ÐÍ
B.Â߼ģÐÍ D.½á¹¹Êý¾ÝÄ£ÐÍ
66.ÒÑÖª¹ØÏµÄ£Ê½R£¨A£¬B£¬C£¬D£©£¬Æäº¯ÊýÒÀÀµ¼¯F={A¡úB£¬C¡úB}£¬ÔòRÖÐÖ÷ÊôÐÔÓÐ A. A£¬C£¬B C. B£¬C£¬D
B. A£¬B£¬D D. A£¬C£¬D
67.ÏÂÁк¯ÊýÖÐÓÃÀ´²âÊÔµ±Ç°¼Ç¼ºÅµÄº¯ÊýÊÇ A.RECCOUNT C.RECNO
B.FOUND D.ROUND
68.ʹÓÃÓï¾äCREATE TABLE S(sno N£¨2£©£¬sname C£¨6£©£¬age N£¨2£©£¬sex C£¨1£©£©½¨Ò»ÕÅѧÉú±í£¬ÆäÖÐsnoÊÇÖ÷¼ü£¬sname²»ÔÊÐíÈ¡¿ÕÖµ£¬ÏÂÁÐSQLÓï¾äÖв»ÕýÈ·µÄÊÇ A. INSERT INTO S value£¨1£¬£¢ÁÖÁ¢£¢£¬20£¬£¢F£¢£©
B. INSERT INTO S(sno, age, sname, sex) values£¨1£¬20£¬£¢ÁÖÁ¢£¢£¬£¢F£¢£© C. INSERT INTO S value£¨1£¬null£¬20£¬£¢F£¢£© D. INSERT INTO S value£¨1£¬£¢ÁÖÁ¢£¢£¬null£¬£¢F£¢£©
69. ×îÖÕÓû§Ê¹ÓõÄÊý¾ÝÊÓͼ³ÆÎª A.ÄÚģʽ B.Íâģʽ C.¸ÅÄîģʽ D.´æ´¢Ä£Ê½
70. ÔÚÊý¾Ý¿âϵͳÖУ¬°Ñ¿ÉÒÔÏà»¥Çø±ðµÄ¿Í¹ÛÊÂÎï³ÆÎª A.Îļþ B.×Ö¶Î C.ʵÌå D.¹Ø¼üÂë
71. Êý¾Ý¿âµÄÈý¼¶Ä£Ê½½á¹¹Ö®¼ä´æÔÚ×ÅÁ½¼¶Ó³Ïñ£¬Ê¹µÃÊý¾Ý¿âϵͳ¾ßÓÐ½Ï¸ßµÄ A.ÊÂÎñ²¢·¢ÐÔ B.Êý¾Ý¿É¿¿ÐÔ C.Êý¾Ý¶ÀÁ¢ÐÔ D.Êý¾ÝÖØÓÃÐÔ
72. ÓйØÏµR(sno,sname,age)£¬ÏÂÁйØÓÚ¿ÕÖµµÄ²éѯÓï¾äÖУ¬²»ÄܲúÉúÕýÈ·½á¹ûµÄÊÇ A. SELECT sname FROM R WHERE age=NULL B. SELECT sname FROM R WHERE age IS NULL
C. SELECT sname FROM R WHERE NOT(age IS NULL) D. SELECT sname FROM R WHERE age IS NOT NULL 73.ÔÚÊý¾Ý¿âϵͳÖУ¬ÏµÍ³¹ÊÕÏÔì³É A.Ó²ÅÌÊý¾Ý¶ªÊ§ B.ÈíÅÌÊý¾Ý¶ªÊ§ C.ÄÚ´æÊý¾Ý¶ªÊ§ D.´Å´øÊý¾Ý¶ªÊ§
74.ÔÚ¹ØÏµÄ£Ê½R(A£¬B£¬C)ÖУ¬F={(A£¬B)¡úC£¬B¡úC}£¬ÔòR×î¸ß´ïµ½
A. 1NF B. 2NF C. 3NF D. BCNF
75. Êý¾Ý¿âÉè¼ÆÖУ¬ÓÃÓÚ·´Ó³ÆóÒµÐÅÏ¢ÐèÇóµÄÊÇ A.ERÄ£ÐÍ B.¹ØÏµÄ£ÐÍ C.²ã´ÎÄ£ÐÍ D.Íø×´Ä£ÐÍ
76. ÔÚÒ»¸öERÄ£ÐÍÖУ¬ÓÐ3¸ö²»Í¬µÄʵÌ弯ºÍ3¸ö²»Í¬µÄ¶þÔªÁªÏµ£¬ÆäÖÐÓÐ1¸öÒ»¶ÔÒ»ÁªÏµ¡¢1¸öÒ»¶Ô¶àÁªÏµºÍ1¸ö¶à¶Ô¶àÁªÏµ£¬¸ù¾ÝERÄ£ÐÍת»»³É¹ØÏµÄ£Ð͵ĹæÔò£¬×ª»»³É¹ØÏµµÄÊýÄ¿ÊÇ A.3 B.4 C.5 D.6
77.Èç¹ûÊÂÎñT»ñµÃÁËÊý¾Ý¶ÔÏóQÉϵÄSËø£¬ÔòÆäËûÊÂÎñÔÚÊý¾Ý¶ÔÏóQÉÏ
A.¿É¼ÓXËø B.¿É¼ÓSËø C.¿É¼ÓÈκÎËø D.²»ÄܼÓÈκÎËø
78.ÔÚÊÂÎñÒÀÀµÍ¼ÖУ¬ÈôÁ½¸öÊÂÎñµÄÒÀÀµ¹ØÏµ¹¹³ÉÑ»·£¬Ôò A.ÊÂÎñÖ´Ðгɹ¦ B.ϵͳ³öÏÖ»îËø
C.ÊÂÎñÖ´ÐÐʧ°Ü D.ϵͳ³öÏÖËÀËø 79.ÔÚÊý¾Ý¿âϵͳÖУ¬ÈÕÖ¾ÎļþÓÃÓÚ
A.±£ÕÏÊÂÎñµÄ²¢·¢ÐÔ B.±£ÕÏÊý¾ÝµÄ°²È«ÐÔ C.¼ì²âϵͳµÄËÀËø D.Êý¾Ý¿â¹ÊÕϵĻָ´
80.ÔÚÒ»¸öDDBSÖУ¬¸÷³¡µØ¾ù²ÉÓùØÏµÊý¾ÝÄ£ÐÍ£¬µ«Ä³Ð©³¡µØµÄDBMSÊÇOracle£¬¶øÁíһЩÊÇSQL Server£¬Ôò³ÆÖ®Îª
A.Òì¹¹ÐÍ B.ÒìÖÊÐÍ C.ͬ¹¹ÒìÖÊÐÍ D.Ò칹ͬÖÊÐÍ
81.ÔÚÃæÏò¶ÔÏóÊý¾Ý¿âϵͳÖУ¬²»Í¬ÀàµÄ¶ÔÏó¹²Ïí¹«¹²²¿·ÖµÄ½á¹¹ºÍÌØÐÔ³ÆÎª A.¹²ÏíÐÔ B.¼Ì³ÐÐÔ C.ͨÓÃÐÔ D.Ò»ÖÂÐÔ 82. Èý¼¶Ä£Ê½¼ä´æÔÚÁ½ÖÖÓ³É䣬ËüÃÇÊÇ
A£®Ä£Ê½Óë×Óģʽ¼ä£¬Ä£Ê½ÓëÄÚģʽ¼ä B£®×ÓģʽÓëÄÚģʽ¼ä£¬ÍâģʽÓëÄÚģʽ¼ä C£®×ÓģʽÓëÍâģʽ¼ä£¬Ä£Ê½ÓëÄÚģʽ¼ä D£®Ä£Ê½ÓëÄÚģʽ¼ä£¬Ä£Ê½Óëģʽ¼ä
83. ´Ó¹ØÏµÖÐÌôÑ¡³öÖ¸¶¨µÄÊôÐÔ×é³ÉйØÏµµÄÔËËã³ÆÎª
A£®¡°Ñ¡È¡¡±ÔËËã B£®¡°Í¶Ó°¡±ÔËËã C£®¡°Áª½Ó¡±ÔËËã D£®¡°½»¡±ÔËËã
84. 3NFͬʱÓÖÊÇ
A£®2NF B£®1NF C£®BCNF D£®1NF£¬2NF
85. ÏÂÃæÁгöµÄÌõÄ¿ÖУ¬ÄÄЩÊÇÊý¾Ý¿âϵͳµÄ×é³É³ÉÔ± £¿ ¢ñ.²Ù×÷ϵͳ £ £ ¢ò.Êý¾Ý¿â¹ÜÀíϵͳ
¢ó.Óû§ £ £ ¢ô.Êý¾Ý¿â¹ÜÀíÔ± £ £ ¢õ.Êý¾Ý¿â A£® ¢ò¡¢¢ó¡¢¢ôºÍ¢õ B. ¢ò¡¢¢ôºÍ¢õ C. ¢ñ¡¢¢ò¡¢¢ôºÍ¢õ D. ¶¼ÊÇ
86. ÔÚ¹ØÏµÊý¾Ý¿âÖУ¬±í(table)ÊÇÈý¼¶Ä£Ê½½á¹¹ÖÐµÄ ¡£ A. Íâģʽ B. ģʽ C. ´æ´¢Ä£Ê½ D. ÄÚģʽ 87. ÔÚÏÂÃæÁгöµÄÊý¾ÝÄ£ÐÍÖУ¬ÄÄÒ»¸öÊǸÅÄîÊý¾ÝÄ£ÐÍ ¡£
A. ¹ØÏµÄ£ÐÍ B. ²ã´ÎÄ£ÐÍ C. Íø×´Ä£ÐÍ D. ʵÌå-ÁªÏµÄ£ÐÍ
88. ÏÂÃæÁгöµÄÊý¾Ý¹ÜÀí¼¼Êõ·¢Õ¹µÄÈý¸ö½×¶ÎÖУ¬Äĸö(Щ)½×¶ÎûÓÐרÃŵÄÈí¼þ¶ÔÊý¾Ý½øÐйÜÀí ¡£
¢ñ.È˹¤¹ÜÀí½×¶Î ¢ò.Îļþϵͳ½×¶Î ¢ó.Êý¾Ý¿â½×¶Î A. Ö»ÓТñ
B. Ö»ÓТò
C. ¢ñºÍ¢ò
D. ¢òºÍ¢ó
89. ÓÐÈçÏÂÁ½¸ö¹ØÏµ£¬ÆäÖйÍÔ±ÐÅÏ¢±í¹ØÏµEMPµÄÖ÷¼üÊǹÍÔ±ºÅ£¬²¿ÃÅÐÅÏ¢±í¹ØÏµDEPTµÄÖ÷¼üÊDz¿Ãźš£ £ £ EMP
£ £ ©°©¤©¤©¤©Ð©¤©¤©¤©¤©Ð©¤©¤©¤©¤©Ð©¤©¤©¤©¤©´ £ £ ©¦¹ÍÔ±ºÅ©¦¹ÍÔ±Ãû ©¦ ²¿ÃźŠ©¦ ¹¤×Ê ©¦ £ £ ©À©¤©¤©¤©à©¤©¤©¤©¤©à©¤©¤©¤©¤©à©¤©¤©¤©¤©È £ £ ©¦ 001 ©¦ ÕÅɽ ©¦ 02 ©¦ 2000 ©¦ £ £ ©¦ 010 ©¦Íõºê´ï ©¦ 01 ©¦ 1200 ©¦ £ £ ©¦ 056 ©¦ÂíÁÖÉú ©¦ 02 ©¦ 1000 ©¦ £ £ ©¦ 101 ©¦ ÕÔÃô ©¦ 04 ©¦ 1500 ©¦ £ £ ©¸©¤©¤©¤©Ø©¤©¤©¤©¤©Ø©¤©¤©¤©¤©Ø©¤©¤©¤©¤©¼ £ £ DEPT
£ £ ©°©¤©¤©¤©Ð©¤©¤©¤©¤©Ð©¤©¤©¤©¤©´ £ £ ©¦²¿Ãźũ¦ ²¿ÃÅÃû ©¦ µØÖ· ©¦ £ £ ©À©¤©¤©¤©à©¤©¤©¤©¤©à©¤©¤©¤©¤©È £ £ ©¦ 01 ©¦ÒµÎñ²¿ ©¦ 1ºÅÂ¥ ©¦ £ £ ©¦ 02 ©¦ÏúÊÛ²¿ ©¦ 2ºÅÂ¥ ©¦ £ £ ©¦ 03 ©¦·þÎñ²¿ ©¦ 3ºÅÂ¥ ©¦ £ £ ©¦ 04 ©¦²ÆÎñ²¿ ©¦ 4ºÅÂ¥ ©¦ £ £ ©¸©¤©¤©¤©Ø©¤©¤©¤©¤©Ø©¤©¤©¤©¤©¼
£ £ ÈôÖ´ÐÐÏÂÃæÁгöµÄ²Ù×÷£¬Äĸö²Ù×÷²»Äܳɹ¦Ö´ÐУ¿
£ £ A) ´ÓEMPÖÐɾ³ýÐÐ(¡®010'£¬¡®Íõºê´ï'£¬¡®01'£¬1200) £ £ B) ÔÚEMPÖвåÈëÐÐ(¡®102'£¬¡®ÕÔÃô'£¬¡®01'£¬1500) £ £ C) ½«EMPÖйÍÔ±ºÅ=¡®056'µÄ¹¤×ʸÄΪ1600Ôª £ £ D) ½«EMPÖйÍÔ±ºÅ=¡®101'µÄ²¿ÃźŸÄΪ¡®05'
90. ÓÐÈçÏÂÁ½¸ö¹ØÏµ£¬ÆäÖйÍÔ±ÐÅÏ¢±í¹ØÏµEMPµÄÖ÷¼üÊǹÍÔ±ºÅ£¬²¿ÃÅÐÅÏ¢±í¹ØÏµDEPTµÄÖ÷¼üÊDz¿Ãźš£ £ £ EMP
£ £ ©°©¤©¤©¤©Ð©¤©¤©¤©¤©Ð©¤©¤©¤©¤©Ð©¤©¤©¤©¤©´ £ £ ©¦¹ÍÔ±ºÅ©¦¹ÍÔ±Ãû ©¦ ²¿ÃźŠ©¦ ¹¤×Ê ©¦ £ £ ©À©¤©¤©¤©à©¤©¤©¤©¤©à©¤©¤©¤©¤©à©¤©¤©¤©¤©È £ £ ©¦ 001 ©¦ ÕÅɽ ©¦ 02 ©¦ 2000 ©¦