IBM Assessment: DB2 9.7 Application Development - A2090-543 FREE EXAM DUMPS QUESTIONS & ANSWERS

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

Click the Exhibit button.
CREATE TABLE store(sid INTEGER, info XML);
INSERT INTO store VALUES (1,
'<storeinfo sid="1">
<name>ABCDEF</name>
</storeinfo>');
INSERT INTO store VALUES (2,
'<storeinfo sid="2">
<name>FEDCBA</name>
</storeinfo>');
Given the statements shown in the exhibit, a user executes the query shown below:
XQUERY for $store in db2-fn:xmlcolumn('STORE.INFO')/storeinfo
let $name := fn:substring($store/name, 1, 3),
$lcase := fn:lower-case($name)
return $lcase
What is the output?

.While developing a CLI application, you use the code shown below:
SQLCHAR *stmt = (SQLCHAR *)"DELETE FROM org WHERE deptnumb = ? ";
cliRC= SQLSetStmtAttr(hstmt, SQL_ATTR_DEFERRED_PREPARE,
SQL_DEFERRED_PREPARE_ON )
cliRC= SQLPrepare(hstmt, stmt, SQL_NTS);
Now, the ORG table does not exist in the database.
What will be the value of "cliRC" after executing the SQLPrepare command?

Which statement is true of an application that only uses static SQL?

Given the SQL statement shown below:
UPDATE address SET number_street =
(SELECT address FROM employee
WHERE address.empid = employee.empid)
WHERE number_street IS NULL
Which comment is true?

A company has a requirement that will update data on multiple databases. The data currently
resides on databases that are part of the DB2 family of products.
What would be two minimum configurations needed to facilitate the correct update on all database
servers without loss of data integrity? (Choose two.)

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?

The statement below was used to create a cursor named CSR1:
DECLARE csr1 CURSOR FOR SELECT * FROM employee FOR UPDATE OF job;
When the cursor is opened, the result set contains six rows. After fetching all of the rows in the
result set associated with cursor CSR1, application TEST1 needs to fetch the third row of the
result set again.
Which steps will allow application TEST1 to fetch the third row again?

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

User USER1 successfully creates a table USER1.TABLE1 and successfully creates a package USER1.PKG1 for an application containing the SQL shown below: EXEC SQL UPDATE user1.table1 SET col1 =:hvar1 WHERE col1 IS NULL Assuming user USER2 can connect to the database, but has no other relevant authorities, which command must user USER1 issue to permit user USER2 to run the application?