资源描述：
《百一测评——asp存取数据库》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、职业技能题库&在线云笔试平台http://www.101test.Com试卷名称：ASP存取数据库试卷描述：IT笔试题目、招聘笔试、微信考试、在线考试试卷链接：http://www.101test.com/store/open/paperInfo/41739试卷限时：50分一.不定项选择题每题分值：2.5分是否题目乱序：是是否选项乱序：是是否可回溯：是难度：中1.[不定项]就8.2节示例而言，下面哪个数据库连接字符串是正确的？A."Dsn=address"B."Driver={MicrosoftAccessDriver(*.mdb)};Dbq="&Serve
2、r.MapPath("address.mdb")C."Driver={MicrosoftAccessDriver(*.mdb)};Dbq="&Server.MapPath("asptempchapter8address.mdb")D."Provider=Microsoft.Jet.OLEDB.4.0;DataSource="&Server.MapPath("asptempchapter8address.mdb")答案：ABCD2.[不定项]在8-1.asp中，如果要查询thedate（时间变量）以后添加的记录，SQL字符串应为：A."Select
3、*FromtbAddressWheredtmSubmit>#thedate#"B."Select*FromtbAddressWheredtmSubmit>#"&thedate&"#"第13页职业技能题库&在线云笔试平台http://www.101test.ComC."Select*FromtbAddressWheredtmSubmit>"&#thedate#&"D."Select*FromtbAddressWheredtmSubmit>"&thedate答案：B1.[不定项]在8-1.asp中，如果要查询年龄大于theAge（数值变量）的人员，SQL字符串应
4、该为：A."Select*FromtbAddressWhereintAge>theAge"B."Select*FromtbAddressWhereintAge>'"&theAge&"'"C."Select*FromtbAddressWhereintAge>"&'theAge'&"D."Select*FromtbAddressWhereintAge>"&theAge答案：D2.[不定项]就本章示例而言，下面哪条SQL语句可以正确执行？（其中theName="卢红"theAge=22theDate=#2008-8-8#）A."Select*FromtbAddre
5、ssWherestrName="&theNameB."SelectstrName,intAgeFromtbAddresswherestrName='"&theName&"'"C."Select*FromtbAddressWhereintAge#theDate#"答案：B3.[不定项]就本章示例而言，下面哪条SQL语句可以正确添加记录？（其中theName="卢红"theAge=22theIntro=""）A."InsertIntotbAddress(strName,i
6、ntAge,strIntro)Values('theName',theAge,'theIntro')"B."InsertIntotbAddress(strName,intAge,strIntro)Values('"&theName&"',"&theAge&",'"&theIntro&"')"第13页职业技能题库&在线云笔试平台http://www.101test.ComC."InsertIntotbAddress(strName,intAge,strIntro)Values("&theName&","&theAge&","&theIntro&")"D."In
7、sertIntotbAddress(strName,intAge,strIntro)Values('"&theName&"','"&theAge&"','"&theIntro&"')"答案：BD1.[不定项]就本章示例而言，下面哪条SQL语句可以正确更新记录？（其中theName="卢红"theAge=22theIntro=""theID=5）A."UpdatetbAddressSetstrName='theName',intAge=theAge,strIntro='theIntro'WhereID=theID"B."UpdatetbAddressSetst
8、rName='"&theName&"',intAge
