Download IBM.C2090-543.PassGuide.2018-06-28.53q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-543 |
| Exam Name: | DB2 9.7 Application Development |
| Date: | Jun 28, 2018 |
| File Size: | 262 KB |
Demo Questions
Question 1
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 2
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
Question 3
You have set your data types as CHAR(10), VARCHAR(20). Given the operation shown below:
CHAR(10) UNION VARCHAR(20)
What will be the final data type?
- CHAR(200)
- VARCHAR(30)
- VARCHAR(20)
- CHAR(30)
Correct answer: C
