吉大19秋學(xué)期《數(shù)據(jù)庫(kù)應(yīng)用技術(shù)》在線作業(yè)二答案

1、吉大18春學(xué)期數(shù)據(jù)庫(kù)應(yīng)用技術(shù)在線作業(yè)二-0002試卷總分:100 得分:100一、單選題 (共 25 道試題,共 100 分)1.發(fā)人員開(kāi)發(fā)訪問(wèn)后臺(tái)AIX上的DB2的windows程序，需要在windows開(kāi)發(fā)平臺(tái)上安裝：A.DB2運(yùn)行時(shí)間客戶端B.DB2管理客戶端C.DB2應(yīng)用程序開(kāi)發(fā)客戶端D.DB2瘦客戶端答案:C2.關(guān)系數(shù)據(jù)庫(kù)管理系統(tǒng)應(yīng)能實(shí)現(xiàn)的專門(mén)關(guān)系運(yùn)算包括（）A.排序、索引、統(tǒng)計(jì)B.選擇、投影、連接C.關(guān)聯(lián)、更新、排序D.顯示、打印、制表答案:B3.下列SQL語(yǔ)句中，能夠?qū)崿F(xiàn)”收回U4對(duì)學(xué)生表(STUD)中學(xué)號(hào)(XH)的修改權(quán)”這一功能的是以下哪項(xiàng)？A.REVOKE UPDATE(X

2、H) ON TABLE FROM U4B.REVOKE UPDATE(XH) ON TABLE FROM PUBLICC.REVOKE UPDATE(XH) ON STUD FROM U4D.REVOKE UPDATE(XH) ON STUD FROM PUBLIC答案:C4.下面哪個(gè)工具可以保存終端用戶需要存取的元數(shù)據(jù)？A.Query Management FacilityB.DB2 Query PatrollerC.DB2存儲(chǔ)過(guò)程構(gòu)建器D.信息目錄答案:D5.如果選用循環(huán)日志方式，輔助日志文件何時(shí)分配？A.數(shù)據(jù)庫(kù)建立的時(shí)候B.數(shù)據(jù)庫(kù)服務(wù)器啟動(dòng)的時(shí)候C.需要的時(shí)候D.以上都不對(duì)答案:C6.并

3、發(fā)控制的主要方法是采用以下哪種機(jī)制？A.口令B.鎖C.副本D.檢查點(diǎn)答案:B7.在SELECT語(yǔ)句的下列子句中，通常和HAVING子句同時(shí)使用的是以下哪項(xiàng)？A.ORDER BY子句B.WHERE子句C.GROUP BY子句D.均不需要答案:C8.下列哪種工具可以向表中增添記錄，并更改數(shù)據(jù)庫(kù)的統(tǒng)計(jì)信息？A.importB.insertC.loadD.update答案:C9.Which of the following is a benefit of user-defined functions?A.Improves application concurrencyB.Improves blocki

4、ng of result setsC.Simplifies application maintenanceD.Reduces memory requirements on the server答案:C10.關(guān)系模型中的關(guān)系模式至少是（）A.1NFB.2NFC.3NFD.BCNF答案:A11.對(duì)于支持小規(guī)模的部門(mén)級(jí)應(yīng)用，這些應(yīng)用不需要存取駐留在OS/400、OS/390等平臺(tái)上的遠(yuǎn)程數(shù)據(jù)庫(kù)，則需要哪種級(jí)別的DB2 產(chǎn)品？A.企業(yè)版B.工作組版C.企業(yè)擴(kuò)展版D.個(gè)人版E.衛(wèi)星版F.微型版答案:B12.SQL語(yǔ)言具有（）功能。A.關(guān)系規(guī)范化、數(shù)據(jù)操縱、數(shù)據(jù)控制B.數(shù)據(jù)定義、數(shù)據(jù)操縱、數(shù)據(jù)控制C.數(shù)據(jù)

5、定義、關(guān)系規(guī)范化、數(shù)據(jù)控制D.數(shù)據(jù)定義、關(guān)系規(guī)范化、數(shù)據(jù)操縱答案:B13.下面哪一工具允許用戶開(kāi)發(fā)存儲(chǔ)過(guò)程？A.控制中心B.命令中心C.任務(wù)中心D.開(kāi)發(fā)中心E.健康中心答案:D14.Given the expression: 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_CITIE

6、S exist?A.user tablesB.server memoryC.user table spaceD.system catalog tables答案:B15.定義基本表時(shí)，若要求某一列的值不能為空，則應(yīng)在定義時(shí)使用什么保留字？但如果該列是主鍵，則可省寫(xiě)。A.NULLB.NOT NULLC.DISTINCTD.UNIQUE答案:B16.如果需要?jiǎng)?chuàng)建一個(gè)表，并把表中的索引數(shù)據(jù)和其他數(shù)據(jù)分開(kāi)存儲(chǔ)，則應(yīng)該A.建立兩個(gè)SMS表空間分別存儲(chǔ)索引數(shù)據(jù)和其他數(shù)據(jù)B.建立兩個(gè)DMS表空間分別存儲(chǔ)索引數(shù)據(jù)和其他數(shù)據(jù)C.建立一個(gè)DMS表空間存儲(chǔ)索引數(shù)據(jù)，再建立一個(gè)SMS表空間存儲(chǔ)其他數(shù)據(jù)D.建立一個(gè)SMS

7、表空間存儲(chǔ)索引數(shù)據(jù)，再建立一個(gè)DMS表空間存儲(chǔ)其他數(shù)據(jù)答案:B17.A cursor is declared with the WITH HOLD option. Which of the following statements is always true?A.The cursor will remain open after a COMMIT.B.All rows retrieved are locked until a COMMIT.C.A COMMIT will not be allowed until the cursor is closed.D.Locks obtained by

8、 the cursor will be kept after a COMMIT.答案:A18.據(jù)庫(kù)系統(tǒng)和文件系統(tǒng)的主要區(qū)別是：A.數(shù)據(jù)庫(kù)系統(tǒng)復(fù)雜，而文件系統(tǒng)簡(jiǎn)單。B.文件系統(tǒng)不能解決數(shù)據(jù)冗余和數(shù)據(jù)獨(dú)立性問(wèn)題，而數(shù)據(jù)庫(kù)系統(tǒng)可以解決。C.文件系統(tǒng)只能管理程序文件，而數(shù)據(jù)庫(kù)系統(tǒng)能夠管理各種類型的文件。D.文件系統(tǒng)管理的數(shù)據(jù)量較少，而數(shù)據(jù)庫(kù)系統(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 Cu

9、ba 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,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_

10、var Which of the following values does :count_var require to print out the above report?A.1B.2C.3D.4答案:B20.Given the code: EXEC SQL WITH most_cities AS ( SELECT 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

11、:id, :name, :cities WHERE cities IN (SELECT MAX(cities) FROM most_cities) Which of the following can reference MOST_CITIES?A.The current statementB.Statements from any applicationC.All statements within this applicationD.All statements within the current unit of work答案:A21.缺省的數(shù)據(jù)庫(kù)日志文件的類型是：A.Circular

12、LogB.Archival LogC.Primary LogD.Secondary log答案:A22.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 CURRE

13、NT 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

14、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 db2ce

15、rt.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?A.Only one rowB.As many as are in the resultC.As many as are host variables used in the callD.As 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 /* Statemen