File Info
| Exam | DB2 11.1 Fundamentals for LUW |
| Number | C2090-616 |
| File Name | IBM.C2090-616.Test4Prep.2019-03-04.25q.tqb |
| Size | 93 KB |
| Posted | Mar 04, 2019 |
| Download | IBM.C2090-616.Test4Prep.2019-03-04.25q.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 editions of DB2 include support for Federation with Oracle database?
- DB2 Express-C
- DB2 Developer Edition
- DB2 Enterprise Server Edition
- DB2 Workgroup Server Edition
Correct answer: C
Explanation:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1311db2compare/index.html Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1311db2compare/index.html
Question 2
Which three facilities are used to control authorization in DB2?
- privileges, db2ssh, LBAC credentials
- privileges, authority levels, certificates
- db2ssh, trusted contexts, authority levels
- privileges, authority levels, LBAC credentials
Correct answer: D
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html
Question 3
A user executes the following statements:
СREATE TABLE t1 (c1 INT, c2 INT);
CREATE ALIAS a1 FOR t1;
What will be the result if the user executes the following statement?
DROP ALIAS a1;
- The alias A1 will be dropped
- The table T1 will be dropped
- Both T1 and A1 will be dropped
- Nothing, the statement will result in an error
Correct answer: A
Explanation:
