.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. 3
• B. 4
• C. 0
• D. 6

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

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

A PHP Web application uses the ibm_db2 extension to establish a persistent connection to a remote database. What must be true of the connections to make full use of the db2_pconnect() API?

• A. Connections must be established under the same user authentication credentials.
• B. The commitment control mode must be set toautocommit mode.
• C. The commitment control mode must be set to manual commit mode.
• D. The persistent connection must be explicitly closed after the database work has completed.

Which two statements are true regarding performing batch updates in JDBC? (Choose two.)

• A. TheexecuteBatch() method can be used to execute a batch of statements.
• B. ResultSet objects can be used to retrieve values generated by CallableStatement objects in a batch.
• C. SELECT statements can be included in batch update operations.
• D. TheaddBatch() method can be used to add a set of input parameter values to the batch.

An application connecting to a DB2 database using the IBM Data Server Provider for .NET is
seeing
performance degradation after 100 active users.
Which Visual Basic .NET command string enables the re-use of the database connections?

• A. DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd;Pooling=100;" Dim conn As DB2Connection = new SqlConnection(connectString)
• B. DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd; Min Pool Size=10" Dim conn As DB2Connection = new SqlConnection(connectString)
• C. DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd;Pooling=100;" Dim conn As DB2Connection = new DB2Connection(connectString)
• D. DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd; Min Pool Size=10" Dim conn As DB2Connection = new DB2Connection(connectString)