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

1、吉大18春學(xué)期數(shù)據(jù)庫(kù)應(yīng)用技術(shù)在線(xiàn)作業(yè)二-0003試卷總分:100 得分:0一、 單選題 (共 25 道試題,共 100 分)1.Which of the following is a benefit of user-defined functions?A.Improves application concurrencyB.Improves blocking of result setsC.Simplifies application maintenanceD.Reduces memory requirements on the server正確答案:C2.當(dāng)FROM子句中出現(xiàn)多個(gè)基本表或視圖時(shí)

2、，系統(tǒng)將執(zhí)行什么操作？A.并B.等值聯(lián)接C.自然聯(lián)接D.笛卡兒積正確答案:D3.在SELECT語(yǔ)句的下列子句中，通常和HAVING子句同時(shí)使用的是以下哪項(xiàng)？A.ORDER BY子句B.WHERE子句C.GROUP BY子句D.均不需要正確答案:C4.數(shù)據(jù)庫(kù)系統(tǒng)的并發(fā)控制的主要方法是采用（）制。A.拒絕B.改為串行C.鎖D.不加任何控制正確答案:C5.要對(duì)應(yīng)用程序預(yù)編譯并生成綁定文件，需要什么特權(quán)？A.數(shù)據(jù)庫(kù)上的CONNECT特權(quán)B.數(shù)據(jù)庫(kù)上的BINDADD特權(quán)C.程序包上的BIND特權(quán)D.程序包上的CONTROL特權(quán)正確答案:A6.下面哪個(gè)工具可以幫助用戶(hù)對(duì)語(yǔ)句性能進(jìn)行分析？A.可視化解釋工具

3、B.性能監(jiān)視器C.命令行處理器D.控制中心正確答案:A7.The following commands are issued against a data source containing table : CREATE ALIAS FOR CREATE TABLE org.sample ( c CHAR(1) CREATE ALIAS FOR CREATE ALIAS user2.sample FOR Given the user SAMPLE issues the f

4、ollowing statement: SELECT * FROM sample For which of the following database objects will access be attempted?A.B.org.sampleC.D.sample.sample正確答案:D8.在客戶(hù)端直接連接到DB2 UDB服務(wù)器的環(huán)境中，服務(wù)器端的認(rèn)證類(lèi)型為以下哪個(gè)時(shí)，在編目時(shí)指定的認(rèn)證類(lèi)型不一定要與服務(wù)器端認(rèn)證參數(shù)的值相匹配。A.SERVER_ENCRYPTB.DCEC.DCE_SERVER_ENCRYPTD.KERBEROS正確答案:C9.創(chuàng)建一

5、個(gè)DMS類(lèi)型的表空間，可以使用以下哪兩種文件系統(tǒng)對(duì)象作為容器？A.目錄B.文件C.DEVICE正確答案:B10.To prepare an embedded SQL program for use with a host-language compiler, which of the following database components is required?A.BinderB.PrecompilerC.Stored Procedure BuilderD.Application Development Center正確答案:B11.Given the code: EXEC SQL WI

6、TH 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 :id, :name, :cities WHERE cities IN (SELECT MAX(cities) FROM most_cities) Which of the following can reference MOST_CITIES?A.The

7、current statementB.Statements from any applicationC.All statements within this applicationD.All statements within the current unit of work正確答案:A12.下列SQL語(yǔ)句中，能夠?qū)崿F(xiàn)“收回用戶(hù)U4對(duì)學(xué)生表（STUD）中學(xué)號(hào)（XH）的修改權(quán)”這一功能的是（）A.REVOKE UPDATE(XH) ON TABLE FROM U4B.REVOKE UPDATE(XH) ON TABLE FROM PUBLICC.REVOKE UPDATE(XH) ON STUD

8、 FROM U4D.REVOKE UPDATE(XH) ON STUD FROM PUBLIC正確答案:C13.An application uses embedded dynamic SQL to connect to a remote DB2 server and inserts data into the CUST.ORDERS table on that remote DB2 server. To enable access of the remote DB2 server, Administrator FOO needs to create a package with defaul

9、t options such that BAR is the only non-administrative user that can use this package on the remote DB2 server. Which statement describes the privileges that must be granted and/or revoked by FOO to accomplish this?A.BAR requires EXECUTE privilege on the package and UPDATE privilege on CUST.ORDERS,

10、and the EXECUTE privilege for the package must be revoked from PUBLIC.B.BAR requires EXECUTE privilege on the package and INSERT privilege on CUST.ORDERS, and the EXECUTE privilege for the package must be revoked from PUBLIC.C.BAR requires EXECUTE privilege on the package and INSERT privilege on CUS

11、T.ORDERS, and the REFERENCES privilege for the package must be revoked from PUBLIC.D.BAR requires EXECUTE privilege on the package and UPDATE privilege on CUST.ORDERS, and the REFERENCES privilege for the package must be revoked from PUBLIC.正確答案:B14.對(duì)于那些需要偶爾連接到公司數(shù)據(jù)上進(jìn)行數(shù)據(jù)交換的用戶(hù)可選擇哪種版本的DB2？對(duì)于支持小規(guī)模的部門(mén)級(jí)應(yīng)用

12、，這些應(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)星版正確答案:E15.缺省的數(shù)據(jù)庫(kù)日志文件的類(lèi)型是：A.Circular LogB.Archival LogC.Primary LogD.Secondary log正確答案:A16.定義基本表時(shí)，若要求某一列的值不能為空，則應(yīng)在定義時(shí)使用什么保留字？但如果該列是主鍵，則可省寫(xiě)。A.NULLB.NOT NULLC.DISTINCTD.UNIQUE正確答案:B17.游標(biāo)穩(wěn)定性（CS，或稱(chēng)光標(biāo)穩(wěn)定性）隔離級(jí)鎖定工作單元期間光標(biāo)所在的任何行。對(duì)該行

13、的鎖定將（）A. 不保持B. 保持到取出下一行記錄或整個(gè)工作單元終止。C. 保持到整個(gè)工作單元終止。正確答案:B18.要更改數(shù)據(jù)庫(kù)管理器配置文件，需以下哪個(gè)數(shù)據(jù)庫(kù)權(quán)限？A.DBADMB.SYSMAINTC.SYSCTRLD.SYSADM正確答案:D19.如果想在數(shù)據(jù)導(dǎo)入的過(guò)程中創(chuàng)建表，應(yīng)該A.使用IXF文件格式進(jìn)行LOADB.使用WSF文件格式進(jìn)行LOADC.使用IXF文件格式進(jìn)行IMPORTD.使用WSF文件格式進(jìn)行IMPORT正確答案:C20.兩個(gè)子查詢(xún)的結(jié)果（），可以執(zhí)行并、交、差操作A.結(jié)構(gòu)完全一致B.結(jié)構(gòu)完全不一致C.結(jié)構(gòu)部分一致D.主鍵一致正確答案:A21.如果選用循環(huán)日志方式，輔助日志文件何時(shí)分配？A.數(shù)據(jù)庫(kù)建立的時(shí)候B.數(shù)據(jù)庫(kù)服務(wù)器啟動(dòng)的時(shí)候C.需要的時(shí)候D.以上都不對(duì)正確答案:C22.使用SQL語(yǔ)句進(jìn)行查詢(xún)操作時(shí)，若希望查詢(xún)結(jié)果不出現(xiàn)重復(fù)元組，應(yīng)在SELECT子句中使用什么保留字