db2认证测试题.txt

db2 指定某个字符串中的第几个字符的更新

C. The statement will succeed only if ADDRESS1.ID and ADDRESS2.ID are define 
d 
as primary keys. 
D. The statement will succeed if the data retrieved from the subquery does n 
o 
t have duplicate values for ADDRESS1.ID. 

25. Which of the following processing can occur for a unit of work using an i 
solation level of Cursor Stability and allows scanning through the table more 
than once within the unit of work? 
(Select the correct response) 
A. Access uncommitted changes made by other processes 
B. Update uncommitted changes made by other processes 
C. Have updated result set rows changed by other processes from one scan to t 
he next 
D. Have accessed result set rows changed by other processes from one scan to 
the next 

26. How many DB2 Administration Server (DAS) Instances can be set up per phys 
ical machine? 
(Select the correct response) 
A.0 
B.1 
C. One for each instance on the physical machine 
D. One for each database on the physical machine 

27. A table called EMPLOYEE has columns: name, department, and phone_number. 
Which of the following can limit access to the phone_number column? 
(Select the correct response) 
A. Using a view to access the table 
B. Using an index on the column 
C. Using a referential constraint on the table 
D. Using a table check constraint on the table 
E. Revoking access from the phone_number column 

28. Given the following transaction: 
CREATE TABLE dwaine.mytab (col1 INT, col2 INT) 
INSERT INTO dwaine.mytab VALUES (1,2) 
INSERT INTO dwaine.mytab VALUES (4,3) 
ROLLBACK 
Which of the following would be returned from the statement: 
SELECT * FROM dwaine.mytab? 
(Select the correct response) 
A. COL1 COL2 
----------- ----------- 
0 record(s) selected. 
B. COL1 COL2 
----------- ----------- 
1 2 
1 record(s) selected. 

C. SQLCODE -204 indicating that "DWAINE.MYTAB" is an undefined name. 
D. COL1 COL2 
----------- ----------- 
1 2 
4 3 

29. Given the table definition: 
CREATE TABLE student (name CHAR(30), age INTEGER) 
To list the names of the 10 youngest students, which of the following index d 
efinition statements on the student table may improve the query performance? 

(Select the correct response) 
A. CREATE INDEX youngest ON student (age, name) 
B. CREATE INDEX youngest ON student (name, age) 
C. CREATE INDEX youngest ON student (name, age DESC) 
D. CREATE INDEX youngest ON student (name DESC) INCLUDE (age) 

30. Which of the following privileges is necessary to populate the table with 
large amounts of data? 
(Select the correct response) 
A. LOAD 
B. ALTER 
C. UPDATE 
D. IMPORT 

31. Which of the following DB2 CLP options specify the file that contains the 
statements to be executed? 
(Select the correct response) 
A. –f 
B.-b 
C.-o 
D.-w 

32. 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 

33. Given table T1 with 100 rows, which of the following queries will retriev 
e 10 rows from table T1? 
(Select the correct response) 
A. SELECT * FROM t1 MAXIMUM 10 ROWS 
B. SELECT * FROM t1 READ 10 ROWS ONLY 
C. SELECT * FROM t1 OPTIMIZE FOR 10 ROWS 
D. SELECT * FROM t1 FETCH FIRST 10 ROWS ONLY 

