1、吉大18春學期數據庫應用技術在線作業二-0002試卷總分:100 得分:100一、單選題 (共 25 道試題,共 100 分)發人員開發訪問后臺AIX上的DB2的windows程序，需要在windows開發平臺上安裝：DB2運行時間客戶端DB2管理客戶端DB2應用程序開發客戶端DB2瘦客戶端答案:C2.關系數據庫管理系統應能實現的專門關系運算包括（）排序、索引、統計選擇、投影、連接關聯、更新、排序顯示、打印、制表答案:B3.下列SQL語句中，能夠實現”收回U4對學生表(STUD)中學號(XH)的修改權”這一功能的是以下哪項？REVOKE UPDATE(XH) ON TABLE FROM U4R

2、EVOKE UPDATE(XH) ON TABLE FROM PUBLICREVOKE UPDATE(XH) ON STUD FROM U4REVOKE UPDATE(XH) ON STUD FROM PUBLIC答案:C4.下面哪個工具可以保存終端用戶需要存取的元數據？Query Management FacilityDB2 Query PatrollerDB2存儲過程構建器信息目錄答案:D5.如果選用循環日志方式，輔助日志文件何時分配？數據庫建立的時候數據庫服務器啟動的時候需要的時候以上都不對答案:C6.并發控制的主要方法是采用以下哪種機制？口令鎖副本檢查點答案:B7.在SELECT語句的

3、下列子句中，通常和HAVING子句同時使用的是以下哪項？ORDER BY子句WHERE子句GROUP BY子句均不需要答案:C8.下列哪種工具可以向表中增添記錄，并更改數據庫的統計信息？importinsertloadupdate答案:C9.Which of the following is a benefit of user-defined functions?Improves application concurrencyImproves blocking of result setsSimplifies application maintenanceReduces memory requ

4、irements on the server答案:C10.關系模型中的關系模式至少是（）1NF2NF3NFBCNF答案:A11.對于支持小規模的部門級應用，這些應用不需要存取駐留在OS/400、OS/390等平臺上的遠程數據庫，則需要哪種級別的DB2 產品？企業版工作組版企業擴展版個人版衛星版微型版答案:B12.SQL語言具有（）功能。關系規范化、數據操縱、數據控制數據定義、數據操縱、數據控制數據定義、關系規范化、數據控制數據定義、關系規范化、數據操縱答案:B13.下面哪一工具允許用戶開發存儲過程？控制中心命令中心任務中心開發中心健康中心答案:D14.Given the expression:

5、 WITH most_cities AS ( SELECT b.id,,a.cities FROM country a, staff b WHERE a.person = b.id AND cities :threshold ) SELECT * FROM most_cities In which of the following does MOST_CITIES exist?user tablesserver memoryuser table spacesystem catalog tables答案:B15.定義基本表時，若要求某一列的值不能為空，則應在定義時使用什么保留字？但如

6、果該列是主鍵，則可省寫。NULLNOT NULLDISTINCTUNIQUE答案:B16.如果需要創建一個表，并把表中的索引數據和其他數據分開存儲，則應該建立兩個SMS表空間分別存儲索引數據和其他數據建立兩個DMS表空間分別存儲索引數據和其他數據建立一個DMS表空間存儲索引數據，再建立一個SMS表空間存儲其他數據建立一個SMS表空間存儲索引數據，再建立一個DMS表空間存儲其他數據答案:B17.A cursor is declared with the WITH HOLD option. Which of the following statements is always true?The c

7、ursor will remain open after a COMMIT.All rows retrieved are locked until a COMMIT.A COMMIT will not be allowed until the cursor is closed.Locks obtained by the cursor will be kept after a COMMIT.答案:A18.據庫系統和文件系統的主要區別是：數據庫系統復雜，而文件系統簡單。文件系統不能解決數據冗余和數據獨立性問題，而數據庫系統可以解決。文件系統只能管理程序文件，而數據庫系統能夠管理各種類型的文件。文件

8、系統管理的數據量較少，而數據庫系統可以管理龐大的數據量。答案:B19.Given the tables: COUNTRY STAFF id name person cities id name 1 Argentina 1 10 1 Aaron 2 Canada 2 20 2 Adams 3 Cuba 2 10 3 Jones 4 Germany 1 0 5 France 3 5 6 Italy 1 5 the report: id name number_of_countries - - - 1 Aaron 3 and the SQL statement: SELECT B.id,B.name

9、,COUNT(DISTINCT A.name) AS number_of_countries FROM country A, staff B WHERE B.id=A.person GROUP BY B.id,B.name HAVING COUNT(DISTINCT A.name):count_var Which of the following values does :count_var require to print out the above report?1234答案:B20.Given the code: EXEC SQL WITH most_cities AS ( SELECT

10、 b.id, , a.cities FROM country a, staff b WHERE a.person = b.id AND cities :threshold ) SELECT id, name, cities FROM most_cities INTO :id, :name, :cities WHERE cities IN (SELECT MAX(cities) FROM most_cities) Which of the following can reference MOST_CITIES?The current statementStatements from

11、any applicationAll statements within this applicationAll statements within the current unit of work答案:A21.缺省的數據庫日志文件的類型是：Circular LogArchival LogPrimary LogSecondary log答案:A22.An ODBC/CLI application has the following pseudocode: SQLAllocHandle( SQL_HANDLE_DBC, hEnv, &hDbc ) SQLConnect( hDbc, CERTDB

12、, 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,

13、SELECT * FROM user1.table1 t1, table2 t2 WHERE t1.col1=t2.col2, SQL_NTS )SQLExecDirect( hStmt, SELECT * FROM user1.table1 t1, table2 t2 WHERE t1.col1=t2.col2, SQL_NTS ). SQLExecDirect( hStmt, SELECT * FROM user1.table1 t1, user1.table2 t2 WHERE t1.col1=t2.col2, SQL_NTS ). SQLExecDirect( hStmt, SELEC

14、T * FROM user1.table1 t1, db2cert.table2 t2 WHERE t1.col1=t2.col2, SQL_NTS ). SQLExecDirect( hStmt, SELECT * FROM db2cert.table1 t1, db2cert.table2 t2 WHERE t1.col1=t2.col2, SQL_NTS )答案:C23.How many rows can be retrieved using a single SELECT INTO statement?Only one rowAs many as are in the resultAs

15、 many as are host variables used in the callAs many as host variable array structures can hold答案:A24.Given the application code: EXEC SQL DECLARE cur CURSOR WITH HOLD FOR SELECT c1 FROM t1 EXEC SQL OPEN cur EXEC SQL FETCH cur INTO :hv /* Statement 1 */ EXEC SQL COMMIT /* Statement 2 */ EXEC SQL FETCH cur INTO :hv /* Statement 3 */ EXEC SQL ROLLBACK /* Statement 4 */ EXEC SQL CLOSE cur /* St