Download IBM.C2090-320.Prep4Sure.2018-09-21.27q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-320 |
| Exam Name: | DB2 11 Fundamentals for z/OS |
| Date: | Sep 21, 2018 |
| File Size: | 448 KB |
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
