Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-600

IBM C2090-600 Exam
IBM DB2 11.1 DBA for LUW (Page 4 )

Updated On: 1-Feb-2026
Page 2 of 13
PDF with 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



When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?

  1. UPDATE DB CFG USING MON_OBJ_METRICS BASE
  2. UPDATE DB CFG USING MON_ACT_METRICS BASE
  3. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
  4. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON

Answer(s): C



Which statement about Data Server Manager (DSM) is TRUE?

  1. DSM can be used for reviewing audit trails
  2. DSM cannot be used for database administration
  3. DSM can be used for configuration management of DB2 Data Server drivers
  4. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue

Answer(s): D


Reference:

https://www.ibm.com/developerworks/data/library/techarticle/dm-1503db2-data-server/index.html (conclusion)



What is the result of the following scenario?

  1. The row is updated to (2, NULL)
  2. The row is updated to (2, 110.00)
  3. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed
  4. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL

Answer(s): B



On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

  1. As the db2 instance owner (db2inst1) execute the command:export DB2_FMP_COMM_HEAPSZ=256000
  2. Add to the following line to the userprofile (db2inst1):
    DB2_FMP_COMM_HEAPSZ=256000
  3. As the db2 instance owner (db2inst1)
    execute the command: db2set –i DB2_FMP_COMM_HEAPSZ=256000
  4. As the db2 instance owner (db2inst1) execute the command:
    db2set –i db2inst1 DB2_FMP_COMM_HEAPSZ=256000

Answer(s): C



Viewing page 4 of 13
Viewing questions 16 - 20 out of 60 questions



Post your Comments and Discuss IBM C2090-600 exam prep with other Community members:

Join the C2090-600 Discussion