最新なIBM A2090-730問題集（303題）、真実試験の問題を全部にカバー！

質問 1：
A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5
User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar
After User1 & User2 are finished, User3 executes the following statement in Connection3:
SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1
Which value will be returned by the query?
A. 55
B. 25
C. 20
D. 50
正解：A

質問 2：
Given the following table definition:
SALES INVOICE_NO CHAR(20) NOT NULL SALES_DATE DATE SALES_PERSON CHAR(20) REGION CHAR(20) SALES INTEGER
If the following SELECT statement is executed, which of the following describes the order of the rows in the result data set produced? SELECT * FROM sales
A. The rows are not sorted in any particular order.
B. The rows are sorted by INVOICE_NO in ascending order.
C. The rows are sorted by INVOICE_NO in descending order.
D. The rows are ordered based on when they were inserted into the table.
正解：A

質問 3：
Which of the following best describes the difference between the DB2 Spatial Extender and the DB2 Geodetic Extender?
A. The DB2 Geodetic Extender can be used to manage information like the locations of office buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and visualizations in disciplines like military command/control and asset management, meteorology and oceanography
B. The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial Extender is used to find area, endpoints, and intersects
C. The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic Extender uses a planar, x- and y-coordinate system
D. The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a round globe
正解：D

質問 4：
Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?
A. The row is only protected from positioned updates and deletes that reference another cursor of the same application.
B. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application
C. The cursor is only protected from updates and deletes by concurrent applications.
D. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
正解：C

質問 5：
Given the following CREATE TABLE statement:
CREATE TABLE customer(custid INTEGER, info XML)
And the following INSERT statements:
INSERT INTO customer VALUES (1000,
'<customerinfo xmlns="http://custrecord.dat" custid="1000">
<name>John Doe</name>
<addr country="United States">
<street>25 East Creek Drive</street>
<city>Raleigh</city>
<state-prov>North Carolina</state-prov>
<zip-pcode>27603</zip-pcode>
</addr>
<phone type="work">919-555-1212</phone>
<email>[email protected]</email>
</customerinfo>');
INSERT INTO customer VALUES (1000,
'<customerinfo xmlns="http://custrecord.dat" custid="1001">
<name>Paul Smith</name>
<addr country="Canada">
<street>412 Stewart Drive</street>
<city>Toronto</city>
<state-prov>Ontario</state-prov>
<zip-pcode>M8X-3T6</zip-pcode>
</addr>
<phone type="work">919-555-4444</phone>
<email>[email protected]</email>
</customerinfo>');
What is the result of the following XQuery expression?
XQUERY declare default element namespace "http://custrecord.dat"; for
$info in db2-fn:xmlcolumn('CUSTOMER.INFO')/customerinfo where
$info/addr/state-prov="Ontario" return $info/name/text();
A. <customerinfo xmlns="http://custrecord.dat" custid="1001"><name xmlns="http://custrecord.dat">Paul Smith</name>
B. <namexmlns="http://custrecord.dat">Paul Smith</name>
C. <customerinfo xmlns="http://custrecord.dat" custid="1001">Paul Smith</customerinfo>
D. Paul Smith
正解：C

質問 6：
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?
A. Developer Workbench
B. Stored Procedure Builder Security
C. Development Center
D. Control Center
正解：A

質問 7：
Which of the following are types of routine objects?
A. Function anduserexit
B. Package and function
C. Function and procedure
D. Procedure and package
正解：C