512的几个问题请教一下高手们，多多请教，快考试了 ！

fjhello

1、 If a DB2 Warehouse Manager toolkit is selected during the installation of DB2 UDB Version 7.1, which of the following databases must be defined?  
(Select the correct response)

   
A.      None
B.      Target Database
C.      Source Database
D.      Control Database

2、Given an embedded SQL program with a single connection, two threads and the following actions:
Thread 1: INSERT INTO mytab VALUES (...)
Thread 2: INSERT INTO mytab VALUES (...)
Thread 1: ROLLBACK
Thread 2: INSERT INTO mytab VALUES (...)
Thread 1: COMMIT
How many records will be successfully inserted into the table mytab?  
(Select the correct response)

   
A.      0
B.      1
C.      2
D.      3

3、For a clustering index to be effective in keeping the data in order, which of the following parameters must be set correctly for the index?  
(Select the correct response)

   
A.      FREE ROWS
B.      PERCENT FREE
C.      CLUSTERRATIO
D.      CLUSTER FACTOR

4、Given an application bound with cursor stability which will be updating rows in a table and obtaining row locks, which of the following table locks will DB2 acquire for the application first?  
(Select the correct response)

   
A.      U - update
B.      X - exclusive
C.      IU - intent update
D.      IX - intent exclusive

5、Which two of the following SQL data types should be used to store binary data?  
(Select all that apply)

   
A.      CLOB
B.      BLOB
C.      VARCHAR
D.      GRAPHIC
E.      VARCHAR FOR BIT DATA

xmubeta

我考过的512好像没这么难吧。hehe

下面我的答案未必对，大家探讨一下
1.D
2.B
3.D
4.D
5.A,B,D

sheisqueen

1.D
2.B
3.C
4.D
5.A,B,D