Course: Introduction to
Computer Science Exam. #3 Date:
Instructor: »¯©[Z (¥x¤j¸ê°T¤uµ{¨t) TA: ¤ý¥°Û ³¯©ú¦¿
½Ð¦bµª®×¨÷¨Ì§Ç§@µª¡A°O±o¶ñ¤W¨t¯Å¡B¾Ç¸¹¤Î©m¦W
¦Ò¸Õ®É¶¡¡G100¤ÀÄÁ
²µªÃD (¨CÃD10¤À¡A¦@100¤À)
1.
µ¹©w¼Æ¦C23¡B12¡B58¡B85¡B72¡B98¡B13¡B37¡A½Ð§ä¥X¨ä¤¤ªº³Ì¤p¼Æ¤Î²Ä¤G¤p¼Æ¡A§â§Aªº°µªk°O¿ý¤U¨Ó¡C(¥Îªº¤ñ¸û¦¸¼Æ·U¤Ö¡A¤À¼Æ·U°ª)
2.
µ¹©w¼Æ¦C25¡B1¡B8¡B5¡B7¡B9¡B13¡B3¡A½Ð¤À§O¥H¡u¿ï¾Ü±Æ§Çªk¡v¡B¡u´¡¤J±Æ§Çªk¡v¤Î¡uªwªj±Æ§Çªk¡v±N¥¦¥Ñ¤p±Æ¨ì¤j¡A°O¿ý§Aªº¹Lµ{¡C
3.
µ¹©w¤w±Æ§Ç¦nªº¼Æ¦C12¡B18¡B25¡B34¡B66¡B79¡B82¡B88¡A½Ð¥H¡u¤G¤¸·j´Mªk¡v§ä¬Ý¬Ý81¦b¤£¦b³o¼Æ¦C¤¤¡A¤]§ä§ä¬Ý12¦b¤£¦b³o¼Æ¦C¤¤¡A°O¿ý§Aªº¹Lµ{¡C
4.
¦b½Ò°ó¤W¡A§Ṳ́À§O¥H»¼°j©I¥s¤è¦¡¤Î¦Cªí¦¡¤èªkµ¥¨âºØµ{¦¡pºâ¶O¤ó¼Æ¡]Fibonacci
number¡^¡Aþ¤@Óµ{¦¡¤ñ¸û¦³®Ä¡H¬°¤°»ò¦³Óµ{¦¡nµ¥«Ü¤[¡H¬°¤°»ò¥t¤@Ó¦³®Äªºµ{¦¡¥un¤@Àþ¶¡´Nºâ¦n¤F©O¡H
5.
¥HLCSªº¤èªk¡A§äATTAGTCGT©MGTAAATGGTC³o¨âӧǦCªº³Ìªø¦@¦P¤l§Ç¦C¡A°O¿ý§Aªº¦Cªí¤Î¦^·¹¸ôµ{¡C
6.
³nÅé¥Í©R¶g´Áªº¤¤j¹Lµ{¬°¦ó¡H¦ó¿×¥Õ½c´ú¸Õ¡H¦ó¿×¶Â½c´ú¸Õ¡H
7.
½Ð¸ÑÄÀ¤U±³oÓSQL¬d¸ß¥y¡G
SELECT
©m¦W¡A¦a§}¡AºÊÅ@¤H
FROM student¡Aenroll
WHERE ½Òµ{ = ¡¥µ{¦¡»y¨¥¡¦¡@and
´Á¥½¦Ò < 60 and
student.¾Ç¸¹ = enroll.¾Ç¸¹
8.
²z§A¾Þ§@Accessªº¸gÅç¡C
9.
¦ó¿×XML¡HDTD¬O¥Î¨Ó°µ¤°»òªº¡HXQueryªº±Ôz¦¡¬°FLWRªí¥Ü¦¡¡A³o¥|Ó¦r¥À¤À§O¬Oþ¥|Ó¡H
10. ¦ó¿×¸ê®ÆÀ£ÁY¡H¬°¤°»ò§ÚÌn°µ¸ê®ÆÀ£ÁY¡A¦³¤°»ò¦n³B©O¡H