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

: .
吉大《数据库应用技术》在线作业一答案
试卷总分：100 测试时间：-- 试卷得分：100
单选题
一、单选题(共 25道试题，共100分。 得分：100V
1. 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?
A. Data: 1 Data: 2 Data: 3 Data: 3
B. Data: 1 Data: 2 Data: 3 Data: 4
C. Data: 1 Data: 2 Data: 3 Data: 1
D. Data: 1 Data: 2 Data: 3 Data: 5
满分：4分得分：4
2. 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 situati