File Info
| Exam | DB2 9.7 Application Development |
| Number | C2090-543 |
| File Name | IBM.C2090-543.PracticeTest.2018-08-11.54q.tqb |
| Size | 244 KB |
| Posted | Aug 11, 2018 |
| Download | IBM.C2090-543.PracticeTest.2018-08-11.54q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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
