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

Which three data types are supported as output of the XMLSERIALIZE function? (Choose three.)

• A. CLOB
• B. BLOB
• C. DOUBLE
• D. GRAPHIC
• E. CHAR

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

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

Click the Exhibit button.
CONNECT TO test;
CREATE TABLE parent (empno CHAR(6), firstname VARCAHR(25), lastname VARCHAR(25));
CREATE TABLE child (childno CHAR(6), firstname VARCHAR(25), lastname VARCHAR(25),
empno
CHAR(6));
CREATE VIEW employee AS SELECT * FROM parent;
CREATE VIEW employee_children AS SELECT * FROM child;
COMMIT;
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in
the exhibit was executed successfully.
Which technique can be used to produce a list of all employees and their children, including
employees who have no children?

• A. LEFT or RIGHT OUTER JOIN
• B. INNER JOIN
• C. MERGE JOIN
• D. FULL OUTER JOIN

An application must insert values into a column that has a TIMESTAMP data type. What is a valid string representation of a TIMESTAMP?

• A. 2009-08-07 12:22:22.0000
• B. 07/08/2009-12:22:22:0000
• C. 2009.08.07.12.22.22.0000
• D. 07-08-2009 12.22.22.0000

The table shown below contains a large number of financial transactions: CREATE TABLE webstore.transactions (transaction_id INTEGER NOT NULL PRIMARY KEY, order_date TIMESTAMP NOT NULL, shipped_date TIMESTAMP, customer_id INTEGER NOT NULL, shipping_info XML NOT NULL, billing_info XML NOT NULL, invoice XML NOT NULL ) Only members of the AUDIT_TEAM group have SELECT privilege on the WEBSTORE.TRANSACTIONS table. For appropriate supply-chain management, members of the INVENTORY_CONTROL group need to see the INVOICE document for each transaction that has a NULL SHIPPED_DATE, but are restricted from seeing any shipping or billing information. Which database object can a member of the AUDIT_TEAM group create to enable the INVENTORY_CONTROL group to access the information needed from WEBSTORE.TRANSACTIONS?

• A. view
• B. sequence
• C. alias
• D. trigger