吉大17春秋学期《数据库应用技术》在线作业二.docVIP

一、单选题（共 25 道试题，共 100 分。） V 1. Given the following code: BEGIN ATOMIC UPDATE country SET cities=:count WHERE CURRENT OF C1; INSERT INTO country VALUES(:co11,:co12,:co13); INSERT INTO country VALUES(:co14,:co15,:co16); INSERT INTO country VALUES(:co17,:co18,:co19); INSERT INTO country VALUES(:co110,:co111,:co112); COMMIT; END Given that all statements succeed except the following: INSERT INTO country VALUES(:co17,:co18,:co19); How many rows will be affected in table COUNTRY? A. 0 B. 3 C. 4 D. 5 2. Which of the following will retrieve results that will only be in lower case? A. SELECT NAME FROM EMPLOYEE WHERE NAME=ali B. SELECT NAME FROM EMPLOYEE WHERE LCASE(NAME)=ali C. SELECT UCASE(NAME) FROM EMPLOYEE WHERE LCASE(NAME)=ali D. SELECT NAME FROM EMPLOYEE WHERE NAME IN (SELECT NAME FROM EMPLOYEE WHERE LCASE(NAME)=LCASE(ALI)) 3. 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 ) 4. Which of the following produces a sequentially increasing number, suitable for use as a primary key? A. ROWID data type B. Generated IDENTITY column C. GENERATE_UNIQUE built-in function D. CURRENT SEQUENCE special register 5. 下面哪个工具提供了