1、吉大18春學(xué)期數(shù)據(jù)庫應(yīng)用技術(shù)在線作業(yè)二-0002試卷總分:100 得分:100一、單選題 (共 25 道試題,共 100 分)發(fā)人員開發(fā)訪問后臺AIX上的DB2的windows程序，需要在windows開發(fā)平臺上安裝：DB2運(yùn)行時(shí)間客戶端DB2管理客戶端DB2應(yīng)用程序開發(fā)客戶端DB2瘦客戶端答案:C2.關(guān)系數(shù)據(jù)庫管理系統(tǒng)應(yīng)能實(shí)現(xiàn)的專門關(guān)系運(yùn)算包括（）排序、索引、統(tǒng)計(jì)選擇、投影、連接關(guān)聯(lián)、更新、排序顯示、打印、制表答案:B3.下列SQL語句中，能夠?qū)崿F(xiàn)”收回U4對學(xué)生表(STUD)中學(xué)號(XH)的修改權(quán)”這一功能的是以下哪項(xiàng)？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.下面哪個(gè)工具可以保存終端用戶需要存取的元數(shù)據(jù)？Query Management FacilityDB2 Query PatrollerDB2存儲過程構(gòu)建器信息目錄答案:D5.如果選用循環(huán)日志方式，輔助日志文件何時(shí)分配？數(shù)據(jù)庫建立的時(shí)候數(shù)據(jù)庫服務(wù)器啟動的時(shí)候需要的時(shí)候以上都不對答案:C6.并發(fā)控制的主要方法是采用以下哪種機(jī)制？口令鎖副本檢查點(diǎn)答案:B7.在SELECT語句的

3、下列子句中，通常和HAVING子句同時(shí)使用的是以下哪項(xiàng)？ORDER BY子句WHERE子句GROUP BY子句均不需要答案:C8.下列哪種工具可以向表中增添記錄，并更改數(shù)據(jù)庫的統(tǒng)計(jì)信息？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.關(guān)系模型中的關(guān)系模式至少是（）1NF2NF3NFBCNF答案:A11.對于支持小規(guī)模的部門級應(yīng)用，這些應(yīng)用不需要存取駐留在OS/400、OS/390等平臺上的遠(yuǎn)程數(shù)據(jù)庫，則需要哪種級別的DB2 產(chǎn)品？企業(yè)版工作組版企業(yè)擴(kuò)展版?zhèn)€人版衛(wèi)星版微型版答案:B12.SQL語言具有（）功能。關(guān)系規(guī)范化、數(shù)據(jù)操縱、數(shù)據(jù)控制數(shù)據(jù)定義、數(shù)據(jù)操縱、數(shù)據(jù)控制數(shù)據(jù)定義、關(guān)系規(guī)范化、數(shù)據(jù)控制數(shù)據(jù)定義、關(guān)系規(guī)范化、數(shù)據(jù)操縱答案:B13.下面哪一工具允許用戶開發(fā)存儲過程？控制中心命令中心任務(wù)中心開發(fā)中心健康中心答案: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.定義基本表時(shí)，若要求某一列的值不能為空，則應(yīng)在定義時(shí)使用什么保留字？但如

6、果該列是主鍵，則可省寫。NULLNOT NULLDISTINCTUNIQUE答案:B16.如果需要創(chuàng)建一個(gè)表，并把表中的索引數(shù)據(jù)和其他數(shù)據(jù)分開存儲，則應(yīng)該建立兩個(gè)SMS表空間分別存儲索引數(shù)據(jù)和其他數(shù)據(jù)建立兩個(gè)DMS表空間分別存儲索引數(shù)據(jù)和其他數(shù)據(jù)建立一個(gè)DMS表空間存儲索引數(shù)據(jù)，再建立一個(gè)SMS表空間存儲其他數(shù)據(jù)建立一個(gè)SMS表空間存儲索引數(shù)據(jù)，再建立一個(gè)DMS表空間存儲其他數(shù)據(jù)答案: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.據(jù)庫系統(tǒng)和文件系統(tǒng)的主要區(qū)別是：數(shù)據(jù)庫系統(tǒng)復(fù)雜，而文件系統(tǒng)簡單。文件系統(tǒng)不能解決數(shù)據(jù)冗余和數(shù)據(jù)獨(dú)立性問題，而數(shù)據(jù)庫系統(tǒng)可以解決。文件系統(tǒng)只能管理程序文件，而數(shù)據(jù)庫系統(tǒng)能夠管理各種類型的文件。文件

8、系統(tǒng)管理的數(shù)據(jù)量較少，而數(shù)據(jù)庫系統(tǒng)可以管理龐大的數(shù)據(jù)量。答案: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.缺省的數(shù)據(jù)庫日志文件的類型是：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