IBM C2090-543 試験概要:

IBM C2090-543 試験シラバストピック:

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

問題 #1
Click the Exhibit button.
CREATE TABLE prod_type (prod_type VARCHAR(10), description VARCHAR (30));
CREATE TABLE prod_descr(info XML);
INSERT INTO prod_descr VALUES
('<product id="1">
<name>Orange juice</name>
<company>Orange Garden</company>
<type>Drinks</type>
</product>'),
('<product id="2">
<name>Coke</name>
<company>Best drinks</company>
<type>Drinks</type>
<type>Premium</type>
</product>');
INSERT INTO prod_type VALUES ('Drinks','Drinks');
You execute the SQL statement shown in the exhibit.
Which two statements will return rows? (Choose two.)

A. SELECT name, company, description FROM
prod_type, prod_descr, XMLTABLE(
'$INFO/product'
COLUMNS
name VARCHAR(20) PATH './name',
company VARCHAR(20) PATH './company'
)
WHERE
prod_type= XMLCAST (XMLQUERY('$INFO/product/type') AS VARCHAR(10));
B. SELECT name, company, description FROM
prod_type, prod_descr, XMLTABLE(
'$INFO/product[type=$PROD_TYPE]'
COLUMNS
name VARCHAR(20) PATH './name',
company VARCHAR(20) PATH './company'
);
C. SELECT name, company, description FROM
prod_type, prod_descr, XMLTABLE(
'$INFO/product'
COLUMNS
type VARCHAR(10) PATH './type',
name VARCHAR(20) PATH './name',
company VARCHAR(20) PATH './company'
)
WHERE
type=prod_type;
D. SELECT name, company, description FROM
prod_type, prod_descr, XMLTABLE(
'$INFO/product'
COLUMNS
name VARCHAR(20) PATH './name',
company VARCHAR(20) PATH './company'
)
WHERE
XMLEXISTS('$INFO/product[type = $PROD_TYPE]');

問題 #2
Table T1 and views V1 and V2 were created by executing the statements shown below:
CREATE TABLE t1 (c1 INT, c2 CHAR(3));
CREATE VIEW v1 AS SELECT c1, c2 FROM t1 WHERE c1 > 100;
CREATE VIEW v2 AS SELECT * FROM v1 WHERE c2 IS NULL WITH
CASCADED CHECK OPTION;
Which statement will execute successfully?

A. INSERT INTO v2 VALUES (100, 'abc')
B. INSERT INTO v2 VALUES (125, 'abc')
C. INSERT INTO v2 VALUES (125, NULL)
D. INSERT INTO v2 VALUES (100, NULL)

問題 #3
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. SELECT statements can be included in batch update operations.
C. ResultSet objects can be used to retrieve values generated by CallableStatement objects in a batch.
D. TheaddBatch() method can be used to add a set of input parameter values to the batch.

問題 #4
Which CLI/ODBC function would be used to update multiple rows in a table?

A. SQLExecute()
B. SQLUpdate()
C. SQLExecBatch()
D. SQLBulkUpdate()

問題 #5
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 2; User USER2 obtains the value 4
B. User USER1 obtains the value 2; User USER2 obtains the value 2
C. User USER1 obtains the value 2; User USER2 obtains the value 3
D. User USER1 obtains the value 3; User USER2 obtains the value 4
E. User USER1 obtains no value; User USER2 obtains no value

解説：