File Info
| Exam | IBM DB2 11.1 DBA for LUW |
| Number | C2090-600 |
| File Name | IBM.C2090-600.VCEplus.2020-01-03.60q.tqb |
| Size | 348 KB |
| Posted | Jan 03, 2020 |
| Download | IBM.C2090-600.VCEplus.2020-01-03.60q.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
Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?
- UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE
- UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
- CONNECT TO sample;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC IMMEDIATE; CONNECT RESET;
- ATTACH TO db2inst1;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC; DETACH;
Correct answer: C
Question 2
Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)
- Catalog a storage access alias in the DB2 database
- Create an FTP account on IBM Softlayer Object Storage
- Use the DB2REMOTE parameter of the LOAD command
- Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
- Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage
Correct answer: AC
Question 3
Which of the following statements about compression for BLU MPP tables is TRUE?
- Compression must be explicitly enabled for BLU MPP tables
- Compression requires decompression to evaluate partition joins
- Unique compression dictionaries are generated for each partition
- Each table has a single compression dictionary that gets replicated across all partitions
Correct answer: D
Explanation:
Reference: http://www.idug.org/p/bl/et/blogaid=503 Reference: http://www.idug.org/p/bl/et/blogaid=503
