000-543 考試範圍廣、題型靈活，不少考生第一次應考都低估了它的難度。KaoGuTi 的 IBM DB2 9.7 Application Development 題庫依據最新考試內容整理 100 道模擬試題，幫你提前熟悉出題方式。

IBM 000-543 考試概覽:

認證廠商:	IBM
考試名稱:	DB2 9.7 應用程式開發
考試代碼:	000-543
考試形式:	選擇題
支援語言:	英文
相關認證:	IBM DB2 資料庫管理員 IBM 認證應用程式開發人員 - DB2
範例考題:
考試方式:	線上監考或實體考場應考（依 IBM 考試合作夥伴與地區而異）

IBM 000-543 考試大綱主題:

000-543 認證考試問與答

最新的 IBM certifications I 000-543 免費考試真題：

問題 #1

An application uses the statement shown below to give employees in department "E11" a bonus equal to 10 of their salary: UPDATE emp SET bonus = (SELECT .10 * salary FROM emp y WHERE empno = y.empno) WHERE CURRENT OF c1; Which statement should be used to define cursor C1?

A. DECLARE c1 CURSOR FOR SELECT bonus FROMemp WHERE workdept = 11?FOR UPDATE OF bonus
B. DECLARE c1 CURSOR FOR SELECT * FROMemp WHERE workdept = ?11? FOR UPDATE OF *
C. DECLARE c1 CURSOR FOR SELECT bonus FROMemp WHERE workdept = 11??
D. DECLARE c1 CURSOR FOR SELECT * FROMemp WHERE workdept = ?11? FOR UPDATE

問題 #2

Which CLI/ODBC function would be used to update multiple rows in a table?

A. SQLExecBatch()
B. SQLExecute()
C. SQLBulkUpdate()
D. SQLUpdate()

問題 #3

Which statement should be used to obtain the result set shown below?
<Root>
<First>Hello</First>
<Second>World !</Second>
<?Test Pass test?>
</Root>

A. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLELEMENT(NAME "First", 'Hello'),
XMLELEMENT(NAME "Second", 'World !'),
XMLATTRIBUTES ( 'Pass test' as "test")
)
)
B. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLELEMENT(NAME "First", 'Hello'),
XMLELEMENT(NAME "Second", 'World !'),
XMLTEXT ('Test Pass test')
)
)
C. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLFOREST(
'Hello' as "First",
'World !' as "Second"
),
XMLCOMMENT ('Test Pass test')
)
)
D. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLFOREST(
'Hello' as "First",
'World !' as "Second"
),
XMLPI (NAME "Test", 'Pass test')
)
)

問題 #4

A CLI/ODBC application uses the SQL FetchScroll() API to retrieve an updatable row set with five rows of data. Each column of the row set is bound to an array of application memory. The API is called with the SQL_FETCH_NEXT FetchOrientationoption and returns SQL_SUCCESS_WITH_INFO. Diagnostics show a truncation SQLSTATE of "01004".
Which API call correctly identifies the record with the failure?

A. SQLGetDiagField( hStmt, SQL_DIAG_ROW_COUNT, &(intVal) );
B. SQLGetDescField( hStmt, SQL_DESC_COUNT, &(intVal) );
C. SQLGetDiagField( hStmt, SQL_DIAG_ROW_NUMBER, &(intVal) );
D. SQLGetDescField( hStmt, SQL_DESC_ARRAY_SIZE, &(intVal) );

問題 #5

You have created a stored procedure (MULTIRESULTS()) on the server which will return multiple
result sets. Whiledeveloping a PHP application using the IBM_DB2 extension, you want to call the
stored procedure. The code shown below will execute the stored procedure:
$stmt = db2_exec($conn, 'CALL multiResults()');
How can you fetch all of the result sets from $stmt?

A. Call db2_next_result($stmt) for each result set.
B. Call db2_next_result($stmt) for each result set; call db2_fetch_object($stmt) for each row in the result set.
C. Call db2_fetch_object($stmt) for the first result set; call db2_next_result($stmt) for more result sets.
D. Call db2_fetch_object($stmt) for each result set.

問題與答案：