吉林大學(xué)《數(shù)據(jù)庫應(yīng)用技術(shù)》在線作業(yè)一答卷

1、吉大18春學(xué)期數(shù)據(jù)庫應(yīng)用技術(shù)在線作業(yè)一-0001試卷總分:100 得分:100一、單選題 (共 25 道試題,共 100 分)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 s

2、tatement: 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_var Which of the following values does :count_var require to print out the above report?1234答案:B2.兩個(gè)子查詢的結(jié)果（），可以執(zhí)行并、交、差操作結(jié)構(gòu)完全

3、一致結(jié)構(gòu)完全不一致結(jié)構(gòu)部分一致主鍵一致答案:A3.對(duì)于支持小規(guī)模的部門級(jí)應(yīng)用，這些應(yīng)用不需要存取駐留在OS/400、OS/390等平臺(tái)上的遠(yuǎn)程數(shù)據(jù)庫，則需要哪種級(jí)別的DB2 產(chǎn)品？企業(yè)版工作組版企業(yè)擴(kuò)展版?zhèn)€人版衛(wèi)星版微型版答案:B4.Given an ODBC/CLI program with a single connection, two threads and the following actions which complete successfully: Thread 1: INSERT INTO mytab VALUES (1) Thread 2: INSERT INTO myt

4、ab VALUES (2) Thread 1: COMMIT Thread 2: INSERT INTO mytab VALUES (3) Thread 1: ROLLBACK Thread 2: COMMIT How many records will be inserted and retained in the table MYTAB?0123答案:C5.在數(shù)據(jù)庫中存儲(chǔ)的是：（）數(shù)據(jù)數(shù)據(jù)模型數(shù)據(jù)以及數(shù)據(jù)之間的聯(lián)系信息答案:C6.使用DROP語句撤消基本表時(shí)，使用以下哪個(gè)子句，可以將下屬的視圖和約束引用全部撤消？NULLRESTRICTCASCADEDISTINCT答案:C7.關(guān)系模式中各

5、級(jí)模式之間的關(guān)系為（）3NF包含 2NF包含 1NF3NF包含 1NF包含 2NF1NF 包含2NF包含 3NF2NF包含 1NF 包含3NF答案:A8.在語句CREATE VIEW EMP_VIEW2 (EMPNO, EMPNAME, DEPTNO, JOBTITLE, HIREDATE) AS SELECT ID, NAME, DEPT, JOB, HIREDATE FROM EMPLOYEE WHERE DEPT=10 WITH CHECK OPTION; 所定義的視圖中，當(dāng)使用INSERT語句時(shí)，若新增的行中DEPTNO數(shù)值不為10，則該行將被拒絕插入。正確錯(cuò)誤答案:A9.若用如下的S

6、QL語句創(chuàng)建一個(gè)student表： CREATE TABLE student(NO CHAR（4） NOT NULL， NAME CHAR（8） NOT NULL， SEX CHAR（2）， AGE NUMBERIC（2） 可以插入到student表中的是哪一項(xiàng)？（1031，曾華，男，23）（1031，曾華，NULL，NULL）（NULL，曾華，男，23）（1031，NULL，男，23）答案:B10.Given the following table: CREATE TABLE employee (name CHAR(10), salary DEC NOT NULL WITH DEFAULT)

7、 INSERT INTO employee (name, salary) VALUES (SMITH, 30000) INSERT INTO employee (name) VALUES (JONES) INSERT INTO employee (name, salary) VALUES (ALI, 35000) Which of the following statements will retrieve more than one row?SELECT salary FROM employee WHERE salary IN (SELECT (salary/(SELECT SUM(sala

8、ry) FROM employee) FROM employee)SELECT COALESCE(AVG(salary) FROM employeeSELECT SUM(salary)/COUNT(*) FROM employeeSELECT salary/(SELECT SUM(salary) FROM employee) FROM employee答案:D11.并發(fā)控制的主要方法是采用以下哪種機(jī)制？口令鎖副本檢查點(diǎn)答案:B12.E-R圖中的聯(lián)系可以與（）實(shí)體有關(guān)0個(gè)1個(gè)1個(gè)或多個(gè)多個(gè)答案:C13.下述關(guān)于數(shù)據(jù)庫系統(tǒng)的正確敘述是（）數(shù)據(jù)庫中只存在數(shù)據(jù)項(xiàng)之間的聯(lián)系數(shù)據(jù)庫的數(shù)據(jù)項(xiàng)之間和記錄之間都

9、存在聯(lián)系數(shù)據(jù)庫的數(shù)據(jù)項(xiàng)之間無聯(lián)系，記錄之間存在聯(lián)系數(shù)據(jù)庫的數(shù)據(jù)項(xiàng)之間和記錄之間都不存在聯(lián)系答案:B14.定義基本表時(shí)，若要求某一列的值不能為空，則應(yīng)在定義時(shí)使用什么保留字？但如果該列是主鍵，則可省寫。NULLNOT NULLDISTINCTUNIQUE答案:B15.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ù)操縱答案:B16.創(chuàng)建一個(gè)DMS類型的表空間，可以使用以下哪兩種文件系統(tǒng)對(duì)象作為容器？目錄文件DEVICE答案:B17.發(fā)人員開發(fā)訪問后臺(tái)AIX上的DB2的windows程序，需要在windows

10、開發(fā)平臺(tái)上安裝：DB2運(yùn)行時(shí)間客戶端DB2管理客戶端DB2應(yīng)用程序開發(fā)客戶端DB2瘦客戶端答案:C18.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_CITIES exist?user tablesserver memoryuser ta

11、ble spacesystem catalog tables答案:B19.下列哪種工具可以向表中增添記錄，并更改數(shù)據(jù)庫的統(tǒng)計(jì)信息？importinsertloadupdate答案:C20.Under which of the following situations must dynamic SQL be used?When temporary table references exist at compile timeWhen the host variables values are unknown at compile timeWhen the columns in the SELECT

12、 clause are unknown at compile timeWhen the number of rows being returned are unknown at compile time答案:C21.How many rows can be retrieved using a single SELECT INTO statement?Only one rowAs many as are in the resultAs many as are host variables used in the callAs many as host variable array structu

13、res can hold答案:A22.下面哪個(gè)工具可以保存終端用戶需要存取的元數(shù)據(jù)？Query Management FacilityDB2 Query PatrollerDB2存儲(chǔ)過程構(gòu)建器信息目錄答案:D23.要更改數(shù)據(jù)庫管理器配置文件，需以下哪個(gè)數(shù)據(jù)庫權(quán)限？DBADMSYSMAINTSYSCTRLSYSADM答案:D24.下列那種隔離級(jí)對(duì)于只讀操作不在數(shù)據(jù)行上加鎖？RRRSCSUR答案:D25.Given the EMPLOYEE table definition: CREATE TABLE employee ( workdept CHAR(30), salary INTEGER ) Which of the following is a correct usage of parameter markers in a JDBC program?String sql = UPDATE employee SET salary=salary*?WHERE workdept=?; statement stmt=con.createStatement(sql);String sql = UPDATE employee SET salary=salary*?WHERE workdept=?; statement stmt=con.createStatement(s