|
|
谋学网: www.mouxue.com 主要提供奥鹏作业资料，奥鹏在线作业资料，奥鹏离线作业资料以及奥鹏毕业论文，致力打造中国最专业远程教育辅导社区。
' J, s2 m1 e+ v3 Z, A
& l h# T: ~$ d; l$ ?
{0 l2 B W! p( N: [
* F5 U: W8 p: w. p# s, s- f0 u, F0 J; n8 d4 w
一、单选题（共 25 道试题，共 100 分。）V 1. 对于支持小规模的部门级应用，这些应用不需要存取驻留在OS/400、OS/390等平台上的远程数据库，则需要哪种级别的DB2 产品？6 ^5 ~3 r, w# h
A. 企业版0 }8 D7 f) j9 \- [0 e& h" ?
B. 工作组版0 v* i% V' j5 f. _* E' E3 g8 j7 y' j
C. 企业扩展版 o" }& E# t6 [* A( T% O
D. 个人版
+ p: z; G8 F/ s* e9 ~+ eE. 卫星版7 h! t" u g1 L! r% ~& \+ G. J
F. 微型版
3 a0 y7 e/ |! g7 W0 `1 p 满分：4 分
7 B; o* }7 ~0 i: V9 f) E: I2. 下面哪一工具允许用户开发存储过程？& c" r+ u' J3 e/ P7 }0 R
A. 控制中心
: _7 ~3 n5 A, k3 ?) vB. 命令中心
9 \/ u( H& C' m" fC. 任务中心
& H: B: |% f; ?6 r* L' s. d! oD. 开发中心2 }! B/ M* Q7 a6 B; m
E. 健康中心
: ^% b3 I( O2 w 满分：4 分- c# Y8 B6 S( j
3. SQL语言具有（）功能。
% B( d1 C! t* h$ N# @A. 关系规范化、数据操纵、数据控制
7 G9 R s. x+ h2 K. l4 r& k9 SB. 数据定义、数据操纵、数据控制) Q4 r' l; w# A% _: S* ?7 p
C. 数据定义、关系规范化、数据控制' S8 ^: Y4 ^ ^& m; v w# D( r
D. 数据定义、关系规范化、数据操纵, o4 E2 c6 l( y
满分：4 分: c u% p) E- c) s& R
4. 对于UNIX和Intel平台上的数据库应用，如果需要存取OS/400、VM/VSE和OS/390系统上的数据库，需要DB2哪种产品的支持？
) P( H( c! m+ t! a) P5 U$ r6 u4 ]A. DB2 Connect7 c; e1 }8 D" E. h g: T
B. DB2 DataPropagator9 X8 D6 H$ H' T' l
C. DB2 Net.Data" N, G7 c. K. s+ `- D
D. DB2 DataJoiner7 E+ a, w) e7 B+ {$ j9 t
E. DB2 Relational Connect. `; l& c3 g; n: k( T) l: E
满分：4 分5 ]& w3 I& s: ]- _' f# j9 S- x
5. 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 CURRENT 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 )
' p( z- v3 U5 X+ I7 IA. SQLExecDirect( hStmt, "SELECT * FROM user1.table1 t1, table2 t2 WHERE t1.col1=t2.col2", SQL_NTS )
( w& h9 U8 V8 a% x: ~9 _B. . SQLExecDirect( hStmt, "SELECT * FROM user1.table1 t1, user1.table2 t2 WHERE t1.col1=t2.col2", SQL_NTS )
; F9 A# E% H7 J; [+ A% [C. . SQLExecDirect( hStmt, "SELECT * FROM user1.table1 t1, db2cert.table2 t2 WHERE t1.col1=t2.col2", SQL_NTS )
6 w" C! m3 L6 I1 g; v/ TD. . SQLExecDirect( hStmt, "SELECT * FROM db2cert.table1 t1, db2cert.table2 t2 WHERE t1.col1=t2.col2", SQL_NTS )$ ?& g [6 [8 J5 Y: L* G+ S
满分：4 分5 p0 N; w" H& a
6. Which of the following is used to run an embedded dynamic SQL UPDATE statement?
, X3 |. h( b0 h' {% C! n9 pA. UPDATE4 b" Z2 ^2 v& ~4 M+ z# S* T- v
B. . PREPARE: R& d6 d) c+ Z, D* _% K
C. . DECLARE. `" P+ F/ o- E0 _. T& [( Q
D. . EXECUTE. e* @! [7 b3 ~. |7 T
满分：4 分
5 M+ \2 ~# ~2 d: |7. 给出下面信息: CREATE TABLE tab1 (c1 char(3) WITH DEFAULT NULL, c2 INTEGER); INSERT INTO tab1(c2) VALUES (‘345’); 如果在命令行处理器（CLP）中执行以下语句，以下哪个结果是正确的？ SELECT * FROM tab1;
# e( b/ B. `% b! ]% R1 t9 R( rA. C1 C2 --- ----------- 0 record(s) selected.
, J2 s; q6 L+ l& u9 J# ?: @B. C1 C2 --- ----------- 123 345 1 record(s) selected.
5 R4 n! B, g1 O7 G/ ~C. C1 C2 --- ----------- 345 1 record(s) selected.* |0 b8 H# `/ b' f/ k
D. C1 C2 --- ----------- - 345 1 record(s) selected.
% Q% H: X! I8 }3 c 满分：4 分
6 a; x4 L7 ^% I1 h8 l8. Which of the following privileges is required to successfully execute a Java stored procedure that uses JDBC to update several different tables?, E% Y2 g7 ?: Z4 f1 _7 l+ c
A. The user must have UPDATE privilege on the referenced tables.
8 o9 \$ x9 }. G1 y! D* l4 V' NB. The developer must have EXECUTE privilege on the stored procedure.' E" d2 I# `) }2 y% _4 O
C. The user must have UPDATE privilege on the referenced tables and EXECUTE privilege on the stored procedure.
# F `# l$ K+ r% p# r& N8 OD. The developer must have UPDATE privilege on the referenced tables and EXECUTE privilege on the stored procedure.
, W7 L( [8 S' {; o5 B! Z 满分：4 分2 u# V9 M0 F! r' h( g4 Q
9. 当FROM子句中出现多个基本表或视图时，系统将执行什么操作？
9 L [+ K5 M4 W6 VA. 并
% }' f! q3 {. T0 T; n8 H$ `. \B. 等值联接# @/ V$ h) y# d/ g( s
C. 自然联接3 r- s- V, x5 p7 ?
D. 笛卡儿积
& C; h5 M- {/ w' | 满分：4 分
# k% b5 _" Y, z9 n5 n2 H* m10. Given the following code: BEGIN ATOMIC UPDATE country SET cities=:count WHERE CURRENT OF C1; INSERT INTO country VALUES(:co11,:co12,:co13); INSERT INTO country VALUES(:co14,:co15,:co16); INSERT INTO country VALUES(:co17,:co18,:co19); INSERT INTO country VALUES(:co110,:co111,:co112); COMMIT; END Given that all statements succeed except the following: INSERT INTO country VALUES(:co17,:co18,:co19); How many rows will be affected in table COUNTRY?
: f' `% Q U* A. K, }# `A. 04 B* @& m5 B8 B3 ~3 u3 S3 C
B. 3
9 g9 z# ~% C3 ]3 qC. 4
# C. h, D- `: g; QD. 5
: b% |3 i4 }" P; l3 Z2 O4 U 满分：4 分$ s) x$ d( `6 x" p
11. Which of the following produces a sequentially increasing number, suitable for use as a primary key?
. B7 e/ o, D9 H. ^6 jA. ROWID data type
0 \0 U, B/ {1 {8 v! M+ rB. Generated IDENTITY column
7 c; F& v, j1 o& t' j( i( K$ pC. GENERATE_UNIQUE built-in function- S% T! q1 J% @/ B# u, S6 ~1 R
D. CURRENT SEQUENCE special register4 L+ @' ^% l; S! S5 s0 V5 E
满分：4 分! ~# j6 T" ~* H# a9 Q; l; t9 R
12. 发人员开发访问后台AIX上的DB2的windows程序，需要在windows开发平台上安装：
3 [9 B0 h0 l5 zA. DB2运行时间客户端
9 d( o E% F# ~0 `1 f& xB. DB2管理客户端
# M& @3 u& o7 ]% |C. DB2应用程序开发客户端
- n$ o. ?* g6 tD. DB2瘦客户端9 r& u# c0 h* ] X5 ^
满分：4 分- ?. q3 M! _9 [% m( ]) C
13. 如果需要创建一个表，并把表中的索引数据和其他数据分开存储，则应该
( l# M+ q1 [4 m+ YA. 建立两个SMS表空间分别存储索引数据和其他数据+ w! d6 S8 X) p& |9 K% j; z
B. 建立两个DMS表空间分别存储索引数据和其他数据
$ r8 L( R. T9 ]C. 建立一个DMS表空间存储索引数据，再建立一个SMS表空间存储其他数据
) C" w% ~: `' m9 [- pD. 建立一个SMS表空间存储索引数据，再建立一个DMS表空间存储其他数据# G( c, f# P T
满分：4 分
# H; y j9 Q, s* y+ O% H14. 下述关于数据库系统的正确叙述是（）, X, ?% c9 u" a+ P5 c6 r
A. 数据库中只存在数据项之间的联系
& Q: x0 d+ O2 y1 y0 w* \2 cB. 数据库的数据项之间和记录之间都存在联系
5 c0 M Y2 F1 J0 K" E4 c1 M0 j/ QC. 数据库的数据项之间无联系，记录之间存在联系2 R6 P8 N1 r: P# r5 @3 U
D. 数据库的数据项之间和记录之间都不存在联系
# n, z( Q) q5 i 满分：4 分
! Z" q' S* w4 `; r; u15. E-R图中的联系可以与（）实体有关
8 X' n1 c4 q5 d; N; O( W% k5 zA. 0个
1 D$ ]" ?# }9 h" V% |B. 1个4 g2 \8 v$ z) K$ k2 W
C. 1个或多个
+ I9 ]' ~) x* t' \; p( z* F/ o# hD. 多个
" `6 ^0 H( ^. ]: D" g* e* [ 满分：4 分* x4 h* M0 X7 C# a8 K
16. Given the table T1 with the following data: COL1 IDX ---- ---- A single-threaded CLI application executes the following pseudocode in sequence: SQLAllocHandle( SQL_HANDLE_ENV, NULL, &hEnv ) SQLAllocHandle( SQL_HANDLE_DBC, hEnv, &hDbc ) SQLConnect( hDbc, "SAMPLE", SQL_NTS, NULL, SQL_NTS, NULL, SQL_NTS ) SQLSetConnectAttr( hDbc, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_ON ) SQLAllocHandle( SQL_HANDLE_STMT, hDbc, &hStmt ) SQLExecDirect( hStmt, "UPDATE table1 SET col1=10 WHERE idx=1", SQL_NTS ) SQLExecDirect( hStmt, "UPDATE table1 SET col1=20 WHERE idx=2", SQL_NTS ) SQLEndTran( SQL_HANDLE_DBC, hDbc, SQL_COMMIT ) SQLExecDirect( hStmt, "UPDATE table1 SET col1=30 WHERE idx=1", SQL_NTS ) SQLExecDirect( hStmt, "UPDATE table1 SET col1=40 WHERE idx=1", SQL_NTS ) SQLEndTran( SQL_HANDLE_DBC, hDbc, SQL_ROLLBACK ) SQLExecDirect( hStmt, "SELECT col1 FROM table1 WHERE idx=1", SQL_NTS ) Which of the following values for COL1 will be fetched when the sequence for the pseudocode listed above is successfully executed?
- e$ ^5 b: n$ P8 i" G5 ]A. 104 R$ y$ U; u0 z w; B& C
B. 20
x9 d7 U0 M( Q8 c k3 f9 ?; bC. 30
3 T: g/ y( A" r! G1 [$ E: J3 y+ WD. 409 L3 W3 R. E$ Z
满分：4 分% `9 s- @4 V* P# M! W
17. Given the tables: COUNTRY id name 1 Argentina 3 Cuba 4 - NATION id name 2 Belgium 4 USA and the code: EXEC SQL DECLARE C1 CURSOR FOR SELECT * FROM country WHERE name IS NOT NULL UNION SELECT * FROM nation EXEC SQL OPEN C1 How many rows are in the result set?
& v; W& _$ \) t! KA. 1
1 l+ y2 ^: p/ A' a4 D; o0 PB. 2
5 @% M; Z* e5 `- S: E' \8 w0 L. HC. 37 n* S6 ~. q- O
D. 4
* j6 ^0 D3 A o7 y7 k 满分：4 分
/ X- \6 O: v% A) c6 H; y2 W18. 要对应用程序预编译并生成绑定文件，需要什么特权？) l4 J6 V2 v3 q2 E( b2 D3 Q
A. 数据库上的CONNECT特权
; b- O% A+ X" ?6 J1 v1 `! F+ XB. 数据库上的BINDADD特权
% }7 N/ }2 G( s U L& d$ cC. 程序包上的BIND特权
Z2 ?6 |1 _1 N$ N$ x: o. XD. 程序包上的CONTROL特权& Y8 B* x; ~: n- @& w3 O, \* X
满分：4 分
' o- t3 D9 ]0 B9 y19. 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 default 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?- {8 H% Q- N$ _ @" w7 v% G2 m
A. BAR requires EXECUTE privilege on the package and UPDATE privilege on CUST.ORDERS, and the EXECUTE privilege for the package must be revoked from PUBLIC.
. Y6 n( ~, T$ s9 d/ T( ^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.2 `1 Z+ ^8 C J" U- S2 ?/ j8 t4 P
C. BAR requires EXECUTE privilege on the package and INSERT privilege on CUST.ORDERS, and the REFERENCES privilege for the package must be revoked from PUBLIC.8 l3 T1 H# [ }! |. n+ \
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.% T/ q, j: u. M
满分：4 分
/ Z/ g* r, z) G1 r" Y# l) C/ N20. 缺省的数据库日志文件的类型是：
" _/ T( b3 N0 a* O5 Q" q) a" b9 _A. Circular Log
[! C2 P$ o, A, }6 GB. Archival Log
& l9 P7 z9 H9 {6 D9 Z6 a' YC. Primary Log
; j1 Z( h F% N! s. v6 KD. Secondary log2 u9 I; K4 A6 Z) h. e7 _
满分：4 分* E8 m" \0 ?! w6 n- ^% O- E: t
21. 如果一个用户USER1被授予了表TAB上的CONTROL特权，如果需要限制该用户对表的存取，应使用以下哪条命令？
; P$ x0 R: `+ n& c' z, OA. REVOKE ALL ON TAB TO USER1, N p, T( y" F, S+ U" g! q% Z
B. REVOKE ALL ON TAB FROM USER10 {9 l8 d) V; u8 Q
C. REVOKE CONTROL ON TAB TO USER1
8 R1 a7 Q8 d* N$ }( ?8 c; wD. REVOKE CONTROL ON TAB FROM USER1
* S4 e1 y; N) _1 @ 满分：4 分- B( m6 y0 ]1 H
22. 如果开发人员在AIX操作系统上开发访问后台AS400上的DB2数据库，则需要在AIX开发环境中安装：（）
2 A0 {7 v7 a2 A# S# l- rA. DB2个人开发版（PDE）4 y; t, D. N2 Z1 \( n5 l, }
B. DB2通用开发版（UDE）) X& P8 L0 w1 f0 ]" g0 z
满分：4 分2 w; D: p: ~) q% [7 r# z- \4 C2 _% {
23. An application uses static SQL to connect to a remote DB2 server and inserts data into the CUST.ORDERS table on that remote DB2 server. To enable access to the remote DB2 server, FOO needs to create a package with default options so that BAR is the only non-administrative user that can use this package on the remote DB2 server. Which statement describes the privileges that FOO requires to accomplish this?. l4 F b0 m, d6 s$ @6 B
A. FOO requires EXECUTE privilege on the package.1 j; ^% V3 K3 [" m: i
B. FOO requires the privilege to create the package on the remote DB2 server.7 t; N6 x2 ~3 v' W0 u
C. FOO requires EXECUTE privilege on the package and INSERT privilege on CUST.ORDERS.: X O: p5 O# ~8 b1 o
D. FOO requires the privilege to create the package on the remote DB2 server and INSERT privilege on CUST.ORDERS.1 N+ P& B, K7 F2 Z. H: d
满分：4 分
' n0 U4 r# i% ]5 Q4 y24. 设有两个事务T1，T2，其并发操作如下所示： T1： T2： 1） 读A=10，B=5 2） 读A=10 3） 读A=20，B=5 求和25 验证错正确的评价是哪个？+ o3 ]* R% W% @9 n- Y: Q
A. 该操作不存在问题" C) ~* f5 e9 ~' `2 L" j
B. 该操作丢失000
; c( g- k8 m) L6 \C. 该操作不能重复读
; Q; ^4 z" C5 d9 CD. 该操作读“脏”数据
" F8 J0 n: `* B5 m 满分：4 分
8 ~3 g2 k n5 h9 Q. I( l25. Which of the following will retrieve results that will only be in lower case?+ N- k3 q- ]$ W7 m Z5 V5 i
A. SELECT NAME FROM EMPLOYEE WHERE NAME='ali'
+ U8 }: V. j, S. ~) W( G8 zB. SELECT NAME FROM EMPLOYEE WHERE LCASE(NAME)='ali'
" z8 G5 t6 ]/ `C. SELECT UCASE(NAME) FROM EMPLOYEE WHERE LCASE(NAME)='ali'# @. ?, ], C! m/ \& P9 ]; }
D. SELECT NAME FROM EMPLOYEE WHERE NAME IN (SELECT NAME FROM EMPLOYEE WHERE LCASE(NAME)=LCASE('ALI'))1 x7 P- B! A9 h' g
满分：4 分 / Y/ J: x% i" }, B. [7 _
2 s7 _# G+ i9 P" x. M# [谋学网: www.mouxue.com 主要提供奥鹏作业资料，奥鹏在线作业资料，奥鹏离线作业资料以及奥鹏毕业论文，致力打造中国最专业远程教育辅导社区。
! Z8 I; @# _+ A5 {1 H |
|
IP卡
狗仔卡
发表于 2012-3-31 13:54:56
微信登陆 
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
客服一
