IBM DB2 11.1 DBA for LUW (C2090-600) - IBM

Exam Questions

94%

Students found the real exam almost the same

1,057

Students passed this exam after ExamsQA Prep

95.1%

Average score during Real Exams at the Testing Centre

Browse 60 Questions
💡

Browse at least 50% questions to maximize your chances of passing

Free Preview Questions

Sample C2090-600 Exam Questions & Explanations

Practice with real question formats, multiple choice options, and detailed answer explanations for IBM C2090-600.

Question #1 Verified Q&A
Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?
A UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE
B ATTACH TO db2inst1;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;
C CONNECT TO sample;UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC<br /> IMMEDIATE;CONNECT RESET;
D UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
Correct Answer: CONNECT TO sample;UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC<br /> IMMEDIATE;CONNECT RESET;
Question #2 Verified Q&A
Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)
A Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage
B Catalog a storage access alias in the DB2 database
C Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
D Use the DB2REMOTE parameter of the LOAD command
E Create an FTP account on IBM Softlayer Object Storage
Correct Answer: Catalog a storage access alias in the DB2 database, Use the DB2REMOTE parameter of the LOAD command
Question #3 Verified Q&A
Which of the following statements about compression for BLU MPP tables is TRUE?
A Compression must be explicitly enabled for BLU MPP tables
B Each table has a single compression dictionary that getsreplicated across all partitions
C Unique compression dictionaries are generated for each partition
D Compression requires decompression to evaluate partition joins
Correct Answer: Each table has a single compression dictionary that getsreplicated across all partitions
Question #4 Verified Q&A
A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity (inserts, updates, and deletes). Sunday – Delta Monday – Incremental Tuesday – Delta Wednesday – Delta Thursday – Incremental Friday – Delta Saturday – Full<br />
<br />
Which day would you expect a RECOVER DATABASE following that day’s backup to take the longest time to complete?
A Friday
B Wednesday
C Saturday
D Monday
Correct Answer: Friday
Question #5 Verified Q&A
Which statement about NOT ENFORCED unique constraints is TRUE?
A NOT ENFORCED unique constraints can not be defined on primary key columns
B Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index
C When attempting to insert data that does not conform to a NOT ENFORCED unique constraint,<br /> awarning will be returned
D The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan
Correct Answer: NOT ENFORCED unique constraints can not be defined on primary key columns

Want to practice all 60 questions?

Practice under real exam conditions with instant grading, timed simulations, and community insights.

Start Full C2090-600 Practice Test

Frequently Asked Questions

Common questions about the IBM C2090-600 certification practice test

How many questions are in the IBM C2090-600 practice exam on ExamsQA?
Our C2090-600 (IBM DB2 11.1 DBA for LUW) practice question bank currently includes 60 verified questions with comprehensive explanations.
Are the C2090-600 exam practice questions up to date for 2026?
Yes, all IBM C2090-600 practice questions are regularly updated and verified against current exam objectives.
Will the C2090-600 practice questions help me pass on my first attempt?
The C2090-600 (IBM DB2 11.1 DBA for LUW) question bank is built to mirror the real exam's format and topics, with detailed explanations for every answer so you understand the reasoning — not just memorize responses.
Is there a free demo available for C2090-600 IBM DB2 11.1 DBA for LUW?
Yes, ExamsQA offers free demo questions for the C2090-600 exam so you can test the interface and question quality before purchasing full access.