A2090-543試験無料問題集（100題）「IBM Assessment: DB2 9.7 Application Development 認定」

出題：1

.Click the Exhibit button.
<personinfo>
<name>John Wayne</name>
<address type="private">
<city>New York</city>
<country>US</country>
<phone>850-734-6672</phone>
</address>
<phone type="mobile">796-858-1272 </phone>
<phone type="security">646-252-1053</phone>
</personinfo>
<personinfo>
<name>Barbara Wayne</name>
<address type="private">
<city>New York</city>
<country>US</country>
<phone>850-734-6672</phone>
</address>
<phone type="mobile">796-858-1231 </phone>
<phone type="security">646-252-1153</phone>
</personinfo>
The table PERSON is declared as shown below:
CREATE TABLE person (id BIGINT, info XML)
The documents shown in the exhibit are successfully inserted into the table.
How many phone numbers will be affected by the statement shown below?
UPDATE xmlapp.person
SET info = xmlquery( 'copy $new := $INFO
modify for $j in $new/personinfo//phone return
do replace value of $j with "444-444-4444"
return $new' )
WHERE XMLEXISTS('$INFO/personinfo[name="John Wayne"]')

A. 4

B. 6

C. 0

D. 3

正解：D 解答を投票する

出題：2

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 TABLE (oledb.nwind.customers()) AS t

B. SELECTcompanyname FROM nwind.customers()

C. SELECTcompanyname FROM TABLE (nwind.customers()) AS t

D. SELECTcompanyname FROM oledb.nwind.customers()

正解：C 解答を投票する

出題：3

What are two different types of federated trusted connections? (Choose two.)

A. catalog federated trusted connections

B. proxy federated trusted connections

C. outbound federated trusted connections

D. end-to-end federated trusted connections

正解：C,D 解答を投票する

出題：4

An application must insert values into a column that has a TIMESTAMP data type. What is a valid string representation of a TIMESTAMP?

A. 07/08/2009-12:22:22:0000

B. 2009.08.07.12.22.22.0000

C. 2009-08-07 12:22:22.0000

D. 07-08-2009 12.22.22.0000

正解：C 解答を投票する

出題：5

The scope of a cursor is limited to ____.

A. all remotely called routines

B. applications local to the DB2 server

C. the transaction in which the cursor is declared

D. the source program in which it is defined

正解：D 解答を投票する

出題：6

Given the table COURSES shown below: COURSES
ID CODE NAME
1 ECE100 Operating Systems
2 ECE101 Programming Languages
3 ECE102 Intro to Databases
User USER1 executes the following statements:
DECLARE GLOBAL TEMPORARY TABLE tempcourses
LIKE db2user.courses;
INSERT INTO session.tempcourses SELECT * FROM db2user.courses;
SELECT max(ID) FROM session.tempcourses;
Assuming autocommit is on, which result will user USER1 obtain?

A. no value

B. value 1

C. value 3

D. value 2

正解：A 解答を投票する

出題：7

Given the table COURSES shown below: COURSES
ID CODE NAME 1 ECE100 Operating Systems 2 ECE101 Programming Languages 3 ECE102 Intro to Databases User USER1 executes the following statements: DECLARE GLOBAL TEMPORARY TABLE tempcourses LIKE db2user.courses ON COMMIT PRESERVE ROWS; INSERT INTO session.tempcourses SELECT * FROM db2user.courses; SELECT max(ID) FROM session.tempcourses; Assuming autocommit is on, which result will user USER1 obtain?

A. no value

B. value 1

C. value 3

D. value 2

正解：C 解答を投票する

出題：8

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; call db2_fetch_object($stmt) for each row in the result set.

B. Call db2_fetch_object($stmt) for each result set.

C. Call db2_next_result($stmt) for each result set.

D. Call db2_fetch_object($stmt) for the first result set; call db2_next_result($stmt) for more result sets.

正解：D 解答を投票する

出題：9

Which two C# .NET code snippets illustrate the valid execution of a SQL statement through the IBM Data Server Provider for .NET? (Choose two.)

A. DB2Commandcmd = DB2Context.GetCommand();
DB2Transaction trans = conn.BeginTransaction();
cmd.Transaction= trans;
cmd.CommandText= "INSERT INTO employee (fname,lname) VALUES('Susan','Smith');
cmd.ExecuteNonQuery();

B. SqlCommand cmd = new SQLCommand("INSERT INTO employee (fname,lname)
VALUES('Susan','Smith')",conn);
cmd.ExecuteNonQuery();

C. DB2Commandcmd = conn.CreateCommand();
cmd.CommandText= "SELECT fname, lname FROM employee WHERE empno=55";
DB2DataReader reader = cmd.ExecuteReader();

D. SqlCommand cmd = new SQLCommand("SELECT fname, lname FROM employee WHERE
empno=55",conn);
SqlDataReaderreader = cmd.ExecuteReader();

正解：A,C 解答を投票する

出題：10

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. Implicit use of the XMLCHECK() function in the SQL statements.

C. Implicit use of the XMLVALIDATE() function in SQL statements.

D. Use triggers for INSERT and UPDATE operations with the XMLSERIALIZE() function.

正解：A,C 解答を投票する

A2090-543試験無料問題集「IBM Assessment: DB2 9.7 Application Development 認定」