|
11.An ODBC/CLI application has the following pseudocode: SQLAllocHandle( SQL_HANDLE_DBC, hEnv, &hDbc ) SQLConnect( hDbc, "CERTDB", SQL_NTS, "user1", SQL_NTS, "passwd", SQL_NTS ) SQLAllocHandle( SQL_HANDLE_STMT, hDbc, &hStmt ) SQLExecDirect( hStmt, "SET CURRENT SQLID db2cert", SQL_NTS ) Assuming all of the above calls execute successfully, which of the following fully qualified SQL statements is equivalent to: SQLExecDirect( hStmt, "SELECT * FROM user1.table1 t1, table2 t2 WHERE t1.col1=t2.col2", SQL_NTS ) A. SQLExecDirect( hStmt, "SELECT * FROM user1.table1 t1, table2 t2 WHERE t1.col1=t2.col2", SQL_NTS ) B. . SQLExecDirect( hStmt, "SELECT * FROM user1.table1 t1, user1.table2 t2 WHERE t1.col1=t2.col2", SQL_NTS ) C. . SQLExecDirect( hStmt, "SELECT * FROM user1.table1 t1, db2cert.table2 t2 WHERE t1.col1=t2.col2", SQL_NTS ) D. . SQLExecDirect( hStmt, "SELECT * FROM db2cert.table1 t1, db2cert.table2 t2 WHERE t1.col1=t2.col2", SQL_NTS ) 正确答案：C满分：4分 12.An ODBC/CLI application performs an array insert into a table containing a primary key. If one of the values inserted generates a duplicate row error, which of the following APIs can be called to determine the failing row? A. SQLError() B. SQLNumRows() C. SQLRowCount() D. SQLGetDiagField() 正确答案：D满分：4分 13.Given the table called NAME with the following column and data: lname ------ Smith SMITH SmiTh smith Which of the following SQL statements will return all four rows in upper case? A. SELECT CAPS(lname) FROM name B. SELECT UCASE(lname) FROM name C. SELECT STRUPR(lname) FROM name D. SELECT TOUPPER(lname) FROM name 正确答案：B满分：4分 14.事务的原子性是指（） A. 事务中包含的所有操作要么都做，要么都不做 B. 事务一旦提交，对数据库的改变是永久性的 C. 一个事务内部的操作及使用的数据对并发的其他事务是隔离的 D. 事务必须是使数据库从一个一致性状态变到另一个一致性状态 正确答案：A满分：4分 (责任编辑：admin)要这答案加QQ：800020900 或加微信：q800020900 获取 |
