Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. IBM
  3. C2090-600

IBM C2090-600 Exam (page: 1)
IBM DB2 11.1 DBA for LUW
Updated on: 12-Jan-2026

Viewing Page 1 of 13
C2090-600 PDF 60 Questions

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?

  1. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE
  2. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
  3. CONNECT TO sample;
    UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC IMMEDIATE; CONNECT RESET;
  4. ATTACH TO db2inst1;
    UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC; DETACH;

Answer(s): C



Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

  1. Catalog a storage access alias in the DB2 database
  2. Create an FTP account on IBM Softlayer Object Storage
  3. Use the DB2REMOTE parameter of the LOAD command
  4. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
  5. Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

Answer(s): A,C



Which of the following statements about compression for BLU MPP tables is TRUE?

  1. Compression must be explicitly enabled for BLU MPP tables
  2. Compression requires decompression to evaluate partition joins
  3. Unique compression dictionaries are generated for each partition
  4. Each table has a single compression dictionary that gets replicated across all partitions

Answer(s): D


Reference:

http://www.idug.org/p/bl/et/blogaid=503



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

Which day would you expect a RECOVER DATABASE following that day’s backup to take the longest time to complete?

  1. Friday
  2. Monday
  3. Saturday
  4. Wednesday

Answer(s): A



Which statement about NOT ENFORCED unique constraints is TRUE?

  1. NOT ENFORCED unique constraints can not be defined on primary key columns
  2. The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan
  3. When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, a warning will be returned
  4. Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

Answer(s): A



Viewing Page 1 of 13



Share your comments for IBM C2090-600 exam with other users:

sowm 10/29/2023 2:44:00 PM

impressivre qustion
Anonymous


CW 7/6/2023 7:06:00 PM

questions seem helpful
Anonymous


luke 9/26/2023 10:52:00 AM

good content
Anonymous


zazza 6/16/2023 9:08:00 AM

question 21 answer is alerts
ITALY


Abwoch Peter 7/4/2023 3:08:00 AM

am preparing for exam
Anonymous


mohamed 9/12/2023 5:26:00 AM

good one thanks
EGYPT


Mfc 10/23/2023 3:35:00 PM

only got thru 5 questions, need more to evaluate
Anonymous


Whizzle 7/24/2023 6:19:00 AM

q26 should be b
Anonymous


sarra 1/17/2024 3:44:00 AM

the aaa triad in information security is authentication, accounting and authorisation so the answer should be d 1, 3 and 5.
UNITED KINGDOM


DBS 5/14/2023 12:56:00 PM

need to attend this
UNITED STATES


Da_costa 8/1/2023 5:28:00 PM

these are free brain dumps i understand, how can one get free pdf
Anonymous


vikas 10/28/2023 6:57:00 AM

provide access
EUROPEAN UNION


Abdullah 9/29/2023 2:06:00 AM

good morning
Anonymous


Raj 6/26/2023 3:12:00 PM

please upload the ncp-mci 6.5 dumps, really need to practice this one. thanks guys
Anonymous


Miguel 10/5/2023 12:21:00 PM

question 16: https://help.salesforce.com/s/articleview?id=sf.care_console_overview.htm&type=5
SPAIN


Hiren Ladva 7/8/2023 10:34:00 PM

yes i m prepared exam
Anonymous


oliverjames 10/24/2023 5:37:00 AM

my experience was great with this site as i studied for the ms-900 from here and got 900/1000 on the test. my main focus was on the tutorials which were provided and practice questions. thanks!
GERMANY


Bhuddhiman 7/20/2023 11:52:00 AM

great course
UNITED STATES


Anuj 1/14/2024 4:07:00 PM

very good question
Anonymous


Saravana Kumar TS 12/8/2023 9:49:00 AM

question: 93 which statement is true regarding the result? sales contain 6 columns and values contain 7 columns so c is not right answer.
INDIA


Lue 3/30/2023 11:43:00 PM

highly recommend just passed my exam.
CANADA


DC 1/7/2024 10:17:00 AM

great practice! thanks
UNITED STATES


Anonymus 11/9/2023 5:41:00 AM

anyone who wrote this exam recently?
SOUTH AFRICA


Khalid Javid 11/17/2023 3:46:00 PM

kindly share the dump
Anonymous


Na 8/9/2023 8:39:00 AM

could you please upload cfe fraud prevention and deterrence questions? it will be very much helpful.
Anonymous


shime 10/23/2023 10:03:00 AM

this is really very very helpful for mcd level 1
ETHIOPIA


Vnu 6/3/2023 2:39:00 AM

very helpful!
Anonymous


Steve 8/17/2023 2:19:00 PM

question #18s answer should be a, not d. this should be corrected. it should be minvalidityperiod
CANADA


RITEISH 12/24/2023 4:33:00 AM

thanks for the exact solution
Anonymous


SB 10/15/2023 7:58:00 AM

need to refer the questions and have to give the exam
INDIA


Mike Derfalem 7/16/2023 7:59:00 PM

i need it right now if it was possible please
Anonymous


Isak 7/6/2023 3:21:00 AM

i need it very much please share it in the fastest time.
Anonymous


Maria 6/23/2023 11:40:00 AM

correct answer is d for student.java program
IRELAND


Nagendra Pedipina 7/12/2023 9:10:00 AM

q:37 c is correct
INDIA