IBM A2090-543 valid exam dumps : Assessment: DB2 9.7 Application Development

Click the Exhibit button.
CREATE TABLE store(sid INTEGER, info XML);
INSERT INTO store VALUES (1,
'<storeinfo sid="1">
<name>Grocery A</name>
<items>
<fruit><name>Mango</name><price>1.20</price></fruit>
<fruit><name>Apple</name><price>0.50</price></fruit>
<dessert><name>Ice Cream</name><price>6.00</price></dessert>
</items>
</storeinfo>');
Given the statements shown in the exhibit, a user executes the query shown below:
XQUERY for $store in db2-fn:xmlcolumn('STORE.INFO')/storeinfolet $items := $store/items/fruit,
$count := fn:count($items) return <itemcount>$count</itemcount> What is the output?

• A. 2
• B. 2
• C. 1
• D. $count

Click the Exhibit button.
CONNECT TO test;
CREATE TABLE colors (id INT NOT NULL PRIMARY KEY,
descVARCHAR(12));
CREATE TABLE objects(desc VARCHAR(12),
c_idINT REFERENCES colors (id)
ON UPDATE NO ACTION);
INSERT INTO colors VALUES (1, 'Red'), (2, 'Yellow'), (3, 'Blue');
INSERT INTO objects VALUES ('Fire Engine', 1), ('Rain Coat', 2);
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in
the exhibit was executed successfully.
The statement shown below is executed:
UPDATE colors SET id = id - 1;
How many rows will be modified in the COLORS table?

• A. 0
• B. 2
• C. 3
• D. 1

Click the Exhibit button. CREATE TABLE s1.mytab (col1 INTEGER GENERATED ALWAYS AS IDENTITY, col2 INTEGER, col3 INTEGER, CHECK (col1+col3 < 500) CREATE VARIABLE s1.var1 INTEGER DEFAULT (99) CREATE FUNCTION s1.add100 (p1 INT, p2 INT) RETURNS INTEGER LANGUAGE SQL DETERMINISTIC NOT FENCED BEGIN SET p1= p2+100; RETURN p1;END Given the table, variable, and function definitions shown in the exhibit, which two statements contain a valid invocation of the add100 function? (Choose two.)

• A. SELECT col1, add100(col2,col3) ASoutcol FROM mytab
• B. SELECT outcol.* FROM TABLE(add100(col2,col3)) ASoutcol
• C. SELECT col1,outcol=add100(col2,col3) FROM mytab
• D. SET var1 = ABS(add100(1,99))

Which return codes will be returned by SQLFetch() when there are no more records to be retrieved in a result data set?

• A. SQL_WARNING
• B. SQL_NO_DATA_FOUND
• C. SQL_NO_MORE_DATA
• D. SQL_SUCCESS

What are two valid connection options that you can use while creating a connection in PHP using the IBM_DB2 extension? (Choose two.)

• A. "CURSOR" => DB2_SCROLLABLE_SENSITIVE
• B. "DB2_ATTR_CASE" => DB2_CASE_UPPER
• C. "trustedcontext" => DB2_TRUSTED_CONTEXT_ENABLE
• D. "autocommit" => DB2_AUTOCOMMIT_FALSE