分类：
2010-03-24 13:48:14
认证中的一项重要的认证：ICAP(应用开发）DB2 9 。它主要涉及000-733,000-706或730或700，这里重点介绍。它对应的认证名称：IBM Certified Application Developer-DB29
还有就是killtest题库网上看到的一些好的考题，拿来和大家分享一下：
1. A .NET application executes a SQL request invoking the DB2Command.ExecuteReader method and a syntax errorexception is thrown. Which of the following properties contains the SQLCode for this syntax error?
A. DB2Error.SQLCode
B. SQLError.SQLCode
C. DB2Exception.SQLCode
D. SQLException.SQLCode
Answer: A
2. Given the following table definition:CREATE TABLE staff ( id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT, job CHAR(5)) Assuming that the following statements execute successfully:Dim cmdStaff As DB2Command = cnDb2.CreateCommand() cmdStaff.CommandText = "SELECT name FROM staff WHERE (job = @job)" Which of the following is the correct way to provide a
value for the parameter marker used?
A. cmdStaff.Parameters.Add("@job", "Mgr", CType(5, Char))
B. cmdStaff.Parameters.Add("@job", "Mgr", DB2Type.Char, 5)
C. cmdStaff.Parameters.Add(New DB2Parameter("@job", CType(5, Char)) cmdStaff.Parameters("@job").Value = "Mgr"
D. cmdStaff.Parameters.Add(New DB2Parameter("@job", DB2Type.Char, 5)
cmdStaff.Parameters("@job").Value ="Mgr"
Answer: D
3. If the following code is executed in the order shown:conDB2 As DB2ConnectionconDB2.ConnectionString ="Database=samplelx;UID=db2user;PWD=db2pwd;"conDB2.Open() Which of the following statements is
correct?
A. An exception is thrown because the server name has not been specified.
B. An exception is thrown because the server name and the port have not been specified.
C. The execution is successful provided the host name SAMPLEX has been previously defined in the local hosts table.
D. The execution is successful provided the database alias SAMPLEX has been previously defined in the local database catalog.
Answer: D
4. Which of the following is the DB2 Data Provider for the .NET class that requires a database connection to be open?
A. DB2DataSet
B. DB2RecordSet
C. DB2DataReader
D. DB2DataAdapter
Answer: C
5. Which of the following ADO .NET providers is supported by IBM DB2 Add-ins for Visual Studio?
A. OLE DB .NET Data Provider
B. DB2 Data Provider for .NET
C. ODBC Data Provider for .NET
D. DB2 for i5/OS .NET Provider
Answer: B
6. Two OLTP applications run concurrently but frequent locking occurs which requires a fix to be applied. Application A inserts rows into the table T1. Application B submits several queries against the table with a Cursor Stability isolation level. What would be the best course of action to improve the system's concurrency and performance?
A. Application B should be changed to access a view of table T1.
B. Application B should be changed to a Read Stability isolation level.
C. Application A should be changed to perform a commit after each INSERT operation.
D. Application A should be changed to include the NOT WITH HOLD clause on each INSERT operation.
Answer: C
以上的六条题目是我从题库网上拉下来的，如果有需要的话，自己可以到题库网下载！
