IBM C2090-543 valid exam dumps : DB2 9.7 Application Development

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, 'Blue'), (3, 'Yellow'), (4, 'Green');
INSERT INTO objects VALUES ('Fire Engine', 1), ('Grass', 4), ('Banana', 3);
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 records will be modified?

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

A table named INVENTORY was created by executing the SQL statement shown below:
CREATE TABLE inventory (part_no INTEGER, quantity INTEGER, price DECIMAL(7,2), status
CHAR(2));
If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY to zero, which
SQL statement updates the INVENTORY table to indicate that all items with part numbers below
150 are out of stock?

• A. UPDATE inventory SET status = NULL, SET quantity = 0 WHEREpart_no < 150
• B. UPDATE inventory SET (status, quantity) = (NULL, 0) WHEREpart_no < 150
• C. UPDATE inventory SET (status, quantity) = ('NULL', 0) WHEREpart_no < 150
• D. UPDATE inventory SET status = 'NULL', quantity = 0 WHEREpart_no < 150

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. SQLFetchNext()
• C. SQLGetSubString()
• D. SQLGetData()

Click the Exhibit button. CREATE FUNCTION deptemployees (idept VARCHAR(3)) RETURNS TABLE (empno CHAR(6), firstnameVARCHAR(12), lastnameVARCHAR(15)) LANGUAGE SQL READS SQL DATA NO EXTERNAL ACTION DETERMINISTIC RETURN SELECT empno, firstnme, lastname FROM employee WHERE workdept = deptemployees.idept; Referring to the exhibit, what contains the proper way to invoke the DEPTEMPLOYEES() user-defined function to return all of the employees that work in department D11?

• A. SELECT * FROM TABLE(deptemployees('D11')) AS D11dept
• B. SELECT * FROM TABLE(deptemployees('D11'))
• C. SELECT * FROMdeptemployees('D11') AS D11dept
• D. SELECT * FROMdeptemployees('D11')

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

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