Download IBM.C2090-543.PracticeTest.2018-08-11.54q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-543 |
| Exam Name: | DB2 9.7 Application Development |
| Date: | Aug 11, 2018 |
| File Size: | 244 KB |
Demo Questions
Question 1
Click the Exhibit button.
CREATE FUNCTION deptemployees (idept VARCHAR(3))
RETURNS TABLE (empno CHAR(6),
firstname VARCHAR(12),
lastname VARCHAR(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?
- SELECT * FROM TABLE(deptemployees('D11'))
- SELECT * FROM deptemployees('D11')
- SELECT * FROM deptemployees('D11') AS D11dept
- SELECT * FROM TABLE(deptemployees('D11')) AS D11dept
Correct answer: D
Question 2
An application must insert values into a column that has a TIMESTAMP data type.
What is a valid string representation of a TIMESTAMP?
- 2009.08.07.12.22.22.0000
- 2009-08-07 12:22:22.0000
- 07/08/2009-12:22:22:0000
- 07-08-2009 12.22.22.0000
Correct answer: B
Question 3
In a query, which clause can reference a CLOB data type?
- an ORDER BY clause
- a GROUP BY clause
- a WHERE clause
- a DISTINCT clause
Correct answer: C
