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

1. Function XMLPARSE is used in a INSERT statement.
In which two situations will boundary whitespaces be stripped? (Choose two.)

A) When the PRESERVE WHITESPACE option is used.
B) When the CURRENT IMPLICIT XMLPARSE OPTION special register is set to 'STRIP WHITESPACE' and no XMLPARSE option is used.
C) When the STRIP WHITESPACE option is used, the XML element contains thexml:space="preserve" attribute.
D) When the STRIP WHITESPACE option is used, the XML element contains thexml:space="default" attribute.

2. In a PHP script, which ibm_db2 functions can be used to retrieve the result set of a query executed against a database table?

A) db2_execute()
B) db2_next_result()
C) db2_result()
D) db2_fetch_array()

3. 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>60</grade></course>
</grades>
<phone type="mobile">416-333-8725</phone>
</studentinfo>');
Given the statements shown in the exhibit, which two queries can be used to return the semester
average of the student? (Choose two.)

A) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
let $sum := fn:sum($studinfo/grades/course/grade),
$count := fn:count($studinfo/grades/course/grade)
return $sum div $count
B) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
let $average := fn:average($studinfo/grades/course/grade)
return $average
C) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
let $avg := fn:avg($studinfo/grades/course)
return $avg
D) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
let $avg := fn:avg($studinfo/grades/course/grade)
return $avg

4. A library keeps digital copies of books in the table shown below:
CREATE TABLE library.collection (
bookidINTEGER NOT NULL PRIMARY KEY,
ebook_contentBLOB(2G) )
A CLI/ODBC application is written that retrieves the EBOOK_CONTENT for a given BOOKID in
32K pieces.
Which two APIs can be used to perform the retrieval? (Choose two.)

A) SQLGetLength()
B) SQLGetData()
C) SQLGetSubString()
D) SQLFetchNext()

5. An application must perform maintenance on a table named EMPLOYEE. Which SQL statement can be used to restrict all activity on the EMPLOYEE table during maintenance by the application?

A) ALTER TABLE employee LOCK SIZE ROWS
B) LOCK TABLE employee IN SHARE MODE
C) ALTER TABLE employee LOCK SIZE TABLE
D) LOCK TABLE employee IN EXCLUSIVE MODE

質問と回答：