IBM Assessment: DB2 9.7 Application Development - A2090-543 Exam Practice Test
Which two commands can be used to make use of the latest statistics? (Choose two.)
Correct Answer: A,D
Vote an answer
An application must insert values into a column that has a TIMESTAMP data type. What is a valid string representation of a TIMESTAMP?
Correct Answer: A
Vote an answer
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?
UPDATE address SET number_street =
(SELECT address FROM employee
WHERE address.empid = employee.empid)
WHERE number_street IS NULL
Which comment is true?
Correct Answer: B
Vote an answer
Click the Exhibit button. PRODUCTS ID NAME QUANTITY
1 Orange juice 30
2 Milk 25 Given the table shown in the exhibit.
Which values will be returned by query shown below?
SELECT XMLGROUP(
id as "Id",name as "Name",quantity as "Quantity"
OPTION ROW "Product") as Products
FROM products
1 Orange juice 30
2 Milk 25 Given the table shown in the exhibit.
Which values will be returned by query shown below?
SELECT XMLGROUP(
id as "Id",name as "Name",quantity as "Quantity"
OPTION ROW "Product") as Products
FROM products
Correct Answer: B
Vote an answer
Which two C# .NET code snippets illustrate the valid execution of a SQL statement through the IBM Data Server Provider for .NET? (Choose two.)
Correct Answer: B,D
Vote an answer
A database contains two tables with the same definition and authorities: PRODUCTION.SALESDATA and TEST.SALESDATA. The PRODUCTION.SALESDATA table contains business-critical information that is constantly changing; the TEST. SALESDATA table contains a snapshot of the PRODUCTION.SALESDATA table. Business rules require that applications under development access the TEST.SALESDATA table until ready for deployment. Once an application is deployed, it accesses the PRODUCTION.SALESDATA table. Which object can be used to simplify switching between the TEST.SALESDATA and PRODUCTION.SALESDATA tables without having to re-code the application?
Correct Answer: D
Vote an answer
In a PHP script, which ibm_db2 functions can be used to retrieve the result set of a query executed against a database table?
Correct Answer: B
Vote an answer
Click the Exhibit button.
CREATE TABLE gradereport(sid INTEGER, info XML);
INSERT INTO gradereport VALUES (1,
'<studentinfo sid="1">
<name>John Smith</name>
<honours>No</honours>
<grades>
<course><name>ECE100</name><grade>80</grade></course>
<course><name>CSC100</name><grade>70</grade></course>
<course><name>MAT100</name><grade>75</grade></course>
</grades>
<phone type="mobile">416-333-8725</phone>
</studentinfo>');
Given the statements shown in the exhibit, a user wishes to obtain the following result:
<student><name>John Smith</name><phone>416-333-8725</phone></student>
Which query can the user execute to achieve this?
CREATE TABLE gradereport(sid INTEGER, info XML);
INSERT INTO gradereport VALUES (1,
'<studentinfo sid="1">
<name>John Smith</name>
<honours>No</honours>
<grades>
<course><name>ECE100</name><grade>80</grade></course>
<course><name>CSC100</name><grade>70</grade></course>
<course><name>MAT100</name><grade>75</grade></course>
</grades>
<phone type="mobile">416-333-8725</phone>
</studentinfo>');
Given the statements shown in the exhibit, a user wishes to obtain the following result:
<student><name>John Smith</name><phone>416-333-8725</phone></student>
Which query can the user execute to achieve this?
Correct Answer: A
Vote an answer
In a query, which clause can reference a CLOB data type?
Correct Answer: D
Vote an answer
Which statement(s) will create and bind the package for the program myprogram.sqc?
Correct Answer: D
Vote an answer