吉大数据库应用技术在线作业一答案.docx

吉大《数据库应用技术》在线作业一答案 试卷总分：100 测试时间：-- 试卷得分：100 单选题 一、单选题(共 25道试题，共100分。 得分：100V Give n the followi ng table: TestTable C1 12345 And if the following CLI calls are made: SQLAIIocHa ndle(SQL_HANDLE_ENV ,SQL_NULL_HANDLE，henv); SQLSetE nvAttr( henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3,0); SQL AllocHa ndle(SQL_HANDLE_DBC,he nv,hdbc); SQLCo nn ect( hdbc, (SQLCHAR *)db, SQL_NTS, (SQLCHAR *)userid, SQL_NTS, (SQLCHAR「password, SQL_NTS ); SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF, 0); SQLAllocHa ndle(SQL_HANDLE_STMT,hdbc,hstmt); SQLPrepare(hstmt,(u nsig ned char*)select *from Test order by C1,SQL_NTS); SQLBindCol(hstmt,1,SQL_C_SHORT,data,0,NULL); SQLExecute(hstmt); SQLFetch(hstmt); printf(Data:%i\n,data); SQLFetch(hstmt); prin tf(Data:%i\n,data); SQLFetch(hstmt); prin tf(Data:%i\n,data); SQLE ndTra n( SQL_HANDLE_ENV ,he nv,SQL_COMMIT); SQLFetch(hstmt); prin tf(Data:%i\n,data); Which of the follow ing will be retur ned by the program? Data: 1 Data: 2 Data: 3 Data: 3 Data: 1 Data: 2 Data: 3 Data: 4 Data: 1 Data: 2 Data: 3 Data: 1 Data: 1 Data: 2 Data: 3 Data: 5 满分：4分得分：4 Give n the code: EXEC SQL DECLARE cursor1 CURSOR FOR SELECT name,age,b_date FROM pers on; EXEC SQL OPEN cursor1; Un der which of the following situations will the above cursor be implicitly closed? When a CLOSE stateme nt is issued When a COMMIT stateme nt is issued When there are no rows in the result set When all rows are FETCHed from the result set 满分：4分得分：4 Give n the applicatio n code: EXEC SQL DECLARE cur CURSOR WITH HOLD FOR SELECT c1 FROM t1 EXEC SQL OPEN cur EXEC SQL FETCH cur INTO :hv /* Stateme nt 1 */ EXEC SQL COMMIT /* Stateme nt 2 */ EXEC SQL FETCH cur INTO :hv /* Stateme nt 3 */ EXEC SQL ROLLBACK /* Stateme nt 4 */ EXEC SQL CLOSE cur /* Stateme nt 5 */ If the table T1 has no rows in it, which stateme nt will cause the cursor cur to be closed first? Stateme nt 1 Stateme nt 2 Stateme nt 3 Stateme nt 4 满分：4分得分：4 How many rows can be retrieved using a sin gle SELE