최신 IBM certifications I A2090-543 무료샘플문제:

1. Click the Exhibit button.
CREATE TABLE gradereport(sid INTEGER, info XML);
INSERT INTO gradereport VALUES (1,
'<studentinfo sid="1">
<name>John Smith</name>
<honours>No</honours>
<grades>
<course><name>ECE100</name><grade>80</grade></course>
<course><name>CSC100</name><grade>70</grade></course>
<course><name>MAT100</name><grade>75</grade></course>
</grades>
<phone type="mobile">416-333-8725</phone>
</studentinfo>');
Given the statements shown in the exhibit, a user wishes to obtain the following result:
<student><name>John Smith</name><phone>416-333-8725</phone></student>
Which query can the user execute to achieve this?

A) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo where $studinfo/@sid="1" return {$studinfo/name}{$studinfo/phone/text()}
B) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo where $studinfo/@sid="1" return {$studinfo/name}{$studinfo/phone/text()}
C) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo return {$studinfo/name}{$studinfo/phone}
D) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo where $studinfo/@sid="1" return {$studinfo/name}{$studinfo/phone}

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

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

3. Given the table shown below:
COURSES
ID CODE NAME
1 ECE100 Operating Systems
2 ECE101 Programming Languages
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;
INSERT INTO session.tempcourses VALUES (3, 'ECE102', 'Databases');
SELECT max(ID) FROM db2user.courses;
User USER2 executes the following statements:
DECLARE GLOBAL TEMPORARY TABLE tempcourses
LIKE db2user.courses;
ON COMMIT PRESERVE ROWS;
INSERT INTO session.tempcourses SELECT * FROM db2user.courses;
INSERT INTO session.tempcourses VALUES (4, 'ECE103', 'Algorithms');
SELECT max(ID) FROM session.tempcourses;
Which results do USER1 and USER2 obtain?

A) User USER1 obtains the value 3; User USER2 obtains the value 4
B) User USER1 obtains the value 2; User USER2 obtains the value 4
C) User USER1 obtains the value 2; User USER2 obtains the value 3
D) User USER1 obtains the value 2; User USER2 obtains the value 2
E) User USER1 obtains no value; User USER2 obtains no value

4. Given the two tables shown below: TAB1 LETTER GRADE A 80 B 70 C 60 TAB2 LETTER GPA A 4 C 2 D 1 and the successful execution of the following query: SELECT * FROM tab1 FULL OUTER JOIN tab2 ON tab1.letter = tab2.letter; How many rows will be returned?

A) 4
B) 3
C) 6
D) 2

5. 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; Min Pool Size=10" Dim conn As DB2Connection = new SqlConnection(connectString)
B) DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd;Pooling=100;" Dim conn As DB2Connection = new SqlConnection(connectString)
C) DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd; Min Pool Size=10" Dim conn As DB2Connection = new DB2Connection(connectString)
D) DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd;Pooling=100;" Dim conn As DB2Connection = new DB2Connection(connectString)

질문과 대답: