5,889
社区成员
发帖
与我相关
我的任务
分享DB2-700提问，谢谢各位帮忙的朋友了（在线等）
1.DB2 Performance Monition 在哪里，有没有相关文章？
2.runstar的命令怎么用？
3.Which of the following DB2 components can limit the resource consumption of queries?
A. DB2 Connect
B. DB2 Query Patroller
C. DB2 Performance Monitor
是选C吧，DB2 Query Patroller在那里有介绍
4.设定SQL默认 User应使用 SET CURRENT SQLID=‘USER’？
5.Show SQL allows view DDL,show related view what?
6.Which two of the following modes can be used on the lock table statement?
A. SHARE MODE
B. EXCLUSIVE MODE
C. REPEATABLE READ MODE
D. UNCOMMITTED READ MODE
E. INTENT EXCLUSIVE MODE
这道题E选项对吗，why？
7.Given the following table with a primary key on empid:
Emp:
Empid Name
11 Joe Smith
23 Melanie Jones
30 Robert Bruce
49 Janice Baker
66 Mario Diaz
68 Maria Diaton
Give the following statement in an embedded SQL program bound with Repeatable Read:
Select * from Emp where empid < 55
How many rows in the table will be locked after the statement is run?
A. 0
B. 1
C. 4
D. 5
E. 6
这题选5还是选6为什么，请解释一下
8.SELECT * FROM t1 OPTIMIZE FOR 10 ROWS
SELECT * FROM t1 FETCH FIRST 10 ROWS ONLY
两个语句的区别是什么？
9. Which of the following is possible once a user has been given maintenance authority?
A. DB2 userids can be created
B. Views can be created on the catalogs
C. Statistics can be collected for database objects
D. A table can be populated by using the LOAD command
10.Given the table T1, created by:
CREATE TABLE t1
(
id INTEGER GENERATED BY DEFAULT AS IDENTITY,
c1 CHAR(3)
)
The following SQL statements are issued:
INSERT INTO t1 VALUES (1,’ABC’)
INSERT INTO t1 VALUES (5,’DEF’)
Which of the following values are inserted into the ID column by the following statement?
INSERT INTO t1(c1) VALUES (‘XYZ’)
A. 0
B. 1
C. 2
D. 5
E. 6
请解释一下此题的插入过程
11.Given two embedded SQL programs and the following actions:
Pgm1 Pgm2
INSERT INTO mytab VALUES (…) DELETE FROM mytab
COMMIT ROLLBACK
DELETE FROM mytab INSERT INTO mytab VALUES (…)
ROLLBACK COMMIT
If there exists one (1) row in table mytab before the programs are executed concurrently, how many records
will be in the table once the programs complete?
A. 0
B. 1
C. 2
D. 3
E. 4
谢谢大家了
2.runstar的命令怎么用？
3.Which of the following DB2 components can limit the resource consumption of queries?
A. DB2 Connect
B. DB2 Query Patroller
C. DB2 Performance Monitor
是选C吧，DB2 Query Patroller在那里有介绍
4.设定SQL默认 User应使用 SET CURRENT SQLID=‘USER’？
5.Show SQL allows view DDL,show related view what?
6.Which two of the following modes can be used on the lock table statement?
A. SHARE MODE
B. EXCLUSIVE MODE
C. REPEATABLE READ MODE
D. UNCOMMITTED READ MODE
E. INTENT EXCLUSIVE MODE
这道题E选项对吗，why？
7.Given the following table with a primary key on empid:
Emp:
Empid Name
11 Joe Smith
23 Melanie Jones
30 Robert Bruce
49 Janice Baker
66 Mario Diaz
68 Maria Diaton
Give the following statement in an embedded SQL program bound with Repeatable Read:
Select * from Emp where empid < 55
How many rows in the table will be locked after the statement is run?
A. 0
B. 1
C. 4
D. 5
E. 6
这题选5还是选6为什么，请解释一下
8.SELECT * FROM t1 OPTIMIZE FOR 10 ROWS
SELECT * FROM t1 FETCH FIRST 10 ROWS ONLY
两个语句的区别是什么？
9. Which of the following is possible once a user has been given maintenance authority?
A. DB2 userids can be created
B. Views can be created on the catalogs
C. Statistics can be collected for database objects
D. A table can be populated by using the LOAD command
10.Given the table T1, created by:
CREATE TABLE t1
(
id INTEGER GENERATED BY DEFAULT AS IDENTITY,
c1 CHAR(3)
)
The following SQL statements are issued:
INSERT INTO t1 VALUES (1,’ABC’)
INSERT INTO t1 VALUES (5,’DEF’)
Which of the following values are inserted into the ID column by the following statement?
INSERT INTO t1(c1) VALUES (‘XYZ’)
A. 0
B. 1
C. 2
D. 5
E. 6
请解释一下此题的插入过程
11.Given two embedded SQL programs and the following actions:
Pgm1 Pgm2
INSERT INTO mytab VALUES (…) DELETE FROM mytab
COMMIT ROLLBACK
DELETE FROM mytab INSERT INTO mytab VALUES (…)
ROLLBACK COMMIT
If there exists one (1) row in table mytab before the programs are executed concurrently, how many records
will be in the table once the programs complete?
A. 0
B. 1
C. 2
D. 3
E. 4
谢谢大家了
...全文
请发表友善的回复…
发表回复
gdlin 2003-12-26
- 打赏
- 举报
2. 老兄写错了吧，是RUNSTATS，用于收集统计信息，显示资料的物理构成和给DB2提供信息优化器，以便在执行SQL语句的时候选择最佳访问路径
3，C
4, SET CURRENT SQLID = 'USER1'
5, SHOW RELATIONSHIP
6, A B
7, C
8, 第二句是取前10个记录，第一句是前10个记录组成一个块返回给客户机，是优化器优先选择这10行
9，C
10,B
11,D
3，C
4, SET CURRENT SQLID = 'USER1'
5, SHOW RELATIONSHIP
6, A B
7, C
8, 第二句是取前10个记录，第一句是前10个记录组成一个块返回给客户机，是优化器优先选择这10行
9，C
10,B
11,D
