Êý¾Ý¿â¼¼Êõ¸´Ï°Ìâ1 Ñ¡ÔñÌ⣨´ð°¸£© ÏÂÔØ±¾ÎÄ

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 ©¦