·¢²¼Ê±¼ä : ÐÇÆÚÈý ÎÄÕÂÎä¿Æ´óÊý¾Ý¿â(SQL Server)ÔÀíÓë¼¼ÊõÌâ¿â¼°´ð°¸ - ͼÎĸüÐÂÍê±Ï¿ªÊ¼ÔĶÁ
59. ΪÁËÔÚ³ÌÐòÖÐʹÓÃSqlServer .NET Êý¾ÝÌṩ³ÌÐò£¬Ó¦ÔÚÔ´³ÌÐò¹¤³ÌÖÐÌí¼Ó¶Ô³ÌÐò¼¯£¨B£©µÄÒýÓᣠ(òËÆ) A.System.Data B. System.Data.SqlClient C. System.Data.OleDb D. System.Data.Odbc
60. Á¬½Ó×Ö·û´®ÉèÖÃÈçÏ£¬¸ÃÁ¬½ÓµÄ·þÎñÆ÷µÄ»úÆ÷ÃûΪ£¨ £©¡£ Dim cnNorthwind As new OleDbconnection
CnNorthwind.ConnectionString=¡±Provider=SQLOLEDB;Data Source=ProdServ01;¡± _
+ ¡°Initial Catalog=Pubs¡±+ ¡°Integrated Security=SSPI¡± A. Prodserv01 B. SQLOLEDB C. Pubs D. SSPI 61. C#.NETÖе¼ÈëÃû³Æ¿Õ¼äʱÓõ½µÄ¹Ø¼ü×ÖÊÇ£¨ B £©£¨Ã²ËÆ£©¡£
A£®imports B£®using C£®use D£®import 62 .NET¹¹¼ÜÖб»ÓÃÀ´·ÃÎÊÊý¾Ý¿âµÄ×é¼þ¼¯ºÏ³ÆΪ( A)(òËÆ)
A. ADO.NET B. COM+ C. ADO D. Data.Service.NET 63 ÔÚSQL SERVERÖоֲ¿±äÁ¿Ç°ÃæµÄ×Ö·ûΪ£º£¨ D £© A¡¢ * B¡¢ # C¡¢ @@ D¡¢ @
64.ÔÚWHILEÑ»·Óï¾äÖУ¬Èç¹ûÑ»·ÌåÓï¾äÌõÊý¶àÓÚÒ»Ìõ£¬±ØÐëʹÓ㺣¨ A£©
A¡¢ BEGIN??END B¡¢ CASE??END C¡¢ IF????THEN D¡¢ GOTO
65 ¡¢SELECT²éѯÖУ¬Òª°Ñ½á¹ûÖеÄÐа´ÕÕijһÁеÄÖµ½øÐÐÅÅÐò£¬ËùÓõ½µÄ×Ó¾äÊÇ£º£¨ A £©
A¡¢ ORDER BY B¡¢WHERE C¡¢GROUP BY D¡¢HAVING
66. ÔÚSELECTÓï¾äµÄWHERE×Ó¾äµÄÌõ¼þ±í´ïʽÖУ¬¿ÉÒÔÆ¥Åä0¸öµ½¶à¸ö×Ö·ûµÄͨÅä·ûÊÇ£¨ B £©
A ¡¢ * B¡¢% C¡¢ Ï»®Ïß
67ÔÚADO.NETÖУ¬ÏÂÁйØÓÚDataSetÀà˵·¨´íÎóµÄÊÇ£¨BC £©¡££¨Ñ¡Ôñ¶þÏ
a) ÔÚDataSetÖУ¬¿ÉÒÔ°üº¬¶à¸öDataTable
b) ÐÞ¸ÄDataSetÖеÄÊý¾Ýºó£¬Êý¾Ý¿âÖеÄÊý¾Ý¿ÉÒÔ×Ô¶¯¸üРc) ÔÚÓëÊý¾Ý¿â¶Ï¿ªÁ¬½Óºó£¬DataSetÖеÄÊý¾Ý»áÏûʧ d) DataSetʵ¼ÊÉÏÊÇ´ÓÊý¾ÝÔ´ÖмìË÷µÄÊý¾ÝÔÚÄÚ´æÖеĻº´æ
68 ADO.NETµÄ£¨ C £©¶ÔÏóÓÃÀ´½¨Á¢Ó¦ÓóÌÐòÓëÊý¾Ý¿âµÄÁ¬½Ó¡££¨Ñ¡ÔñÒ»Ï(ÎÊÎʵĴð°¸)
a)DataSet b)DataReader c)Connection d)Command
69ÔÚʹÓÃADO.NET Éè¼ÆÊý¾Ý¿âÓ¦ÓóÌÐòʱ,¿Éͨ¹ýÉèÖÃConnection ¶ÔÏóµÄ( A )ÊôÐÔÀ´Ö¸¶¨Á¬½Óµ½Êý¾Ý¿âʱµÄÓû§ºÍÃÜÂëÐÅÏ¢.
A. ConnectionString B. DataSource C. UserInformation D. Provider
70( A ) ·½·¨Ö´ÐÐÖ¸¶¨ÎªCommand¶ÔÏóµÄÃüÁîÎı¾µÄSQLÓï¾ä£¬²¢·µ»ØÊÜSQLÓï¾äÓ°Ïì»ò¼ìË÷µÄÐÐÊý¡£
A)ExecuteNonQuery B)ExecuteReader C)ExecuteQuery D)ExecuteScalar
71 ÔÚADO.NETÖУ¬SqlConnection ÀàËùÔÚµÄÃüÃû¿Õ¼äÊÇ£¨ D £©¡£ a) System b) System.Data c) System.Data.OleDb d) System.Data.SqlClient
72ÔÚADO.NET ÖУ¬¶ÔÓÚCommand¶ÔÏóµÄExecuteNonQuery()·½·¨ºÍExecuteReader()·½·¨£¬ÏÂÃæÐðÊö´íÎóµÄÊÇ( C ).
A) insert,update£¬deleteµÈ²Ù×÷µÄSQLÓï¾äÖ÷ÒªÓÃExecuteNonQuery()
·½·¨À´Ö´ÐÐ
B) ExecuteNonQuery()·½·¨·µ»ØÖ´ÐÐSQLÓï¾äËùÓ°ÏìµÄÐÐÊý C) Select²Ù×÷µÄSQLÓï¾äÖ»ÄÜÓÉExecuteReader()·½·¨À´Ö´ÐÐ D) ExecuteReader()·½·¨·µ»ØÒ»¸öDattaReader¶ÔÏó 73ʹÓÃ( D )¶ÔÏóÀ´ÏòDataSetÖÐÌî³äÊý¾Ý
A) Connection B) Command C) DataReader D) DataAdapter
73 Ϊ·ÃÎÊSQL Server 2000Êý¾Ý¿âÖеÄÊý¾Ý£¬×îºÃʹÓÃÒÔÏÂÄÇÖÖ.NETÊý¾ÝÌṩ
ÕßÁ¬½Óµ½Êý¾Ý¿â£¨A£©
A SQL Server.NET B OLEDB.NET C ODBC.NET D XML.NET 74 ±éÀúÒ»¸öº¬µ¥¸ö½á¹û¼¯µÄSqlDataReader¶ÔÏóµÄÕýÈ·Óï¾äÊÇ£¨A£©¡£ A while£¨x.Read£¨£©£©{
for£¨int i=0£»i for£¨int i=0£»i 1. SQLÓïÑÔÌṩÊý¾Ý¿â¶¨Òå¡¢_Êý¾Ý²Ù×ݹ¦ÄÜ_______¡¢Êý¾Ý¿ØÖƵȹ¦ÄÜ¡£ 2. ¹Øϵ´úÊýÖÐרÃŵĹØϵÔËËã°üÀ¨£ºÑ¡Ôñ¡¢Í¶Ó°¡¢ Á¬½Ó___ºÍ ³ý·¨ 3.¹ØϵÊý¾ÝÄ£ÐÍÖУ¬Á½¸ö¹ØϵR1ÓëR2Ö®¼ä´æÔÚ1¡ÃMµÄÁªÏµ£¬¿ÉÒÔͨ¹ýÔÚÒ»¸ö¹ØϵR2ÖеÄ__Íⲿ¹Ø¼ü×ÖÖµ______ÔÚÏà¹ØÁªµÄÁíÒ»¸ö¹ØϵR1ÖмìË÷Ïà¶ÔÓ¦µÄ¼Ç¼¡£ 4.Êý¾Ý¿âµÄÂ߼ģÐÍÉè¼Æ½×¶Î£¬ÈÎÎñÊǽ«__×ÜÌåE-RÄ£ÐÍ______ת»»³É¹ØϵģÐÍ¡£ 5.Êý¾Ý¿â±íÖÐÖ÷ÂëµÄÈ¡Öµ±ØÐëΨһÇÒ·Ç¿Õ£¬ÕâÌõ¹æÔòÊÇ__ʵÌå______ÍêÕûÐÔ¹æÔò¡£ 6Êý¾Ý¿âÉè¼Æ·ÖΪÒÔÏÂÁù¸öÉè¼Æ½×¶Î£ºÐèÇó·ÖÎö½×¶Î¡¢_¸ÅÄî½á¹¹Éè¼Æ_______¡¢Âß ¼½á¹¹Éè¼Æ________¡¢Êý¾Ý¿âÎïÀíÉè¼Æ½×¶Î¡¢Êý¾Ý¿âʵʩ½×¶Î¡¢Êý¾Ý¿âÔËÐÐºÍ Î¬»¤½×¶Î¡£ 7.ÀúÊ·ÉÏ3ÖÖ½ÏÁ÷ÐеÄÊý¾ÝÄ£ÐÍÓУº²ã´ÎÄ£ÐÍ¡¢_Íø×´Ä£ÐÍ_¡¢¹ØϵÊý¾ÝÄ£ÐÍ¡£ 8 Êý¾Ý¹ÜÀí¾ÀúÁË_È˹¤¹ÜÀí½×¶Î_______¡¢Îļþ¹ÜÀí_½×¶Î____¡¢___Êý¾Ý¿â¹Ü Àí½×¶Î_____Èý¸ö·¢Õ¹½×¶Î¡£ 9ÎïÀíÊý¾Ý¶ÀÁ¢ÐÔ ÊÇÖ¸Êý¾Ý¿âµÄÎïÀí½á¹¹¸Ä±äʱ£¬¾¡Á¿²»Ó°ÏìÕûÌåÂß¼½á¹¹¡¢Óû§µÄÂß¼½á¹¹ÒÔ¼°Ó¦ÓóÌÐò¡£ 10Êý¾ÝÂß¼¶ÀÁ¢ÐÔ______ÊÇÊý¾Ý¿âµÄÕûÌåÂß¼½á¹¹¸Ä±äʱ£¬¾¡Á¿²»Ó°ÏìÓû§µÄÂß¼½á¹¹ÒÔ¼°Ó¦ÓóÌÐò¡£ 11Óû§Óë²Ù×÷ϵͳ֮¼äµÄÊý¾Ý¹ÜÀíÈí¼þÊÇ_Êý¾Ý¿â¹ÜÀíϵͳ________¡£ 12¸ù¾Ý²»Í¬µÄÊý¾ÝÄ£ÐÍ£¬Êý¾Ý¿â¹ÜÀíϵͳ¿ÉÒÔ·ÖΪ²ã´ÎÐÍ¡¢Íø×´ÐÍ¡¢¹ØϵÐÍ ºÍÃæÏò¶ÔÏóÐÍ¡£ 13Êý¾ÝÄ£ÐÍÓÉ__Êý¾Ý½á¹¹________¡¢_Êý¾Ý²Ù×÷_________ºÍ__Êý¾ÝÍêÕûÐÔÔ¼Êø___ÈýÒªËØ×é³É¡£ 14ÏÖʵÊÀ½çµÄÊÂÎï·´Ó³µ½È˵ÄÍ·ÄÔÖо¹ý˼ά¼Ó¹¤³ÉÊý¾Ý£¬ÕâÒ»¹ý³ÌÒª¾¹ýÈý¸öÁìÓò£¬ÒÀ´ÎÊÇ_ÏÖʵÊÀ½ç________¡¢_ÐÅÏ¢ÊÀ½ç_________ºÍ___Êý¾ÝÊÀ½ç__¡£ 15ÏÖʵÊÀ½çÖУ¬ÊÂÎïµÄ¸öÌåÔÚÐÅÏ¢ÊÀ½çÖгÆΪ___ʵÌå_____£¬ÔÚ»úÆ÷ÊÀ½çÖгÆΪ_¼Ç¼______¡£ 16ÄÜΨһ±êʶʵÌåµÄÊôÐÔ¼¯£¬³ÆΪ____Âë_____¡£ 17£®ÊôÐÔµÄÈ¡Öµ·¶Î§³ÆΪ¸ÃÊôÐÔµÄ____Óò_____¡£ 18£®Á½¸ö²»Í¬ÊµÌ弯µÄʵÌå¼äÓÐ__Ò»¶ÔÒ»_______¡¢___Ò»¶Ô¶à______ºÍ____ ¶à¶Ô¶à_____ÈýÖÖÇé¿öÁªÏµ¡£ 19¹ØϵģʽR£¨A£¬B£¬C£©ºÍS£¨E£¬A£¬F£©£¬ÈôR.AÊÇRµÄÖ÷Â룬S.AÊÇSµÄÍâÂ룬ÔòS.AµÄÖµ»òÕßµÈÓÚRÖÐij¸öÔª×éµÄÖ÷ÂëÖµ£¬»òÕßÈ¡¿ÕÖµ£¨null£©¡£ÕâÊÇ ²Î ÕÕ ÍêÕûÐÔ¹æÔò¡£ 20 ÓÐѧÉúÐÅÏ¢±ístudent£¬ÇóÄêÁäÔÚ20¡«22ËêÖ®¼ä(º¬20ËêºÍ22Ëê)µÄѧÉúÐÕÃûºÍÄêÁäµÄSQLÓï¾äÊÇ£ºSELECT sname,age FROM student WHERE age___ _BETWEEN 20 AND 22 ____¡£ 21 ÔÚSQLÓïÑÔÖУ¬ÈôҪɾ³ýÒ»¸ö±í£¬Ó¦Ê¹ÓõÄÓï¾äÊÇ__ DROP ______TABLE¡£ 22 Êý¾Ý¿âϵͳµÄÂß¼Éè¼ÆÖ÷ÒªÊǽ«__¸ÅÄîÄ£ÐÍ _____ת»¯³ÉDBMSËùÖ§³ÖµÄÊý¾ÝÄ£ÐÍ¡£ 23Èç¹û²ÉÓùØϵÊý¾Ý¿âÀ´ÊµÏÖÓ¦Óã¬ÔòÔÚÊý¾Ý¿âµÄÂß¼Éè¼Æ½×¶ÎÐ轫__ E-RÄ£ ÐÍ _ת»¯Îª¹ØϵģÐÍ¡£ 24 SQL Server2000ÓÐÁ½ÖÖ°²È«ÈÏ֤ģʽ£¬¼´Windows°²È«ÈÏ֤ģʽºÍ »ìºÏ ÈÏ֤ģʽ ¡£ 25 SQL Server 2000µÄÎļþ°üÀ¨: Êý¾ÝÎļþ£¨.mdf»ò.ndf£©ºÍ ÈÕÖ¾Îļþ Èý¡¢Ãû´Ê½âÊÍ(ÿСÌâ4·Ö£¬¹²16·Ö) 1.ÊÂÎñ£ºÊÇÖ¸·ÃÎʲ¢¿ÉÄܸüÐÂÊý¾Ý¿âÖи÷ÖÖÊý¾ÝÏîµÄÒ»¸ö³ÌÐòÖ´Ðе¥Ôª 2.DBA£ºÊÇÒ»¸ö¸ºÔð¹ÜÀíºÍά»¤Êý¾Ý¿â·þÎñÆ÷µÄÈË¡£Êý¾Ý¿â¹ÜÀíÔ±¸ºÔðÈ«Ãæ¹ÜÀíºÍ¿ØÖÆÊý¾Ý¿âϵͳ¡£Õâ¸öְλ¶Ô²»Í¬µÄÈËÒâζ×Ų»Í¬µÄÒâÒå