File Info
| Exam | DB2 11 Fundamentals for z/OS |
| Number | C2090-320 |
| File Name | IBM.C2090-320.Prep4Sure.2018-09-21.27q.tqb |
| Size | 448 KB |
| Posted | Sep 21, 2018 |
| Download | IBM.C2090-320.Prep4Sure.2018-09-21.27q.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
Which of the following is NOT TRUE?
- An index can be created on XML columns
- Length must be specified for an XML column
- XML columns can be added to existing tables
- Triggers can be created on tables with XML columns
Correct answer: D
Question 2
Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?
Correct answer: D
Question 3
The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE.
Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?
- SELECT * FROM MYUSER.EMP;
- CONNECT TO MYREMOTE;SELECT * FROM MYUSER.EMP;
- SELECT * FROM MYUSER.MYREMOTE.EMP;
- CREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP;SELECT * FROM MYUSER.EMP_ALIAS;
Correct answer: B