34. Which of the following DELETE RULES on CREATE TABLE will delete a depende 
nt table row if the parent table row is deleted? 
(Select the correct response 
A. ON DELETE REMOVE 
B. ON DELETE CASCADE 
C. ON DELETE RESTRICT 
D. ON DELETE SET NULL 
E. ON DELETE PROPAGATE 

35. Which of the following isolation levels will lock only the rows returned 
in the result set? 
A. Read Stability 
B. Repeatable Read 
C. Cursor Stability 
D. Uncommitted Read 

36. Using the Control Center Create Table dialog box, which of the following 
dialogs allows the table creation DDL to be viewed? 
(Select the correct response 
A. Copy 
B. Show SQL 
C. Show Related 
D. Sample Contents 

37. Which of the following does NOT end a unit of work? 
(Select the correct response) 
A. COMMIT 
B. ROLLBACK 
C. TERMINATE 
D. SAVEPOINT 
E. CONNECT RESET 

38. Given the following embedded SQL programs: 
Program 1: 
CREATE TABLE mytab (col1 INT, col2 CHAR(24)) 
COMMIT 
Program 2: 
INSERT INTO mytab VALUES ( 20989,'Joe Smith') 
INSERT INTO mytab VALUES ( 21334,'Amy Johnson') 
COMMIT 
DELETE FROM mytab 
ROLLBACK 
INSERT INTO mytab VALUES ( 23430,'Jason French') 
ROLLBACK 
INSERT INTO mytab VALUES ( 20993,'Samantha Jones') 
COMMIT 
DELETE FROM mytab WHERE col1=20993 
ROLLBACK 
Which of the following indicates the number of records that will be returned 
by the statement: 
SELECT * FROM mytab? 
(Select the correct response) 
A.0 
B.1 
C.2 
D.3 
E.4 

39. Given an embedded SQL program with a single connection, two threads and t 
he following actions: 
Thread 1: INSERT INTO mytab VALUES (...) 
Thread 2: INSERT INTO mytab VALUES (...) 
Thread 1: COMMIT 
Thread 2: INSERT INTO mytab VALUES (...) 
Thread 1: ROLLBACK 
How many records will be successfully inserted and retained in the table myta 
b? 
(Select the correct response) 
A.0 
B.1 
C.2 
D.3 

40. Which two of the following types of storage management method is supporte 
d by DB2 OLAP Server ? 
(Select all that apply) 
A. Object 
B. Network 
C. Relational 
D. Hierachical 
E. Multi-dimensional 

41. Given table EMPLOYEE with columns EMPNO and SALARY and table JOB with col 
umns ID and TITLE, what is the effect of the statement: 
UPDATE employee SET salary = salary * 1.15 
WHERE salary < 15000 OR 
EXISTS (SELECT 1 FROM job WHERE job.id = employee.empno AND job.title = 'Mgr' 
) 
(Select the correct response) 
A. Only managers that make less than 15,000 are given salary increases. 
B. Only non-managers that make less than 15,000 are given salaray increases. 

C. Employees that make less than 15,000 but no managers are given salary inc 
r 
eases. 
D. Employees that make less than 15,000 and all managers are given salary in 
c 
reases. 

42. When manually establishing communications from a Windows NT client throug 
h a DB2 Connect gateway to DB2 UDB for OS/390, which of the following is NOT 
required to catalog? 
(Select the correct response 
A. The client. 
B. The database on the DRDA server. 


_________________
练从难处练，用从易处用。 
Make it better and better. 
 
返回页首  
 
 
yaosj      




级别: 侠客
注册时间: 2003-03-28
最后登录: 2003-12-23
帖子总数: 35
精华帖子: 0
原创精华: 0

在线状态: ...离线...
 发表于: 2003-12-21 17:12    发表主题:    

--------------------------------------------------------------------------------
 
谢了！

 
 
返回页首  
 
 
iihero      




级别: 侠客
注册时间: 2003-12-13
最后登录: 2003-12-21
帖子总数: 22
精华帖子: 0
原创精华: 0
来自: 北京
在线状态: ...离线...
 发表于: 2003-12-21 19:12    发表主题:    

--------------------------------------------------------------------------------
 
祝成功!!


_________________
练从难处练，用从易处用。 
Make it better and better. 
 
返回页首  
 
 
richardluopeng      




级别: 精灵王
注册时间: 2003-03-21
最后登录: 2003-12-24
帖子总数: 285
精华帖子: 0
原创精华: 0

在线状态: ...离线...
 发表于: 2003-12-22 08:12    发表主题:    

--------------------------------------------------------------------------------
 
700的？？？


_________________
红酥手，黄縢酒，满城春色宫墙柳。东风恶，欢情薄。一怀愁绪，几年离索。 
错！错！错！ 

春如旧，人空瘦，泪痕红浥鲛绡透。桃花落。闲池阁。山盟虽在，锦书难托。 
莫！莫！莫！ 
 
返回页首  
 
 
iihero      




级别: 侠客
注册时间: 2003-12-13
最后登录: 2003-12-21
帖子总数: 22
精华帖子: 0
原创精华: 0
来自: 北京
在线状态: ...离线...
 发表于: 2003-12-22 21:12    发表主题:    

--------------------------------------------------------------------------------
 
说老实话，701我也没有，我没见过有答案的701测试题。


_________________
练从难处练，用从易处用。 
Make it better and better. 
 
返回页首  
 
 
       ChinaUnix.net首页 -> 论坛首页 -> DB2 论坛时间为 北京时间
 
第1页/共1页 
 
 转跳到: 选择一个版面 → 站务交流区 ←----------------站务交流版主会议室 → Unix业界新动态交流区 ←----------------业界新闻与评论 → UNIX类操作系统技术交流区 ←----------------LinuxBSDSolarisSCO UNIXHP-UXAIXIBM AS400应用论坛Tru64 UNIXIRIXUNIX高级技术Mac OS X → UNIX平台应用技术专题交流区 ←----------------Web服务器Mail服务器FTP服务器DNS服务器Proxy服务器其它应用 → UNIX平台数据库技术交流区 ←----------------MySQLPostgreSQLOracleInformixSybaseDB2数据库开发 → UNIX平台程序设计交流区 ←----------------ShellC/C++PerlJavaPhp软件工程技术 → 网络与设备管理技术交流区 ←----------------系统和网络安全网络技术及应用存储备份之家硬件技术 → 综合交流区 ←----------------清茶斋IT职业生涯English Forum运动地带快乐数码摄影  

您不能发布新主题
您不能在这个论坛回复主题
您不能在这个论坛编辑自己的帖子
您不能在这个论坛删除自己的帖子
您不能在这个论坛发表投票
您 无法 在这个版面上传图片或文件
您 可以 在这个版面下载文件
 

--------------------------------------------------------------------------------

 


Copyright ? 2001-2003 ChinaUnix.net    Powered by phpBB 
[ [e-mail] ] 
感谢所有关心和支持过ChinaUnix的朋友们