12秋吉大《数据库应用技术》在线作业一

谋学网

一、单选题（共 25 道试题，共 100 分。）V 1.  对于UNIX和Intel平台上的数据库应用，如果需要存取OS/400、VM/VSE和OS/390系统上的数据库，需要DB2哪种产品的支持？
A. DB2 Connect
B. DB2 DataPropagator
3 }3 m( [# ?* i! o2 D6 YC. DB2 Net.Data
7 D. M. @6 |! a; K5 c1 JD. DB2 DataJoiner
7 w' q3 s# {4 aE. DB2 Relational Connect
; E- f6 K! Y, N' a# s      满分：4  分
2.  Which of the following methods must be used for deleting a row using the Statement interface in JDBC?
& F, C" U. D& W0 e) nA. delete()
B. execute()
' Y$ N' J2 [# l9 @5 A, u7 ~: L  GC. executeUpdate()
- }) A! X. i5 fD. executeDelete()
      满分：4  分
% Z% N( _- Y! [4 h3.  Given the following code: EXEC SQL EXECUTE IMMEDIATE :sqlstmt Which of the following values must sqlstmt contain so that all rows are deleted from the STAFF table?
( k1 A8 p6 l9 H+ _) fA. DROP TABLE staff
# u0 h  A% `2 s/ O7 H% F+ CB. DELETE FROM staff
C. DROP * FROM staff
+ y* p# x/ |' P* DD. DELETE * FROM staff
& i( q) E6 \# [2 K, y      满分：4  分
4.  当数据库遭到破坏时，为了能迅速恢复，在进行事务处理过程中将对数据库更新的全部内容写入以下哪项？
6 h9 u5 \# W3 T; g6 r8 oA. 副本文件
# U4 r4 S) q9 N$ A9 b% m) oB. 日志文件
' c: e; u6 N7 Z) }# j2 h; WC. 检查点文件
D. 死锁文件
( [4 _8 g& ]$ _8 k8 D) m      满分：4  分
0 h1 ^# o9 g1 T6 L% s0 Q8 z6 K, {5.  Which of the following is TRUE for all cursors defined as FOR FETCH ONLY?
A. The cursors are unambiguous.
, X$ g; y8 [0 s2 q/ zB. Only the first row is returned.
/ D/ g( Q; `; t% L5 d& FC. Cursor stays open after a commit.
D. A temporary table is created on the server.
      满分：4  分
6.  The following commands are issued against a data source: CREATE TABLE userid.org ( i INT) CREATE ALIAS user1.org FOR userid.org CREATE TABLE org.sample ( c CHAR(1)) CREATE ALIAS sample.org FOR userid.org CREATE ALIAS userid.sample FOR sample.org When issued by USER1, which of the following statements will have a different result set than this SELECT statement? SELECT * FROM org
A. SELECT * FROM org.sample
, r. a' e) |8 P' N1 Z8 O1 O' XB. SELECT * FROM sample.org
C. SELECT * FROM userid.org
% `$ |0 u+ I* s4 sD. SELECT * FROM userid.sample
9 @4 ^9 H6 |. A; d4 m# c      满分：4  分
8 W0 T! ]- |# q0 ?7.  Which of the following cursor definitions will define a cursor called c2 that will fetch rows from table t2, and for every row fetched will update column c1 in table t2?
& d( b. T1 J. w% yA. DECLARE c2 CURSOR FOR SELECT * FROM t2 FOR UPDATE OF t2
B. DECLARE c2 CURSOR FOR SELECT * FROM t2 FOR UPDATE OF c2
C. DECLARE c2 CURSOR FOR SELECT * FROM t2 FOR UPDATE OF c1
D. DECLARE c2 CURSOR WITH HOLD FOR SELECT * FROM t2 FOR UPDATE OF t2
" W" s0 `% e! r, I  n      满分：4  分
8.  下面哪个工具可以保存终端用户需要存取的元数据？
' s$ \4 e6 G: s2 tA. Query Management Facility
B. DB2 Query Patroller
C. DB2存储过程构建器
" c, V* F5 f8 a6 Z* i( {, f+ L- I- JD. 信息目录
) {" J9 ~2 L3 P: \( s      满分：4  分
9.  使用DROP语句撤消基本表时，使用以下哪个子句，可以将下属的视图和约束引用全部撤消？
: ?# Q$ J( R- ^" E* bA. NULL
$ l. ]1 S7 H- o. ZB. RESTRICT
C. CASCADE
D. DISTINCT
, q& z  s4 D$ e      满分：4  分
6 [' t9 J% `( m: g7 {+ F10.  To prepare an embedded SQL program for use with a host-language compiler, which of the following database components is required?
* h7 j' B4 w6 @6 S' jA. Binder
: e& f+ {2 q$ `B. Precompiler
C. Stored Procedure Builder
. `4 K; |' g9 l- ?9 s. d# PD. Application Development Center
      满分：4  分
11.  Given the following statements: EXEC SQL INSERT INTO employee VALUES(:new_emp, :new_name) EXEC SQL UPDATE company SET num_employees=num_employees+1 WHERE company_id=1 EXEC SQL COMMIT Which of the following can be added to the database so that the company table will still be updated without the need for the explicit UPDATE SQL statement?
A. An INSERT trigger on COMPANY
B. An UPDATE trigger on COMPANY
C. An INSERT trigger on EMPLOYEE
& Z, T+ s# m) PD. An UPDATE trigger on EMPLOYEE
      满分：4  分
: d' E2 Z4 q0 I12.  在SELECT语句的下列子句中，通常和HAVING子句同时使用的是以下哪项？
A. ORDER BY子句
B. WHERE子句
2 N* V+ o$ _$ s0 h- X$ P# U! e' K/ }% b$ wC. GROUP BY子句
D. 均不需要
      满分：4  分
13.  要更改数据库管理器配置文件，需以下哪个数据库权限？
A. DBADM
# u: z. K/ G  zB. SYSMAINT
, D# ~" \- m2 W$ nC. SYSCTRL
, E/ _2 Z' \/ ?' H0 E. K" {D. SYSADM
      满分：4  分
0 c$ D- M& h7 J* ~14.  对于那些需要偶尔连接到公司数据上进行数据交换的用户可选择哪种版本的DB2？对于支持小规模的部门级应用，这些应用不需要存取驻留在OS/400、OS/390等平台上的远程数据库，则需要哪种级别的DB2 产品？
+ h! g4 i; r1 o8 I! E' \5 @A. 企业版
B. 工作组版
C. 企业扩展版
D. 个人版
1 x+ n6 s5 u* G% A7 x1 k7 LE. 卫星版
% ]6 h" C0 k( ~) p. H9 {6 i      满分：4  分
# o- V- V' x& Q; X15.  Given the expression: WITH most_cities AS ( SELECT b.id,b.name,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?
2 J: o9 ?5 r2 G. ^3 f+ A) g6 F! NA. user tables
B. server memory
C. user table space
  w  K4 Z1 e& j9 m6 a4 HD. system catalog tables
" K, N) g, ~5 ~. I& @. o      满分：4  分
16.  Given the following table: CREATE TABLE employee (name CHAR(10), salary DEC NOT NULL WITH DEFAULT) 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?
# h, A8 {4 P9 KA. SELECT salary FROM employee WHERE salary IN (SELECT (salary/(SELECT SUM(salary) FROM employee)) FROM employee)
2 f: T$ B$ U5 p5 X! E+ qB. SELECT COALESCE(AVG(salary)) FROM employee
, r% `1 |- I* t. L/ ^7 s" bC. SELECT SUM(salary)/COUNT(*) FROM employee
D. SELECT salary/(SELECT SUM(salary) FROM employee) FROM employee
* z, T) G$ G0 A% Z. q  J, H      满分：4  分
+ n" P  M1 F& [) |" W17.  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 mytab 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?
! K2 ^$ i+ x( k5 D! @" O0 fA. 0
B. 1
C. 2
2 p# _& t- D) K% ^  {! \& ]D. 3
      满分：4  分
18.  设有两个事务T1，T2，其并发操作如下所示： T1： T2： 1） 读A=10，B=5 2） 读A=10 3） 读A=20，B=5 求和25 验证错正确的评价是哪个？
  c' }! ?4 v' g' nA. 该操作不存在问题
B. 该操作丢失修改
C. 该操作不能重复读
% q8 d6 K0 J) xD. 该操作读“脏”数据
  ~0 P* e" g: a1 g9 F5 L0 |: j& y+ q      满分：4  分
5 F3 F, I4 T+ R% {6 k& r  ]19.  要对应用程序预编译并生成绑定文件，需要什么特权？
A. 数据库上的CONNECT特权
B. 数据库上的BINDADD特权
9 ]& M% N% u8 m. v' A. tC. 程序包上的BIND特权
D. 程序包上的CONTROL特权
      满分：4  分
20.  Given the table T1, created using the following statement: CREATE TABLE t1 ( id INTEGER GENERATED BY DEFAULT AS IDENTITY, c1 CHAR(3) ) The following SQL statements are issued: INSERT INTO t1 VALUES (2, 'def') INSERT INTO t1 VALUES (DEFAULT, 'abc') INSERT INTO t1 VALUES (DEFAULT, 'ghi') Which of the following represents the order in which the values are returned from the following SELECT statement? SELECT id FROM t1 ORDER BY id
A. 1, 2, 2
B. 1, 2, 3
' B% o/ X5 Y5 Y  b) _& A! lC. 2, 3, 4
D. 0, 1, 2
      满分：4  分
: J" [" }% e5 j" @) A  U( ]! o21.  Given the code: EXEC SQL DECLARE cursor1 CURSOR FOR SELECT name,age,b_date FROM person; EXEC SQL OPEN cursor1; Under which of the following situations will the above cursor be implicitly closed?
A. When a CLOSE statement is issued
7 k* h. P/ w$ SB. When a COMMIT statement is issued
C. When there are no rows in the result set
D. When all rows are FETCHed from the result set
      满分：4  分
% y; Q5 T; f9 F1 S0 k$ j) m. m* D" @22.  If a stored procedure returns multiple rows, which of the following must the calling application use to access the result set?
A. A cursor
B. A select statement
C. A declared temporary table
D. A table user-defined function
+ t# b, c! D6 a& Y* z      满分：4  分
( s6 V7 B3 r5 F5 r( M, X  [7 E23.  Which of the following is a benefit of user-defined functions?
3 T7 m% f# z  P' rA. Improves application concurrency
B. Improves blocking of result sets
7 a* f2 `. {# y% J7 A0 b0 lC. Simplifies application maintenance
& O) o4 |  @' CD. Reduces memory requirements on the server
      满分：4  分
7 g' |4 H% q' E/ _; [/ `( j24.  Given the table T1 containing an INTEGER column: C1 --- 1 A multithreaded ODBC/CLI application successfully executes the following pseudocode in sequence: Thread 1:SQLConnect(hDbc1,"CERTDB",SQL_NTS,"",NULL,"",NULL); Thread 2:SQLConnect(hDbc2,"CERTDB",SQL_NTS,"",NULL,"",NULL); Thread 1: SQLSetConnectAttr( hDbc1, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_ON); Thread 2: SQLSetConnectAttr( hDbc2, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_ON); Thread1:SQLA11ocHandle(SQL_HANDLE_STMT,hDbc1,&hStmt1); Thread2:SQLA11ocHandle(SQL_HANDLE_STMT,hDbc2,&hStmt2); Thread 1: SQLExecDirect( hStmt1, "SAVEPOINT sp1 ON ROLLBACK RETAIN CURSORS",SQL_NTS); Thread 1:SQLExecDirect(hStmt,"INSERT INTO T1 VALUES(2)",SQL_NTS); Thread 2: SQLExecDirect( hStmt2, "SAVEPOINT sp1 ON ROLLBACK RETAIN CURSORS",SQL_NTS); Thread2:SQLExecDirect(hStmt2,"INSERT INTO T1 VALUES(3)",SQL_NTS); Thread1:SQLExecDirect(hStmt1,"INSERT INTO T1 VALUES(4)",SQL_NTS); Thread2:SQLExecDirect(hStmt2,"ROLLARBACK TO SAVEPOINT spl",SQL_NTS); Thread2:SQLExecDirect(hStmt2,"INSERT INTO T1 VALUES(4)",SQL_NTS); Which result set would be returned by: Thread 2: SQLExecDirect( hStmt2, "SELECT c1 FROM t1 ORDER BY C1", SQL_NTS );
A. 1,5
B. 1,2,5
# c7 b9 ~: \1 l9 Z+ O# pC. 1,2,4,5
$ E( h) n. w! D7 [1 @4 e: L- ZD. 1,2,3,4
      满分：4  分
* T- z0 X7 Y" U25.  Given the code: EXEC SQL WITH most_cities AS ( SELECT b.id, b.name, 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?
/ d( k& _# C# a/ F% DA. The current statement
B. Statements from any application
! j. {) j1 Q7 Y# i# yC. All statements within this application
D. All statements within the current unit of work
      满分：4  分

7 y7 G7 `1 m5 w6 n' M& @# d2 S