最も有効な C2090-543 試験参考書

C2090-543試験の出題内容は2026年も更新され続けています。ShikenPASSのIBM DB2 9.7 Application Development問題集は購入後365日間無料でアップデートされるため、常に最新の100問で学習できます。

IBM C2090-543 試験概要:

IBM C2090-543 試験シラバストピック:

IBM DB2 9.7 Application Development（C2090-543）受験者からのよくあるご質問

IBM DB2 9.7 Application Development 認定 C2090-543 試験問題：

問題 #1

Which object can be created to group together related procedures and user-defined functions that are used for tax calculations?.

A. module
B. collection
C. routine space
D. routine

問題 #2

Which three are required for a global transaction? (Choose three.)

A. Transaction Manager
B. Workload Manager
C. Client Application
D. Resource Manager
E. Application Coordinator

問題 #3

Click the Exhibit button.
CREATE TABLE store(sid INTEGER, info XML);
INSERT INTO store VALUES (1,
'<storeinfo sid="1">
<name>Grocery A</name>
<items>
<fruit><name>Mango</name><price>1.20</price></fruit>
<fruit><name>Apple</name><price>0.50</price></fruit>
<dessert><name>Ice Cream</name><price>6.00</price></dessert>
</items>
</storeinfo>');
Given the statements shown in the exhibit, a user executes the query shown below:
XQUERY for $store in db2-fn:xmlcolumn('STORE.INFO')/storeinfolet $items := $store/items/fruit,
$count := fn:count($items) return <itemcount>$count</itemcount> What is the output?

A. 1
B. $count
C. 2
D. 2

問題 #4

Which two techniques guarantee that XML document validation will be performed? (Choose two.)

A. Use triggers for INSERT and UPDATE operations with the XMLVALIDATE() function.
B. Use triggers for INSERT and UPDATE operations with the XMLSERIALIZE() function.
C. Implicit use of the XMLVALIDATE() function in SQL statements.
D. Implicit use of the XMLCHECK() function in the SQL statements.

問題 #5

Click the Exhibit button.
UPDATE DBM CFG USING FEDERATED YES;
db2stop;
db2start;
CONNECT TO test;
CREATE WRAPPER oledb LIBRARY 'db2oledb';
CREATE SERVER nwind
WRAPPER oledb
OPTIONS (CONNECTSTRING 'Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=f:Northwind.mdb;', COLLATING_SEQUENCE 'Y');
CREATE FUNCTION nwind.customers()
RETURNS TABLE (customerid CHAR(5),
companynameVARCHAR(40),
contactnameVARCHAR(30),
contacttitleVARCHAR(30),
address VARCHAR(60),
city VARCHAR(15),
region VARCHAR(15),
postalcodeVARCHAR(15),
country VARCHAR(24),
phone VARCHAR(24),
fax VARCHAR(24))
LANGUAGE OLEDB
EXTERNAL NAME 'nwind!customers';
COMMIT;
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in
the exhibit was executed successfully.
Which statement can be used to verify that an OLE DB table function designed to retrieve data
from the CUSTOMERS table of the NORTHWIND Microsoft Access database was created
successfully?

A. SELECTcompanyname FROM nwind.customers()
B. SELECTcompanyname FROM TABLE (nwind.customers()) AS t
C. SELECTcompanyname FROM TABLE (oledb.nwind.customers()) AS t
D. SELECTcompanyname FROM oledb.nwind.customers()

解説：