奥鹏17春吉大16秋学期《数据库应用技术》在线作业一一、单选题（共25道试题，共100分。）1.对于UNIX和Intel平台上的数据库应用，如果需要存取OS/400、VM/VSE和OS/390系统上的数据库，需要DB2哪种产品的支持？A.DB2ConnectB.DB2DataPropagatorC.DB2Net.DataD.DB2DataJoinerE.DB2RelationalConnect正确答案：2.AcursorisdeclaredwiththeWITHHOLDoption.Whichofthefollowingstatementsisalwaystrue?A.ThecursorwillremainopenafteraCOMMIT.B.AllrowsretrievedarelockeduntilaCOMMIT.C.ACOMMITwillnotbealloweduntilthecursorisclosed.D.LocksobtainedbythecursorwillbekeptafteraCOMMIT.正确答案：3.发人员开发访问后台AIX上的DB2的windows程序，需要在windows开发平台上安装：A.DB2运行时间客户端B.DB2管理客户端C.DB2应用程序开发客户端D.DB2瘦客户端正确答案：4.Giventhefollowingtable:TestTableC1-----------12345AndifthefollowingCLIcallsaremade:SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&henv);SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(SQLPOINTER)SQL_OV_ODBC3,0);SQLAllocHandle(SQL_HANDLE_DBC,henv,&hdbc);SQLConnect(hdbc,(SQLCHAR*)"db",SQL_NTS,(SQLCHAR*)"userid",SQL_NTS,(SQLCHAR*)"password",SQL_NTS);SQLSetConnectAttr(hdbc,SQL_ATTR_AUTOCOMMIT,SQL_AUTOCOMMIT_OFF,0);SQLAllocHandle(SQL_HANDLE_STMT,hdbc,&hstmt);SQLPrepare(hstmt,(unsignedchar*)"select*fromTestorderbyC1',SQL_NTS);SQLBindCol(hstmt,1,SQL_C_SHORT,&data,0,NULL);SQLExecute(hstmt);SQLFetch(hstmt);printf(Data:%i\n",data);SQLFetch(hstmt);printf(Data:%i\n",data);SQLFetch(hstmt);printf(Data:%i\n",data);SQLEndTran(SQL_HANDLE_ENV,henv,SQL_COMMIT);SQLFetch(hstmt);printf(Data:%i\n",data);Whichofthefollowingwillbereturnedbytheprogram?A.Data:1Data:2Data:3Data:3B.Data:1Data:2Data:3Data:4C.Data:1Data:2Data:3Data:1D.Data:1Data:2Data:3Data:5正确答案：5.Thefollowingcommandsareissuedagainstadatasource:CREATETABLEuserid.org(iINT)CREATEALIASuser1.orgFORuserid.orgCREATETABLEorg.sample(cCHAR(1))CREATEALIASsample.orgFORuserid.orgCREATEALIASuserid.sampleFORsample.orgWhenissuedbyUSER1,whichofthefollowingstatementswillhaveadifferentresultsetthanthisSELECTstatement?SELECT*FROMorgA.SELECT*FROMorg.sampleB.SELECT*FROMsample.orgC.SELECT*FROMuserid.orgD.SELECT*FROMuserid.sample正确答案：6.DBMS是（）A.操作系统的一部分B.在操作系统支持下的系统软件C.一种编译程序D.应用程序系统正确答案：7.嵌入式SQL语句中引用共享变量时，必须在变量名前加什么标志？A.号B.分号C.句号D.冒号正确答案：8.GiventhetablesT1andT2,eachwithanINTEGERcolumn:T1COL1-----------1-1-22T2COL1-----------1-2-22andthefollowingquerythatexecutessuccessfully:SELECT*FROMT1LEFTOUTERJOINT2ONT1.COL1=T2.COL1Howmanyrowswillthequeryreturn?A.5B.6C.10D.36正确答案：9.Giventhetables:COUNTRYSTAFFidnamepersoncitiesidname1Argentina1101Aaron2Canada2202Adams3Cuba2103Jones4Germany105France356Italy15thereport:idnamenumber_of_countries---------------------------------------1Aaron3andtheSQLstatement:SELECTB.id,B.name,COUNT(DISTINCTA.name)ASnumber_of_countriesFROMcountryA,staffBWHEREB.id=A.personGROUPBYB.id,B.nameHAVINGCOUNT(DISTINCTA.name)>:count_varWhichofthefollowingvaluesdoes:count_varrequiretoprintouttheabovereport?A.1B.2C.3D.4正确答案：10.WhichofthefollowingisusedtorunanembeddeddynamicSQLUPDATEstatement?A.UPDATEB..PREPAREC..DECLARED..EXECUTE正确答案：11.HowmanyrowscanberetrievedusingasingleSELECTINTOstatement?A.OnlyonerowB.AsmanyasareintheresultC.AsmanyasarehostvariablesusedinthecallD.Asmanyashostvariablearraystructurescanhold正确答案：12.下面哪个工具可以帮助用户对语句性能进行...
