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

1、吉大18春學期數(shù)據(jù)庫應用技術在線作業(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.兩個子查詢的結果（），可以執(zhí)行并、交、差操作結構完全

3、一致結構完全不一致結構部分一致主鍵一致答案:A3.對于支持小規(guī)模的部門級應用，這些應用不需要存取駐留在OS/400、OS/390等平臺上的遠程數(shù)據(jù)庫，則需要哪種級別的DB2 產(chǎn)品？企業(yè)版工作組版企業(yè)擴展版?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ù)庫中存儲的是：（）數(shù)據(jù)數(shù)據(jù)模型數(shù)據(jù)以及數(shù)據(jù)之間的聯(lián)系信息答案:C6.使用DROP語句撤消基本表時，使用以下哪個子句，可以將下屬的視圖和約束引用全部撤消？NULLRESTRICTCASCADEDISTINCT答案:C7.關系模式中各

5、級模式之間的關系為（）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; 所定義的視圖中，當使用INSERT語句時，若新增的行中DEPTNO數(shù)值不為10，則該行將被拒絕插入。正確錯誤答案:A9.若用如下的S

6、QL語句創(chuàng)建一個student表： CREATE TABLE student(NO CHAR（4） NOT NULL， NAME CHAR（8） NOT NULL， SEX CHAR（2）， AGE NUMBERIC（2） 可以插入到student表中的是哪一項？（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ā)控制的主要方法是采用以下哪種機制？口令鎖副本檢查點答案:B12.E-R圖中的聯(lián)系可以與（）實體有關0個1個1個或多個多個答案:C13.下述關于數(shù)據(jù)庫系統(tǒng)的正確敘述是（）數(shù)據(jù)庫中只存在數(shù)據(jù)項之間的聯(lián)系數(shù)據(jù)庫的數(shù)據(jù)項之間和記錄之間都

9、存在聯(lián)系數(shù)據(jù)庫的數(shù)據(jù)項之間無聯(lián)系，記錄之間存在聯(lián)系數(shù)據(jù)庫的數(shù)據(jù)項之間和記錄之間都不存在聯(lián)系答案:B14.定義基本表時，若要求某一列的值不能為空，則應在定義時使用什么保留字？但如果該列是主鍵，則可省寫。NULLNOT NULLDISTINCTUNIQUE答案:B15.SQL語言具有（）功能。關系規(guī)范化、數(shù)據(jù)操縱、數(shù)據(jù)控制數(shù)據(jù)定義、數(shù)據(jù)操縱、數(shù)據(jù)控制數(shù)據(jù)定義、關系規(guī)范化、數(shù)據(jù)控制數(shù)據(jù)定義、關系規(guī)范化、數(shù)據(jù)操縱答案:B16.創(chuàng)建一個DMS類型的表空間，可以使用以下哪兩種文件系統(tǒng)對象作為容器？目錄文件DEVICE答案:B17.發(fā)人員開發(fā)訪問后臺AIX上的DB2的windows程序，需要在windows

10、開發(fā)平臺上安裝：DB2運行時間客戶端DB2管理客戶端DB2應用程序開發(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)計信息？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.下面哪個工具可以保存終端用戶需要存取的元數(shù)據(jù)？Query Management FacilityDB2 Query PatrollerDB2存儲過程構建器信息目錄答案:D23.要更改數(shù)據(jù)庫管理器配置文件，需以下哪個數(shù)據(jù)庫權限？DBADMSYSMAINTSYSCTRLSYSADM答案:D24.下列那種隔離級對于只讀操作不在數(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