Download IBM.C2090-600.PassGuide.2019-02-26.60q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-600 |
| Exam Name: | IBM DB2 11.1 DBA for LUW |
| Date: | Feb 26, 2019 |
| File Size: | 346 KB |
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
